Quiz 5- Excel Modules 1 And 2

The Excel operator for division is ____.

____ operators perform mathematical calculations such as adding and subtracting.

To quickly jump to the first cell in a worksheet press ____.

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _____.​

The name Peter is entered in cell B4. This is a ____.

A named range must begin with a letter or a(n) _____.​

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

The entry in cell B15 is =SUM(B5:B14) which is a ____.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

You can edit the contents of the active cell by ____.

The _____ sheet button allows you to add worksheets to a workbook.​

The Excel operator for exponent is ____.

In Excel, the electronic spreadsheet you work in is called a ____.

Possible paper orientations for printing a worksheet are landscape and ____.

In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

The Undo button allows you to reverse up to ____ previous actions, one at a time.

To display gridlines on a worksheet, click the Gridlines check box in the _____ group on the View tab.​

A(n) ____ is a built-in formula that uses arguments to calculate information.

Excel recognizes an entry as a value if it is a number or it begins with ____.

You can use ____ to move around in a document that is too large to fit on the screen at once.

In Excel, a worksheet is contained in a file called a ____.

You can use the ____ key(s) on the keyboard to navigate a worksheet.

You can use predesigned, formatted files called ____ to create new worksheets quickly.

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.

An Excel user should use a relative cell reference when it is important to ____.

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

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Which of the following is a complex formula?

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

Which type of cell reference preserves the exact cell address in a formula?

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?

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

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

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

All functions begin with the formula prefix ____.

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

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

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

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

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

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

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

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

In the formula =D1+C1/F3, which calculation will be performed first?

In Excel, MAX and AVERAGE are examples of ____.

Which keyboard shortcut turns on Edit mode?

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

Excel templates include which of these common documents?

You can change, or ____, the contents of an active cell at any time.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

To move one screen to the left press ____.

The ____ option helps fit the data on a single page without making changes to individual margins.

A(n) ____ is an entry in a cell that contains text such as "2016 Sales" or "Travel Expenses."

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

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

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?

Which formula contains a mixed cell reference?