WorksheetsSpreadsheets and databases
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.
A chart ________________ identifies which data series each color represents.
a)
a. legend
b)
b. vertical axis
c)
c. title
d)
d. horizontal axis
7.
Which of these are not an example of how MS Excel can be used?
a)
a. Budget
b)
b. Research Paper
c)
c. Track sales
d)
d. Track Inventory
8.
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
9.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d. Average
10.
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
11.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
12.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
100 %
