WorksheetsExcel Module 1 Review
Total questions: 30
Worksheet time: 15mins
Name
Class
Date
1.
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop
a)
True
b)
False
2.
You can use the DELETE key to clear cell contents.
a)
True
b)
False
3.
To print worksheet contents across the length of a page, you can use portrait orientation.
a)
True
b)
False
4.
You can edit cell contents in the formula bar or in the cell itself.
a)
True
b)
False
5.
When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.
a)
True
b)
False
6.
To find the largest value in a cell range, use the MIN function.
a)
True
b)
False
7.
The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.
a)
True
b)
False
8.
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
a)
mode indicator
b)
Page Break Preview
c)
scroll bar
d)
Fill handle
9.
In the formula =SUM(A6:A9), which of the following best describes A6:A9?
a)
argument
b)
function
c)
label
d)
active cell
10.
Which of the following lets you edit the contents of a cell?
a)
Click the cell, click the status bar, and press Enter.
b)
Click the cell and click in the status bar.
c)
Double-click the cell, click in the status bar, or just start typing.
d)
Double-click the cell or click in the formula bar.
11.
Which of the following views shows how a worksheet will appear when printed?
a)
Page Layout view
b)
Page Break Preview
c)
Normal view
d)
Reading view
12.
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
a)
The formula =B6+B7+B8+B9+B10.
b)
The formula =TOTAL(B6-B10)
c)
The formula =SUM(B6:B10)
d)
The formula =SUM(B6-B10)
13.
To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?
a)
Home
b)
Page Layout
c)
Insert
d)
View
14.
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
a)
The Undo button on the Quick Access toolbar
b)
The Cancel button on the Formula bar
c)
The Enter button on the Formula bar
d)
The Save button on the Quick Access toolbar
15.
To select a single worksheet cell so you can work with it, which of the following would you do?
a)
Click the cell.
b)
Move the cell pointer over the cell.
c)
Click the status bar.
d)
Click the Name box.
16.
Which of the following functions inserts the total of a range?
a)
ROUND
b)
AUTOSUM
c)
AVERAGE
d)
SUM
17.
Which of the following lets you search for a function or select one from a category?
a)
Function Arguments dialog box
b)
clipboard
c)
formula bar
d)
Insert Function dialog box
18.
Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?
a)
Hide the column headings.
b)
Insert a function.
c)
Copy columns to the next page.
d)
Change the page orientation to landscape.
19.
Changing a worksheet window to Normal view changes the contents of the worksheet.
a)
True
b)
False
20.
What feature inserts a function that totals the cells above or to the left of the selected cell?
a)
AutoSum button
b)
Fill button
c)
Paste options button
d)
Flash Fill
21.
In the formula =A8*$A$1, which of the following describes A8?
a)
Relative cell reference
b)
Absolute cell reference
c)
Function
d)
AutoSum
22.
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
a)
Normal view
b)
Page Layout view
c)
Page Break Preview
d)
Print Preview
23.
In a complex formula, how does Excel determine which calculation to perform first?
a)
It calculates the leftmost formulas first.
b)
It calculates operations outside parentheses first.
c)
It follows the order of operations.
d)
It calculates functions first.
24.
To preserve an exact cell address in a copied formula, you can use a absolute cell reference.
a)
True
b)
False
25.
To preserve an exact cell address in a copied formula, you can use a relative cell reference.
a)
A5
b)
$A$5
c)
$A5
d)
A$5
26.
You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?
a)
If it needs an absolute cell reference.
b)
If it needs a relative cell reference.
c)
If it needs landscape orientation.
d)
If it needs a function.
27.
In the formula =B6*$B$2, which of the following describes $B$2?
a)
Relative cell reference
b)
Absolute cell reference
c)
Function
d)
Average
28.
You can repeatedly paste an item from the Office Clipboard as many times as you like.
a)
True
b)
False
29.
Where do you rename a workbook and adjust its save location?
a)
Save As dialog box
b)
Home tab
c)
Name box
d)
Active cell
30.
Which worksheet view shows headers, footers, and rulers?
a)
Normal view
b)
Page Break Preview
c)
Page Layout view
d)
Formula view
100 %
