NEW
Font size
S
M
L
XL
WorksheetsRecap Excel
Total questions: 20
Worksheet time: 7mins
Name
Class
Date
1.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
2.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
3.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
4.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
5.
When entering numbers in Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
6.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
7.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
8.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
9.
Cell C1 contains the formula =A1+B1. If you copy the formula in C1 to cell C2, which of the following formulas will appear in cell C2?
a)
=A1+B1
b)
=C1+C2
c)
=A2+B2
d)
=B2+B3
10.
Which view do you need to work in to add a header?
a)
Normal View
b)
Page Layout view
c)
Header/Footer view
d)
Page Setup View
11.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
12.
For which of the following tasks would you use the fill handle?
a)
to apply shading
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
13.
An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available?
a)
dialog box
b)
additional workbook
c)
list of worksheets
d)
additional part of the current range
14.
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
a)
Page preview
b)
Print Layout
c)
Synchronous Scrolling
d)
Window View
15.
After a file has been opened, the filename appears in which of the following?
a)
Title bar
b)
footer
c)
header
d)
description pane
16.
Which of the folowing starts off with open, undo, and can be customized to contain the commands you use most frequently?
a)
a worksheet
b)
the help window
c)
the quick access toolbar
d)
the ribbon
17.
To get to the last cell on the worksheet, which of the following should you press?
a)
ctrl+home
b)
ctrl+end
c)
ctrl+right
d)
ctrl+left
18.
Pressing the F1 key displays Backstage view.
a)
true
b)
false
19.
Pressing the Alt key activates Keytips that allow you to use the keyboard to choose tabs instead of click them with the mouse.
a)
true
b)
false
20.
Page Layout view is useful when preparing your data for printing.
a)
true
b)
false
Reset
