wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Review Excel 2016 Block 3 Final Exam (2024)

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

An Excel ____ allows data to be summarized and charted easily.

a)

Worksheet

b)

workflow

c)

document

d)

presentation

2.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

a)

exploded

b)

outer

c)

offset

d)

rasterized

3.

Combining two or more selected cells into one cell is called ____ cells.

a)

merging

b)

mixing

c)

combining

d)

spanning

4.

The person or persons requesting the worksheet should supply their requirements in a ____ document.

a)

blank

b)

test issues

c)

requirements

d)

certified

5.

The range of cells receiving copied content is called the ____ area.

a)

fill

b)

range

c)

location

d)

paste

6.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

a)

save

b)

print

c)

format

d)

clear

7.

A thin red border indicates the active cell.

a)

True

b)

False

8.

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

a)

True

b)

False

9.

A ____ is a prewritten formula that is built into Excel.

a)

function

b)

feature

c)

task

d)

calculation

10.

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

a)

placement

b)

operations

c)

positioning

d)

selections

11.

Which of the following happens when you enter the formula =G15 into a cell?

a)

Excel recalculates all formulas in the worksheet

b)

Excel assigns the sum of the values in the previous 15 cells to the active cell

c)

Excel assigns the value in cell G15 to the active cell

d)

Nothing; =G15 is an invalid formula

12.

The ____ function displays the highest value in a range.

a)

MIN

b)

SUM

c)

MAX

d)

AVERAGE

13.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

a)

DIVSUM

b)

RANGEAVG

c)

AVERAGE

d)

MAX

14.

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the $ to the far left with spaces between it and the first digit in the cell.

a)

Comma style format

b)

Accounting number format

c)

Percent style format

d)

Currency style format

15.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

a)

Normal

b)

Page Layout

c)

Page Break Preview

d)

Full Screen

16.

The most common error when entering a formula is to reference the wrong cell in the formula.

a)

True

b)

False

17.

Cell references in a formula are called ____.

a)

assumptions

b)

comments

c)

numbers

d)

content

18.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.

a)

Ribbon

b)

Clipboard

c)

Folder

d)

File

19.

Using the mouse to move or copy cells is called ____.

a)

drop and drag

b)

drag and drop

c)

drag and copy

d)

drag and paste

20.

Which of the following formulas contains an absolute cell reference?

a)

=$B4

b)

=B$4

c)

=$B$4

d)

=B4

21.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

a)

IF

b)

NOW

c)

AND

d)

OR

22.

Charts can either be embedded in a worksheet or placed in a separate ____.

a)

worksheet

b)

dialog box

c)

chart sheet

d)

range

23.

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

a)

True

b)

False

24.

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

a)

#NULL!

b)

#DIV/0!

c)

#N/A

d)

#REF!

25.

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

a)

dialog box

b)

amortization schedule

c)

formula checker

d)

data table

26.

____ ensures that users do not change values inadvertently that are critical to the worksheet.

a)

Cell protection

b)

Range Finder

c)

The formula checker

d)

A data table

27.

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

a)

The Range Finder

b)

The formula checker

c)

A data table

d)

An amortization schedule

28.

Which of the following is the maximum number of active data tables per worksheet?

a)

5

b)

20

c)

50

d)

As many as you want

29.

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

a)

locked

b)

indexed

c)

unprotected

d)

hybrid

30.

The date stamp shows the date a workbook, report, or other document was created or the time period it represents.

a)

True

b)

False