wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Basics Review

Total questions: 24

Worksheet time: 13mins

Name
Class
Date
1.

What kind of software is Excel?

a)

Spreadsheet Software

b)

Database Software

c)

Word processing Software

2.

In Excel, rows are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

3.

In Excel, columns are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

4.

Excel refers to files as

a)

Databases

b)

Workbook

c)

Document

5.

Where rows and columns meet are referred to as

a)

Cells

b)

Blocks

c)

Boxes

6.

When inserting a formula, always start with

a)

-

b)

*

c)

+

d)

=

7.

Adding two cells,

a)

A1+A3=SUM

b)

SUM(_)

c)

=SUM(A1+A3)

d)

Total

8.

Excel spreadsheets that are already created and ready for you to edit are known as?

a)

spreadsheets

b)

data inputs

c)

templates

d)

pages

9.

This area tells you the name of the project and the name of the program you have open.

a)

Status Bar

b)

Formula Bar

c)

Title Bar

d)

Quick Access Toolbar

10.

A cell that has a dark border around it.

a)

Jail Cell

b)

Sleepy Cell

c)

Active Cell

d)

Stem Cell

11.

Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.

a)

PO Box

b)

Cell Reference

c)

Status Bar

d)

Formula Bar

12.

The area is located at the bottom of the Excel window and provides information and options for your worksheet project.

a)

Scroll Bars

b)

Status Bar

c)

Salad Bar

d)

Formula Bar

13.

A selection of two or more cells is known as a ____.

a)

Cluster

b)

Range

c)

Conglomorate

d)

Big mess

14.

Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.

a)

Status Bar

b)

Scroll Bar

c)

Outside Window

d)

Formula Bar

15.

The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.

a)

Scroll Box

b)

Fill Handle

c)

Cell Reference

d)

Ribbon Tab

16.

Which of the following will give you a total?

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM

17.

Which of the following symbols is used for multiplication?

a)

Back slash

b)

Plus

c)

Asterisk

d)

Forward slash

18.

Which of the following will produce a number that is calculated by adding quantities together and then dividing the total by the number of quantities?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

19.

Which of the following is a function?

a)

John Jones

b)

$5.00

c)

=sum(A1:A5)

d)

=A1+A5

20.

What part of a spreadsheet is vertical?

a)

Formula Bar

b)

Row

c)

Column

d)

Cell

21.

Which part of a spreadsheet is horizontal?

a)

formulas bar

b)

column

c)

row

d)

cell

22.

Which of the following does a spreadsheet NOT do for a user?

a)

calculate a loan payment schedule

b)

balance a checkbook

c)

write a business letter

d)

create household budget

23.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

24.
Values are numbers that will be calculated – which side of the cell do they go to automatically?
a)
Right
b)
Left
c)
Center
d)
They automatically wrap.