wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

P3 Microsoft Excel Quiz 2

Total questions: 22

Worksheet time: 22mins

Name
Class
Date
1.

Look at the arrow. What is this PART called?

a)

Name box

b)

Formula Bar

c)

Cell reference

2.

Look at the arrow. What is this PART called?

a)

Active cell

b)

Name box

c)

Formula bar

3.

Look at the red rectangle. What is this PART called?

a)

Formula bar

b)

Cell name

c)

Name box

4.

Look at the picture. What tool is in number 2 called?

a)

Table

b)

Picture

c)

Shapes

5.

Look at the picture. What tool is in number 4 called?

a)

Fill color

b)

Font color

c)

Border

6.

Look at the picture. What tool is in number 5 called?

a)

Align Text Left

b)

Center

c)

Align Text Right

7.

What combines one or more cells?

a)

merge

b)

wrap text

c)

cell address

8.

A column is represented by numbers.

a)

True

b)

False

9.

What is the name of the Active cell?

a)

D-1

b)

D1

c)

1D

10.

What are tables used for?

a)

To store data/information

b)

To look pretty

c)

To check the time

11.

Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses.

a)

True

b)

False

12.

How do you make a cell the active cell?

a)

Cells are always active

b)

Click INSERT CELL

c)

Click on the cell

13.

Which tab in Excel has charts and tables?

a)

insert

b)

home

c)

file

14.

When making a chart, you always highlight the entire spreadsheet.

a)

True

b)

False

15.

When making a chart, what is the first thing you need to do?

a)

Highlight your data being used.

b)

Double click the active cell

c)

Pick the type of Graph

16.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Top right of spreadsheet document

c)

Bottom left of spreadsheet document

17.

A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.

a)

Column Chart

b)

Bar Chart

c)

Pie Chart

18.

A Graphic representation of data. The bar can be Vertical or Horizontal, but a vertical graph is also known as a column chart.

a)

Bar Chart

b)

Pie Chart

c)

Line Chart

19.

What type of chart is this?

a)

Column chart

b)

Bar chart

c)

Line chart

20.

Every chart should have a

a)

chart slogan

b)

chart title

c)

chart word

21.

Which chart would you use if you had several items in a specific range of values?

Example: the number of matches the Regents basketball team has won from each of the last 3 years.

a)

Column Chart

b)

Bar Chart

c)

Pie Chart

22.

What is this tool called?

a)

merge & center

b)

wrap text

c)

center