wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Fall Semester Review Part 2

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

The default view in Excel is called ____ view.

a)

Normal

b)

Standard

c)

Basic

d)

Values

2.

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

3.

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

4.

Which of the following formulas contains an absolute cell reference?

a)

=$B4

b)

=B$4

c)

=$B$4

d)

=B4

5.

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

a)

Section

b)

Sparkline

c)

Special

d)

Sparkle

6.

You should use a ____ chart to compare values side by side, broken down by category.

a)

Column

b)

Bar

c)

Line

d)

Clustered Column

7.

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

a)

Worksheet

b)

Dialog Box

c)

Chart Sheet

d)

Range

8.

A character with a point size of 10 is about 10/72 of one inch in height.

a)

True

b)

False

9.

Live preview is available on a touch screen

a)

True

b)

False

10.

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

a)

True

b)

False

11.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

a)

True

b)

False

12.

You cannot format an entire column at once.

a)

True

b)

False

13.

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

a)

True

b)

False

14.

The underline format underlines the entire cell, not just the characters in the cell.

a)

True

b)

False

15.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

a)

True

b)

False

16.

Clicking the ____ box completes an entry.

a)

Cancel

b)

Formulas

c)

Enter

d)

Tab

17.

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

a)

Merging

b)

Mixing

c)

Combining

d)

Spanning

18.

The date you change a file is an example of a(n) ____ property.

a)

Automatically Updated

b)

Baseline

c)

Standard

d)

Indexed

19.

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

a)

ALT

b)

ESC

c)

CTRL

d)

TAB

20.

The ____ button allows you to erase recent cell entries.

a)

Undo

b)

Cell Style

c)

Bold

d)

Increase Decimal

21.

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

a)

^

b)

*

c)

%

d)

>

22.

Which of the following calculations multiplies 23 by 0.01?

a)

=23%

b)

23

c)

23+.01

d)

=24-.01

23.

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

24.

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

a)

40

b)

26

c)

48

d)

13

25.

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