NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets for year 7
Total questions: 12
Worksheet time: 7mins
Name
Class
Date
1.
A spreadsheet program is used to store data in:
a)
a. a database.
b)
b. a text document.
c)
c. rows and columns.
d)
d. letters and numbers.
2.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
3.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
4.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
5.
A ___________________ is a visual representation of data
a)
a. spreadsheet
b)
b. border
c)
c. chart
d)
d. table
6.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
7.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d. Average
8.
If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:
a)
=sum(C2:C11)
b)
=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)
c)
=sum(D2:D11)
d)
$13,442.90
9.
If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:
a)
=sum(C2:C11)
b)
=average(C2,C11)
c)
=average(C2:C11)
d)
=average(B2:B11)
10.
Every formula needs to begin with...
a)
=
b)
()
c)
;
d)
FORMULA
11.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
12.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
Reset
