Module 2 Study Guide

In Excel, MAX and AVERAGE are examples of _____.

Which formula contains a mixed cell reference?

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

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

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

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

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?

All functions begin with the formula prefix ____.

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

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

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

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?

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

Excel templates include which of these common documents?

Which keyboard shortcut turns on edit mode?

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

Which of the following is a complex formula?

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

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.

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

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

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

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

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