Computer Knowledge
MS Excel Questions
Pick an answer to see if you're right and why.
See whether each answer is right, with the explanation, as soon as you pick it.
- Question 1Cells and Ranges
The default file extension of an Excel 2007+ workbook is
- Question 2Cells and Ranges
The intersection of a row and a column in Excel is a
- Question 3Cells and Ranges
The cell reference B3 means
- Question 4Cells and Ranges
A group of selected cells such as A1:C5 is called a
- Question 5Cells and Ranges
A workbook contains
- Question 6Cells and Ranges
The active cell's address is shown in the
- Question 7Formulas and Functions
Every formula in Excel begins with
- Question 8Formulas and Functions
The function that adds the values in a range is
- Question 9Formulas and Functions
The function that finds the average is
- Question 10Formulas and Functions
The function that gives the highest value in a range is
- Question 11Formulas and Functions
The function that counts cells containing numbers is
- Question 12Formulas and Functions
A cell reference that does not change when copied is
- Question 13Formulas and Functions
What is the result of =10+5*2 in Excel?
- Question 14Formulas and Functions
What is the result of =SUM(2,3,5)?
- Question 15Charts and Features
The feature used to show data as bars, lines or pies is a
- Question 16Charts and Features
The feature that shows only rows meeting a condition is
- Question 17Charts and Features
The feature to arrange data in order is
- Question 18Charts and Features
The tool that summarises large data in a table is
- Question 19Charts and Features
The key to edit the active cell is
- Question 20PYQ - (RPSC Protection Officer 2018 General Studies Paper-I)
Previous year questions are for signed-in visitors. Sign in to practise this one.