Skip to content

Computer · Microsoft Office & Productivity · page 23 of 41

MS Excel MCQs with Answers

Includes 136 past paper MCQs (marked).

Timed quizzes, instant results, track your progress — free

Practice these MCQs in the app

MS Excel MCQs (221–230)

10 MCQs with answers and a short one-liner. Hide answers to test yourself.

Past paper MCQs in this chapter · See all past papers

Answers and one-liners are hidden. Tap an option to check that question, or show all.

  1. 221.

    What are the vertical lines in an MS Excel worksheet called?

  2. 222.

    Which of the following is not a valid option to insert a hyperlink in MS Excel?

  3. 223.

    Past Paper MCQ

    Which of the following is a graphical representation of data in MS Excel?

  4. 224.

    Past Paper MCQ

    Which function in MS Excel 2016 calculates the average of all the cells in a range that meet specified criteria?

  5. 225.

    In MS Excel, what does the letter 'B' represent in the cell address B3?

  6. 226.

    Which function in Excel is used to compute the average of selected cells?

  7. 227.

    Which option is not available in the Paste Special dialog box in MS Excel?

  8. 228.

    In MS Excel, what is the term used for a saved set of different input values and their corresponding results?

  9. 229.

    Which of the following is the correct order of precedence in Excel formula calculation?

  10. 230.

    What is the term for text that provides additional information and is attached to a cell in MS Excel?

Start studying free