MCIS excel test (1)

MCIS excel test
When excel opens, a new blank ____ is displayed. - CORRECT ANSWER-workbook

Ina workbook, pages are referred to as ___ - CORRECT ANSWER-worksheets

In excel the term worksheet and ___ mean the same thing - CORRECT
ANSWER-spreadsheet

When identifying a cell as B5, you are using its ____. - CORRECT ANSWER-cell
address

A cell that is outlined in green and has data typed in it is the ____ cell. - CORRECT
ANSWER-active

When a cell is active, its column and row headings are ____. - CORRECT
ANSWER-Shaded

The bar, located below the Ribbon, that displays the active cell's content is the ____.
- CORRECT ANSWER-formula bar

The cell content shown in the formula bar is referred to as the ___ value -
CORRECT ANSWER-underlying

If content exists in cell B1, and a long text value is entered into cell A1, the display is
____ - CORRECT ANSWER-truncated

Two or more adjacent cells in a worksheet are a ___. - CORRECT ANSWER-range

Which cells are included in the notation A1:D1? - CORRECT ANSWER-A1, B1, C1,
and D1

Which symbol inserted between two cell addresses indicates a range? - CORRECT
ANSWER-colon

The Merge and Center button is in the ____ group on the Home tab - CORRECT
ANSWER-alignment

When a range is selected, the name box displays the cell address of _____ -
CORRECT ANSWER-the first cell in the range

An underlying value that does mathematical calculations on numeric values in a
worksheet is ____ - CORRECT ANSWER-a formula

, The ____ displays a list of functions that match the first letter typed. - CORRECT
ANSWER-Formula AutoComplete feature

When a cell is part of an active function, it is ___ - CORRECT ANSWER-Surrounded
by a moving border

Placing content in a cell can be done by pressing the Enter key or by clicking the
____ - CORRECT ANSWER-Enter button

The symbol on the Enter button is a - CORRECT ANSWER-checkmark

When a formula is in an active cell, the underlying formula is visible in the ____ -
CORRECT ANSWER-formula bar

Themed cell styles is an option in the ____ - CORRECT ANSWER-cell styles gallery

which feature displays the formatting of the style moused over in the cell styles
gallery on the selected cells in the worksheet? - CORRECT ANSWER-live preview

which is an example of an excel function? - CORRECT ANSWER-=SUM(D6:D8)

The ___ button inserts a function that sums selected cells - CORRECT
ANSWER-AutoSum

When no cells are selected and the AutoSum button is clicked, excel first looks ____
the active cell for a suitable range to sum - CORRECT ANSWER-above

Which cells are included in the sum calculated by the function =SUM(D5:G5)? -
CORRECT ANSWER-D5, E5, F5, G5

Which term is used to refer to automatic adjustment of cell reference in a copied
formula? - CORRECT ANSWER-relative cell reference

When a row is inserted into a worksheet, the ___ of the row above is applied to the
inserted row. - CORRECT ANSWER-formatting

After the fill handle is used to copy cell content, the ___ button appears to the right of
the selected cells - CORRECT ANSWER-Auto Fill Options

Which is NOT an option in the Auto Fill Options menu? - CORRECT
ANSWER-Paste Cells

Select the ___ option from the Auto Fill Options menu to keep numeric values
unchanged when using the fill handle - CORRECT ANSWER-Copy Cells