Microsoft Excel Expert - 3 days Quiz Questions and Answers

A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

Answer :
  • Range

What are the basic rectangular building blocks of a spreadsheet?

Answer :
  • Cells

MS-Excel uses the________function when creating a data table.

Answer :
  • Table

In MS-Excel, 3-D reference in a formula_______.

Answer :
  • spans worksheets

In MS-Excel, what chart object is a horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

Answer :
  • Gridline

In MS-Excel, a value used in a formula that does not change is called a_______.

Answer :
  • Constant

In MS-Excel, Chart wizard term data categories refer to______.

Answer :
  • A horizontal axis

In MS-Excel, which bar has the currency option?

Answer :
  • Formatting Toolbar

The typed text showed inactive cell and also in_______.

Answer :
  • Formula bar

Excel documents are stored as files called_______.

Answer :
  • Worksheets