wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Module 2

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

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

a)

feature

b)

calcuation

c)

function

d)

task

2.

The ____________ function displays the highest value in a range.

a)

MAX

b)

SUM

c)

AVERAGE

d)

MIN

3.

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)

indirect

d)

direct

4.

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)

Accounting number format

b)

Comma style format

c)

Currency style format

d)

Percent style format

5.

The default view in Excel is called ________ view.

a)

Basic

b)

Standard

c)

Values

d)

Normal

6.

The ________ function determines the lowest number in a range.

a)

BASE

b)

MIN

c)

LOW

d)

LEAST

7.

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

a)

Normal

b)

Page Layout

c)

Full Screen

d)

Page Break Preview

8.

All of the following are valid Excel arithmetic operation EXCEPT _________.

a)

\wedge

b)

%

c)

*

d)

>>

9.

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

a)

Trace Error

b)

AutoCorrect Options

c)

Auto Fill Options

d)

Paste Options

10.

8. When you decrease the row height to ____, the row is hidden.

a)

1

b)

0

c)

3

d)

2

11.

You have to put $ signs in all the worksheet.

a)

True

b)

False

12.

What cell style do you use in the Total line?

a)

Heading 1

b)

Heading 2

c)

Title

d)

Total

13.

What cell style do you use in the Title?

a)

Heading 1

b)

Total

c)

Title

d)

Heading 2

14.

What do you press to enlarge the cell?

a)

Alt Enter

b)

Ctrl `

c)

Ctrl Enter

d)

Alt space

15.

What do you press to see the formula page?

a)

Alt Enter

b)

Alt Space

c)

Enter

d)

Ctrl `

16.

What key do you press to select two selections in the worksheet?

a)

Alt

b)

Enter

c)

Ctrl

d)

Space

17.

What do you press to center the Title in the worksheet?

a)

Center

b)

Left Align

c)

Merge Center

d)

Right Align

18.

What do you select so the worksheet can print in one page?

a)

Fit Sheet To One Page

b)

Print

c)

Print Layout

d)

Ctrl `

19.

Excel and Access are the same thing.

a)

True

b)

False

20.

In what Tab are to insert charts?

a)

Home

b)

Formulas

c)

Insert

d)

Page Layout