WorksheetsSS Formatting Quiz
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
_______ is used to align multi-line text within a cell.
a)
Wrap Text
b)
Merge and Center
c)
Bold
d)
Center
2.
_______ is used to combine two or more cells
a)
Merge and Center
b)
Wrap Text
c)
Alignment
d)
Format
3.
Columns and rows can be inserted, copied, pasted, or deleted.
a)
True
b)
False
4.
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.
5.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
6.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
7.
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
8.
Sum, average, count, maximum value, and minimum value are examples of what?
a)
a. Formulas
b)
b. Calculations
c)
c. Functions
d)
d. Spreadsheet data
9.
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
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.
Which of the following would NOT be a way to bring attention and emphasis to your labels/titles on a spreadsheet?
a)
Rotate Text (Vertically, Diagonally)
b)
Bold, Underline the Font
c)
Format Color of the Cell
d)
Adjust Column Width
12.
What is the correct example of a range?
a)
3B:7C
b)
B3:C7
c)
B3-C7
d)
B:3:C:7
13.
Software that is designed to create functions, formulas and make graphs and financial documents
a)
Spreadsheet
b)
Database
c)
Presentation
d)
Word Processing
14.
Information that repeats itself at the bottom of a page
a)
Footer
b)
Endnote
c)
Footnote
d)
Citation
15.
Information that repeats itself at the top of a document
a)
Headline
b)
Header
c)
Title
d)
Table of Contents
100 %
