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.

  1. Question 1Cells and Ranges

    The default file extension of an Excel 2007+ workbook is

  2. Question 2Cells and Ranges

    The intersection of a row and a column in Excel is a

  3. Question 3Cells and Ranges

    The cell reference B3 means

  4. Question 4Cells and Ranges

    A group of selected cells such as A1:C5 is called a

  5. Question 5Cells and Ranges

    A workbook contains

  6. Question 6Cells and Ranges

    The active cell's address is shown in the

  7. Question 7Formulas and Functions

    Every formula in Excel begins with

  8. Question 8Formulas and Functions

    The function that adds the values in a range is

  9. Question 9Formulas and Functions

    The function that finds the average is

  10. Question 10Formulas and Functions

    The function that gives the highest value in a range is

  11. Question 11Formulas and Functions

    The function that counts cells containing numbers is

  12. Question 12Formulas and Functions

    A cell reference that does not change when copied is

  13. Question 13Formulas and Functions

    What is the result of =10+5*2 in Excel?

  14. Question 14Formulas and Functions

    What is the result of =SUM(2,3,5)?

  15. Question 15Charts and Features

    The feature used to show data as bars, lines or pies is a

  16. Question 16Charts and Features

    The feature that shows only rows meeting a condition is

  17. Question 17Charts and Features

    The feature to arrange data in order is

  18. Question 18Charts and Features

    The tool that summarises large data in a table is

  19. Question 19Charts and Features

    The key to edit the active cell is

  20. Question 20PYQ - (RPSC Protection Officer 2018 General Studies Paper-I)

    Previous year questions are for signed-in visitors. Sign in to practise this one.