question

The Excel operator for division is ____.

answer

/

question

____ operators perform mathematical calculations such as adding and subtracting.

answer

Arithmetic

question

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

answer

[Ctrl][Home]

question

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

answer

formula bar

question

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

answer

label

question

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

answer

underscore ( _ )

question

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

answer

100

question

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

answer

sheet tabs

question

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

answer

formula

question

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

answer

5

question

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

answer

just starting to type

question

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

answer

new

question

The Excel operator for exponent is ____.

answer

^

question

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

answer

worksheet

question

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

answer

portrait

question

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

answer

value

question

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

answer

spreadsheet

question

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

answer

100

question

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

answer

show

question

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

answer

function

question

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

answer

$ , + , =
All of the above

question

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

answer

scroll bars

question

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

answer

workbook

question

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

answer

arrow

question

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

answer

templates

question

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.

answer

$

question

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

answer

preserve the relationship to the formula location

question

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

answer

manually typing the function

question

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

answer

fill handle

question

Which of the following is a complex formula?

answer

=(B4/B8)*10

question

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

answer

pasting cell selectors

question

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

answer

absolute

question

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?

answer

=(C12+C13)*F4

question

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

answer

Home tab, Cells group

question

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

answer

(G15-G14)

question

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

answer

the data remains in its original location

question

All functions begin with the formula prefix ____.

answer

= (equals sign)

question

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

answer

.xlsx

question

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

answer

cell references are automatically adjusted

question

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

answer

the number of decimal places in the rounded number

question

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

answer

typing the function argument

question

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

answer

data

question

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

answer

the clipboard automatically deletes the oldest item on the clipboard

question

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

answer

numbers, dates, formulas
all of the above

question

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

answer

excel template

question

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

answer

C1/F3

question

In Excel, MAX and AVERAGE are examples of ____.

answer

functions

question

Which keyboard shortcut turns on Edit mode?

answer

[F2]

question

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

answer

relative

question

Excel templates include which of these common documents?

answer

budgets, balance sheets, time cards
all of the above

question

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

answer

edit

question

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

answer

create what-if data scenarios

question

To move one screen to the left press ____.

answer

[Alt] [Page Up]

question

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

answer

scale to fit

question

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

answer

label

question

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

answer

zoom

question

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

answer

HOME

question

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?

answer

[F4]

question

Which formula contains a mixed cell reference?

answer

=($A6+$A$7)*0.20