wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Getting to know spreadsheet

Total questions: 25

Worksheet time: 20mins

Name
Class
Date
1.
The section of a spreadsheet where a single row and a single column intersect is referred to as a (an)
a)
interstate
b)
intersection
c)
cell
d)
point
2.
Spreadsheets consists of ________ and _______.
a)
tables and chairs
b)
rows and tables
c)
rows and columns
d)
columns and tables
3.
The vertical set of cells are known as _______
a)
rows
b)
columns
c)
straight lines
d)
verts
4.
The set of cells that are horizontal in direction on a spreadsheet are referred to as 
a)
rows
b)
columns
c)
cells
d)
spreadsheet
5.
When a cell is made larger it is said to be  ________
a)
enlarged
b)
expanded
c)
bigger
d)
contracted
6.
The columns on a spreadsheet run vertical and begin with what?  
a)
numbers
b)
letters
c)
colors
d)
pictures
7.
The rows on a spreadsheet run horizontal and begin with ________
a)
letters
b)
pictures
c)
numbers
d)
dates
8.

Which of the following is correct

cell reference?

a)

B1

b)

1B

c)

B-1

d)

1-B

9.

In a computer, cell's adderss that is included in range C5:E5 is -

a)

D6

b)

C8

c)

E4

d)

D9

10.
What is a Spreadsheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
11.
What is a worksheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
12.

What do all calculations start with?

a)

=

b)

(

c)

-

d)

\

13.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

14.

Which of the following is a valid formula?

a)

=C7*C8

b)

=(C7\C8)

c)

=(C7xC8)

d)

=AVERAGE(C7*C8)

15.

Which of the following is a valid function?

a)

=sum(A1:A6)

b)

sum=(A1:A6)

c)

=sum[A1:A6]

d)

=sum(A1,A6)

16.

You can present your data graphically, using a

a)

chart

b)

print

c)

font

d)

sort

17.

How do you add a new column?

a)

Click on the "Edit" menu and choose "Insert Column"

b)

Click on the "Insert" menu and choose "Column Left" or "Column Right".

c)

Right-click on the top label of the column and choose "Insert a new column"

d)

Click on the "Edit" menu and choose "Give me a new column please!"

18.
Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically
a)
True
b)
False
19.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
20.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
21.
What type of graph is this?
a)
Bar Graph
b)
Line Plot
c)
Pictograph
d)
Tally Chart
22.
How many students have blue for a favorite color?
a)
11
b)
12
c)
14
d)
17
23.

Which circle graph has the same data as the bar graph?

a)
b)
c)
d)
24.
How many mountain bikes were sold?
a)
22
b)
28
c)
16
d)
6
25.

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

a)

True

b)

False

Similar Resources on Wayground

Season 5 #Spaic Machine learning Weekly Quiz

20 questions

Season 5 #Spaic Machine learning Weekly Quiz

quiz

Worksheet

•

KG - Professional Dev...

Google

20 questions

Google

quiz

Worksheet

•

7th - 12th Grade

Unit Test 1 Class 8 Computer

20 questions

Unit Test 1 Class 8 Computer

quiz

Worksheet

•

8th - 9th Grade

Computer Science - X

20 questions

Computer Science - X

quiz

Worksheet

•

8th - 10th Grade

cole - Fundamentos de Electrónica y Electricidad

20 questions

cole - Fundamentos de Electrónica y Electricidad

quiz

Worksheet

•

9th Grade

Tecnología III

20 questions

Tecnología III

quiz

Worksheet

•

9th Grade

What is STEM & Aerodynamics of a Plane

20 questions

What is STEM & Aerodynamics of a Plane

quiz

Worksheet

•

7th - 9th Grade