wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Module 2 Quiz 1

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

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

a)

function

b)

feature

c)

task

d)

calculation

2.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

a)

contiguous

b)

indexed

c)

direct

d)

indirect

3.

All of the following are valid Excel arithmetic operators EXCEPT ____.

a)

^

b)

*

c)

%

d)

>

4.

Which of the following calculations multiplies 23 by 0.01?

a)

=23%

b)

=23

c)

=23+.01

d)

=24-.01

5.

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

6.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

a)

40

b)

26

c)

48

d)

13

7.

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

8.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

a)

related

b)

relative

c)

pasted

d)

alternative

9.

You can click the ____ button to undo an automatic correction.

a)

autofill options

b)

autocorrect options

c)

paste options

d)

trace error

10.

Which of the following Option buttons gives options for filling cells following a fill operation?

a)

Auto Fill Options

b)

AutoCorrect Options

c)

Insert Options

d)

Paste Options

11.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

a)

Find Error

b)

Explain Error

c)

Fix Error

d)

Trace Error

12.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

a)

AutoCorrect

b)

Insert

c)

AutoFill

d)

Paste

13.

The ____ function displays the highest value in a range.

a)

MIN

b)

SUM

c)

MAX

d)

AVERAGE

14.

The ____ function determines the lowest number in a range.

a)

LOW

b)

BASE

c)

LEAST

d)

MIN

15.

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

16.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

a)

Function

b)

Formula

c)

Equal

d)

Calculate

17.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

a)

left parenthesis

b)

right bracket

c)

right parenthesis

d)

left bracket

18.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

a)

Formula Finder

b)

Range Finder

c)

Calculation Finder

d)

Function Finder

19.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

a)

scheme

b)

gallery

c)

theme

d)

style

20.

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign 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

21.

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

a)

8.43

b)

7.52

c)

11.65

d)

9.43

22.

When you decrease the row height to ___, the row is hidden.

a)

0

b)

1

c)

2

d)

3

23.

A ____ is text and graphics that print at the top of each page.

a)

header

b)

topper

c)

margin

d)

crown

24.

A _____ is text and graphics that print at the bottom of every page.

a)

footer

b)

toe

c)

margin

d)

stopper

25.

The default view is Excel is called _____ view.

a)

Normal

b)

Standard

c)

Basic

d)

Values

26.

_____ 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

27.

To print a range of cells in the active worksheet, click _____ in the Settings area in the Print gallery.

a)

Print Active Sheets

b)

Print Selection

c)

Print Entire Workbook

d)

none of the above

28.

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

a)

Identification of how to format various elements of the worksheet

b)

Avoiding the temptation to use flashy or confusing visual elements within the worksheet

29.

Which of the following are valid formulas?

a)

=3 ^ 4

b)

=H3/H11

c)

=11+9

d)

=22-F15

e)

All of the above

30.

Which of the following is a method of entering functions?

a)

keyboard, touch gesture, or pointer

b)

the Sum menu

c)

the Insert Function box in the formula bar

d)

the Name box area in the formula bar

e)

All of the above

31.

Using the Excel spell checker, you can ____.

a)

check the spelling of words in a selected range

b)

add words to the dictionary

c)

Both of the above

32.

The equal sign (=) precedes a formula.

a)

True

b)

False

33.

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

a)

True

b)

False

34.

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

a)

True

b)

False

35.

The arithmetic operator, ^, directs Excel to perform the division operation.

a)

True

b)

False