Microsoft Excel MCQs with answers Page - 9

Here, you will find a collection of MCQ questions on Microsoft Excel. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 828.03K Points
Coach

Q. How do you select an entire column?

  • (A) Select Edit > Select > Column from the menu
  • (B) Click the column heading letter
  • (C) Hold down the shift key as you click anywhere in the column
  • (D) Hold down the Ctrl key as you click anywhere in the column

A

Admin • 828.03K Points
Coach

Q. How can you find specific information in a list?

  • (A) Select Tools > Finder from the menu
  • (B) Click the Find button on the standard toolbar
  • (C) Select Insert > Find from the menu
  • (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

A

Admin • 828.03K Points
Coach

Q. Multiple calculations can be made in a single formula using

  • (A) Standard formulas
  • (B) Array formula
  • (C) Complex formulas
  • (D) Smart formula

A

Admin • 828.03K Points
Coach

Q. When you link data maintained in an excel workbook to a word document

  • (A) The word document cannot be edit
  • (B) The word document contains a reference to the original source application
  • (C) The word document must contain a hyperlink
  • (D) The word document contains a copy of the actual data

A

Admin • 828.03K Points
Coach

Q. Which of the following is the oldest spreadsheet package?

  • (A) VisiCalc
  • (B) Lotus 1-2-3
  • (C) Excel
  • (D) StarCalc

A

Admin • 828.03K Points
Coach

Q. Excel files have a default extension of

  • (A) Xls
  • (B) Xlw
  • (C) Wk1
  • (D) 123

A

Admin • 828.03K Points
Coach

Q. Comments put in cells are called

  • (A) Smart tip
  • (B) Cell tip
  • (C) Web tip
  • (D) Soft tip

A

Admin • 828.03K Points
Coach

Q. To center worksheet titles across a range of cells, you must

  • (A) Select the cells containing the title text plus the range over which the title text is to be centered
  • (B) Widen the columns
  • (C) Select the cells containing the title text plus the range over which the title text is to be enfettered
  • (D) Format the cells with the comma style

A

Admin • 828.03K Points
Coach

Q. Text formulas

  • (A) Replace cell references
  • (B) Return ASCII values of characters
  • (C) Concatenate and manipulate text
  • (D) Show formula error value

A

Admin • 828.03K Points
Coach

Q. Rounding errors can occur

  • (A) When you use multiplication, division, or exponentiation in a formula
  • (B) Because excel uses hidden decimal places in computation
  • (C) When you use addition and subtraction in a formula
  • (D) When you show the results of formulas with different decimal places that the calculated results

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.