All Exams

Which of the following is an absolute cell reference?

$B$2

Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?

$F2

Which of the following is a valid 3D cell reference?

'Inventory#'!$B2

Which of the following criteria sums sales for all items that begin with the letter P?

*p

By default, what file name extension is given to Excel workbook files?

.xlsx

What are Excel's default top and bottom margin settings?

0.75

Which of the following has an answer of 8?

10-(3*2)

Which of the following has an answer of 8?

10-4/2

Which of the following has an answer of 14?

2+4*3

How many items can the Office Clipboard hold?

24

Which of the following has an answer of 11?

3+2*4

Which of the following references cells located in another worksheet in the same workbook?

3D cell reference

Which of the following is the constant in the formula =D5*85%?

85%

Which of the following characters always starts a formula?

=

Which of the following characters precedes Excel functions?

=

Which of the following formulas includes an absolute reference and a constant?

=$D$21+21

Which of the following provides an example of a mixed reference and a relative reference?

=$D21+E21

Which of the following formulas includes only relative references?

=D21+E21

Which of the following formulas correctly adds the values in cells E4 and E5?

=E4+E5

Which of the following options shows the correct syntax for the IF function?

=IF(C5<=20,7,10)

Which of the following shows the correct syntax for the ROUND function?

=ROUND(number,num_digits)

Which of the following displays in a cell when you click AutoSum?

=SUM()

Which of the following statements about circular references is false?

A workbook cannot be saved with a circular reference.

Which of the following functions adds all the values and divides the result by the number of values?

AVERAGE

Which of the following methods inserts a manual line break in a cell?

Alt+Enter

Which of the following features displays mathematical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?

AutoCalculate

Which of the following is a mixed cell reference?

B$2

Which of the following is a relative cell reference?

B2

Which of the following functions counts cells that meet the criteria arguments within a range?

COUNTIF

What key do you press to select non-adjacent worksheets?

Ctrl

Which of the following keyboard shortcuts opens the Format Cells dialog box?

Ctrl+1

Which of the following keystroke combinations completes a formula?

Ctrl+Enter

Which of the following keyboard shortcuts opens a new blank workbook?

Ctrl+N

Which of the following keyboard shortcuts cuts cells or a range?

Ctrl+X

Which of the following is a type of conditional formatting that displays cells with a fill color, a horizontal bar, or an icon?

Data visualization

Which of the following Formula Auditing tools steps through each part of a formula and displays an outcome for each part so that an error can be isolated?

Evaluate Formula

Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?

Excel 97-2003 Workbook

In Excel, which of the following keys opens the Save As dialog box?

F12

Which of the following cell addresses will change when it is copied?

F2

Once you have selected a cell address, which of the following keys inserts dollar signs quickly?

F4

Ascending order sorts data alphabetically from Z to A.

False

The default paste option is Keep Source Formatting.

False

Which of the following options simplifies the process of entering the months of the year in a worksheet?

Fill Handle

Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?

Formulas

Which of the following statements is not true when hiding rows?

Hiding a row deletes the data from the row.

Which of the following functions evaluates a specified condition and returns one value if the condition is True and another value if the condition is False?

IF

Which of the following functions finds the largest value in a range?

MAX

Which of the following is true about the TODAY and NOW functions?

No arguments are required.

Which of the following functions calculates a constant loan payment amount for a period of time at a stated interest rate?

PMT

Which of the following is the default paste option?

Paste

Which of the following is not true for PivotTables?

PivotTables are not interactive

Which of the following activates edit mode?

Press F2

Which of the following functions adjusts a value to a specified number of decimal places or a whole number?

ROUND

Which of the following is a color-coded editing tool that applies different colors to each cell or cell range within a formula?

Range Finder

Which of the following functions combines the SUM function with the logical criteria component of the IF function?

SUMIF

Which of the following functions multiplies the cells identified in its array arguments and then total those individual products?

SUMPRODUCT

Which of the following statements about arrays is false?

The maximum number of arrays in a formula is two.

Which of the following is not true when inserting and deleting columns?

To insert multiple columns or rows, each column or row is inserted individually

Which of the following is not an example of a data visualization command?

Top/Bottom

Which of the following Formula Auditing tools displays lines with arrows to all cells that use the active cell directly or indirectly in a formula?

Trace Dependents

Which of the following Formula Auditing tools displays lines with arrows to identify all cells referenced in the formula in the active cell?

Trace Precedents

In Excel, an indent moves cell contents away from the left edge of the cell.

True

To cancel a formula before it is complete, press Esc.

True

How do you enter a number as a label in a cell?

Type an apostrophe before the number

Which of the following functions uses a lookup table that is organized in columns?

VLOOKUP

What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading?

all worksheet cells

Which of the following features resizes column width or row height to fit the width or height of the longest or tallest entry?

autofit

When you open a blank workbook, which of the following names is automatically assigned to the workbook?

book1

By default, how does Excel align labels in a cell?

bottom left of a cell

By default, how does Excel align values in a cell?

bottom right of a cell

Which of the following displays the result of a formula?

cell

Which of the following occurs when a formula includes the cell address of a formula?

circular reference

If the formula in cell D10 is =D8+D9+D10. Which of the following terms describes the error?

circular reference error

What must you build to use an Advanced Filter?

criteria range

Importing refers to obtaining data from another Excel worksheet file.

false

Which of the following options copies formatting attributes and styles from one cell to another cell or range?

format painter

Which of the following Spelling dialog box options skips all occurrences of the same spelling of a label?

ignore all

Which of the following Page Setup dialog box tabs includes an option to set margins for headers and footers?

margins

Which of the following contains one relative reference (either the row number or column letter) and one absolute reference (the remaining row number or column letter)?

mixed reference

Which of the following displays when you place the pointer on the border of a selected cell or range?

move pointer

Which of the following best describes the size of an Excel worksheet?

over 16,000 columns and 1 million rows

Which of the following Page Setup dialog box tabs are used to change the orientation of a worksheet?

page

Which of the following is the name used to describe a rectangular group of cells?

range

Which of the following commands enlarges or shrinks printed data to fit a specific number of pages or a particular paper size?

scale to fit

Which of the following appears when you move the pointer over a cell?

selection pointer

Which of the following Page Setup dialog box tabs are used to identify a Print area other than the entire worksheet?

sheet

What key do you press to select adjacent worksheets?

shift

Which of the following keyboard shortcuts inserts a worksheet to the left of the active sheet?

shift+F11

In the Excel window, which of the following continuously displays the buttons for switching worksheet views?

status bar

Which of the following mathematical operations is performed last?

subtraction

Which of the following is not an element in an Excel function?

syntax

What is selected when you point to and click a column heading?

the entire column

A cell style is a set of formatting elements that includes font style, size, color, alignment, borders, and fill, as well as number formats.

true

A print area is the data that prints from a print command.

true

Before using the Merge & Center command, what cell should contain the data?

upper left selection of the cell

Which of the following commands displays a label on multiple lines within a cell?

wrap text