NEW
Font size
WorksheetsExcel Module 2
Total questions: 20
Worksheet time: 10mins
A _________ is a prewritten formula that is built into Excel.
feature
calcuation
function
task
The ____________ function displays the highest value in a range.
MAX
SUM
AVERAGE
MIN
A(n) _______ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.
contiguous
indexed
indirect
direct
The __________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
Comma style format
Currency style format
Percent style format
The default view in Excel is called ________ view.
Basic
Standard
Values
Normal
The ________ function determines the lowest number in a range.
BASE
MIN
LOW
LEAST
_____________ view allows you to create or modify a worksheet while viewing how it will look in a printed format.
Normal
Page Layout
Full Screen
Page Break Preview
All of the following are valid Excel arithmetic operation EXCEPT _________.
∧
%
*
>
You can click the ____________ button to undo an automatic correction.
Trace Error
AutoCorrect Options
Auto Fill Options
Paste Options
8. When you decrease the row height to ____, the row is hidden.
1
0
3
2
You have to put $ signs in all the worksheet.
True
False
What cell style do you use in the Total line?
Heading 1
Heading 2
Title
Total
What cell style do you use in the Title?
Heading 1
Total
Title
Heading 2
What do you press to enlarge the cell?
Alt Enter
Ctrl `
Ctrl Enter
Alt space
What do you press to see the formula page?
Alt Enter
Alt Space
Enter
Ctrl `
What key do you press to select two selections in the worksheet?
Alt
Enter
Ctrl
Space
What do you press to center the Title in the worksheet?
Center
Left Align
Merge Center
Right Align
What do you select so the worksheet can print in one page?
Fit Sheet To One Page
Print Layout
Ctrl `
Excel and Access are the same thing.
True
False
In what Tab are to insert charts?
Home
Formulas
Insert
Page Layout
