NEW
Font size
S
M
L
XL
WorksheetsExcel Section 2
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
An example of a range address.
a)
A1:B3
b)
A1;B3
c)
A1-B3
d)
A1=B3
2.
Which of these would add up the numbers from A3 to A6
a)
+(A3:A6)
b)
=(A3:A6)
c)
=(Ave(a3:a6))
d)
=Sum(A3:A6)
3.
What is this button?
a)
Move Tool
b)
Autosum
c)
Fill Handle
d)
Autofit
4.
What is this symbol do?
a)
Autosum
b)
Autofit
c)
Fill Handle
d)
Move Tool
5.
You can magnify or shrink the appearance of a worksheet or chart by using the _______ button.
a)
zoom
b)
shrink
c)
enlarge
d)
status
6.
The move and copy command accomplish the same task.
a)
True
b)
False
7.
Using the mouse to move or copy cells is called
a)
drag and drop
b)
move
c)
copy and paste
d)
cut and paste
8.
The fill handle can be used to do which of the following?
a)
copy a cell
b)
copy a range of cells
c)
create a series of numbers or dates
d)
all of the above
9.
When entering numbers in a worksheet, you must put $ if the number is to be used as currency.
a)
True
b)
False
10.
True or False. If you choose a larger font size, the height of the row is automatically made taller.
a)
True
b)
False
11.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
12.
To center text between the top and bottom of a cell, click the _____ button in the Alignment group on the HOME tab.
a)
Center
b)
Middle Align
c)
Align
d)
Bottom Align
13.
Which of the following statements correctly describes the relationship between row height and font size?
a)
Row height is automatically increased to accommodate an increase in font size.
b)
Font size will be automatically increased to fill the row height.
c)
Row height is automatically decreased to accommodate a decrease in font size.
d)
If the font size is too big for the row height, the font will be automatically shrunk
14.
What does the Format Painter feature do?
a)
applies a built-in style to a cell
b)
resets the format of a cell to the default values
c)
displays a palette of color and font choices with which you can format a cell
d)
copies formats from a selected cell to another cell
15.
What happens when you click the Increase Indent button?
a)
The contents of the active cell are indented 0.5 inch.
b)
The contents of the active cell are indented approximately one character width.
c)
The contents of the active cell are shifted one cell to the right.
d)
The font size of the active cell is decreased by one point.
16.
When you point at the border of a selected range of cells, the mouse pointer changes to a white arrow with the move icon attached. The move icon is represented by a
a)
four-headed arrow.
b)
pointing hand.
c)
two-headed arrow pointing left and right.
d)
two-headed arrow pointing up and down.
17.
This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.
a)
Spelling
b)
Translate
c)
Research
d)
Thesaurus
18.
To alert Excel that you are entering a formula and not text, type a(n) _______.
a)
equal sign
b)
number sign
c)
asterisk
d)
apostrophe
19.
Using the mouse to move or copy cells is called
a)
drag and drop
b)
move
c)
copy and paste
d)
cut and paste
20.
You can magnify or shrink the appearance of a worksheet or chart by using the _______ button.
a)
zoom
b)
shrink
c)
enlarge
d)
status
Reset
