wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MP3 9wks test Tech App

Total questions: 30

Worksheet time: 18mins

Name
Class
Date
1.

When Excel opens, it gives you a file with one ______________.

a)

Workbook

b)

Workspace

c)

Worksheet

d)

Ebook

2.
Cell Range
a)
combines multiple lines into on cell
b)
A combination of numbers and symbols used to express a calculation
c)
to copy a cell’s contents and formatting into other cells
d)
a block of cells that can be selected (B4:B16)
3.

Auto Fill Handle

a)

The name of the cell is determined by the name of the row and the column intersecting, such as A8

b)

The rectangular shaped area on a worksheet that is created by the intersection of columns and rows

c)

the black symbol (+) you make when hovering over the green AutoFill Box in the lower right corner of an active cell. Clicking & dragging it can copy cell contents or duplicate the cell contents

d)

adds the values in a function or set of cells (also, AutoSum)

4.
AutoSum
a)
adds the values in a function or set of cells
b)
provides the middle number of the range of numbers used
c)
A combination of numbers and symbols used to express a calculation.
d)
to copy a cell’s contents and formatting into other cells
5.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
6.

What is the name of this cell? (hover over the picture to enlarge)

a)

B10

b)

5B

c)

B5

d)

A5

7.
Which one of the following is a spreadsheet application? 
a)
Microsoft Word
b)
Microsoft Powerpoint
c)
Microsoft Excel
d)
Microsoft Outlook
8.
It is possible to type numbers and letters (words) into a cell.
a)
True
b)
False
9.

What keys do you need to search for information on a page?

a)

Ctrl and s

b)

Ctrl and f

c)

Ctrl and a

d)

Ctrl and e

10.

What are tables used for?

a)

To look pretty

b)

To make information harder to find

c)

To store data/information

d)

To check the time

11.
What is the correct example of a range?
a)
3B:7C
b)
B3:C7
c)
B3-C7
d)
B:3:C:7
12.
These are cells that run horizontally in a spreadsheet.
a)
Column
b)
Row
c)
Cell
d)
Table
13.
These are cells that run vertically in a spreadsheet
a)
Column
b)
Row
c)
Cell
d)
Table
14.
Each box on a spreadsheet is called a ...
a)
row
b)
column
c)
cell
d)
box
15.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
16.
9 x 9 =
a)
90
b)
80
c)
81
d)
91
17.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
18.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
19.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
20.

A __________ is a graphical representation of data.

a)

Algorithm

b)

Steps

c)

Charts

d)

None of the above

21.

A column Chart use _______________ bar to represent data.

a)

Horizontal

b)

Vertical

22.

A chart is also called as graph.

a)

true

b)

false

23.

Observe the image and choose the correct type of Chart

a)

Line Chart

b)

Pie Chart

c)

Area Chart

d)

Scatter Chart

24.

Find the odd one.

a)

Pie Chart

b)

Bar Chart

c)

Surface Chart

d)

fundamental Chart

25.

Once a Chart is inserted a new window will appear.

a)

True

b)

False

26.

Chart gets updated automatically when you change data in:

a)

Word

b)

Excel

c)

None of them

27.

To move the Chart inside the document use ________________ option.

a)

Wrap Text

b)

WordArt Style

28.

Observe the given image and choose the correct answer.

a)

Scatter Chart

b)

Pie Chart

c)

Radar Chart

29.

In __________ tab Chart button is available.

a)

File

b)

Illustratoins

c)

Design

d)

Insert

30.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
reference
d)
cell