NEW
Font size
S
M
L
XL
WorksheetsExcel FINAL
Total questions: 22
Worksheet time: 6hrs 30mins
Name
Class
Date
1.
What is the default justification for cells formatted as labels?
a)
right aligned
b)
left aligned
c)
centered
2.
What is the default justification for cells formatted as values?
a)
right aligned
b)
left aligned
c)
centered
3.
What is a file which contains one or more spreadsheets?
a)
spreadsheet
b)
workbook
c)
cell
d)
cell range
4.
Which is an example of a cell address?
a)
126
b)
A9
c)
=SUM
d)
76/65
5.
What is an example of a cell range?
a)
65-75
b)
=SUM(A1)
c)
1295
d)
(C1:C9)
6.
Which is an example of a formula?
a)
=A1+A2
b)
=(75)
c)
=75/95
7.
Which is an example of a function?
a)
75/*93
b)
=SUM(A1:A4)
c)
+25+75
8.
What combines one or more cells?
a)
merge
b)
values
c)
cell address
9.
What is adjusted to fit the longest entry of a cell? In other words, if you type text in excel and it runs into the next cell what do you adjust to expand that cell?
a)
cell address
b)
column width
c)
cell range
d)
workbook
10.
A column is vertical (up and down)
a)
true
b)
false
11.
A row is horizontal (across)
a)
True
b)
False
12.
If Sam wanted to add the cells in A1 and A5, what would the formula look like?
a)
=A1+A5
b)
=A1+A3
c)
A1+A5
d)
A1-A5
13.
If Sam wanted to add A1 through A5, what would the function look like?
a)
=A1+A10
b)
=SUM(A1:A5)
c)
=A1:A5
d)
(A1:A5)
14.
What allows you to use rows and columns of data to manage, predict and present information?
a)
word
b)
powerpoint
c)
graph
d)
spreadsheet
15.
What is a number that is entered on a spreadsheet and used for calculations?
a)
cell
b)
label
c)
value
d)
active cell
16.
What are text, symbols, dates or numbers NOT used in calculations called?
a)
labels
b)
values
c)
cells
d)
ranges
17.
What is a block of cells on a spreadsheet?
a)
cells
b)
range
c)
function
d)
formula
18.
The intersection of a row and column in a spreadsheet in which data can be entered is...
a)
label
b)
value
c)
cell
d)
formula
19.
* (multiplication) / (division) + (addition) - (minus) signs are all ......
a)
values
b)
cells
c)
ranges
d)
mathematical operations
20.
=SUM(A1:A7) is an example of a ........
a)
function
b)
spreadsheet
c)
cell
d)
range
21.
What is the highlighted cell on a worksheet? The cell that you are working in.
a)
spreadsheet
b)
range
c)
value
d)
active cell
22.
=A1+A2 is an example of.....
a)
formula
b)
spreadsheet
c)
label
Reset
