question

Functions

answer

In Excel, MAX and AVERAGE are examples of _____.

question

($A6+$A$7)*0.20

answer

Which formula contains a mixed cell reference?

question

All of the above

answer

The COUNTA function is used to count the number of cells in a range that contain which type of data?

question

(G15-G14)

answer

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

question

HOME

answer

To insert cells, click the Insert list arrow in the Cells group on the _____ tab, then click Insert Cells.

question

The clipboard automatically deletes the oldest item on the clipboard

answer

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

question

[F4]

answer

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

question

= (equal sign)

answer

All functions begin with the formula prefix ____.

question

The data remains in its original location

answer

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

question

Manually typing the function

answer

Which method of entering a function requires the user to know the name and initial characters of a function?

question

The number of decimal places in the rounded number

answer

In the formula =ROUND(D4:F4,0), what does the zero indicate?

question

=(C12+C13)*F4

answer

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

question

Relative

answer

A ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

question

All of the above

answer

Excel templates include which of these common documents?

question

[F2]

answer

Which keyboard shortcut turns on edit mode?

question

Cell references are automatically adjusted

answer

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

question

=(B4/B8)*10

answer

Which of the following is a complex formula?

question

Typing the function argument

answer

Functions can be entered for formulas using all of the following methods except ____.

question

$

answer

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

question

Pasting cell selectors

answer

Which of the following is NOT a Paste list arrow option?

question

Data

answer

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

question

.xlsx

answer

The default file extension for an Excel 2016 workbook is ____.

question

Home tab

answer

Which tab and group will allow the insertion of rows and columns in a worksheet?

question

Excel template

answer

The file extension .xltx indicates what type of Excel file?