Category Archives: MS Excel MCQs

In Microsoft Excel the Intersection of columns and rows is called a?

A. Data
B. Table
C. Cell
D. Scheme

In MS Excel 2016, zoom level of a page can only be?

A. 10 Percent to 300 percent
B. 5 percent to 100 percent
C. 10 percent to 400 percent
D. 5 percent to 300 percent

Which of the following Excel feature allows user to evaluate values and return a result?

A. Formulas
B. Formatting
C. Filters
D. Insertions

______ users can open MS Excel 2016 file at the same time?

A. 100
B. 50
C. 256
D. None of these

When an Excel workbook is linked to a Word document?

A. The Word document contains a copy of the actual data
B. The word document cannot be edited
C. The word document must contain a hyperlink
D. The word document contains a reference to the original source application

Which of the following is not a function in Microsoft Excel?

A. SUM
B. MAX
C. MIN
D. AVG

In MS Excel, to create a formula, you can use?

A. Value but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Both value and cell reference

In MS Excel you can zoom from?

A. 10 to 300%
B. 10 to 400%
C. 20 to 500%
D. None of these

In MS Excel 2016, mainly ____types of ‘page Orientation’ are available?

A. 2
B. 3
C. 4
D. None of these

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

A. The word document cannot be edited
B. To Word document contains a reference to the original source application
C. The word document must contain a hyperlink
D. The word document must contains a copy of the actual data