Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
If a customer is charged 1% interest for an invoice that is 30 days, and the invoice amount is in Cell
F8, the formula for the new invoice total would be:
1)
A)
=F8*.01.
B)
=F8*1.01%.
C)
=F8*1%.
D)
=F8*101%.
2)
To center data in a cell:
2)
A)
choose Format, Alignment, then Center.
B)
choose Cells, Format, the Alignment tab, then Center.
C)
choose Format, Cells, the Alignment tab, then Center.
D)
choose Cells, the Alignment tab, then Center.
3)
Which command deletes datasheets?
3)
A)
Right click on the sheet, then choose Delete.
B)
Choose Format, then choose Delete Sheet.
C)
Choose Edit, then choose Delete Sheet.
D)
Choose Edit, then choose Delete.
4)
Which of the following values is an example of a currency format with two decimals?
4)
A)
$ 2207.27
B)
$2,207.27
C)
2,207.27
D)
2207.27
5)
To format data to appear as currency:
5)
A)
choose View, Format, then choose Currency.
B)
choose Format, Cells, then choose Currency.
C)
choose Format, Cells, Number, then choose Currency.
D)
choose Cells, Format, then choose Currency.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
6)
The ordering of the “IF” statements is critical when ________ or more are nested in a
formula.
6)
7)
________ are a common business application.
7)
8)
An “IF” statement tells Excel that a ________ will be placed in the cell based on certain
conditions.
8)
9)
The tab that is highlighted at the bottom of the screen tells you which ________ is being
displayed.
9)
10)
________ can be used to perform calculations and conditional logic that would otherwise
be difficult for managers to carry out.
10)
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
11)
The appearance of a spreadsheet should be in a form that aids decision making.
11)
12)
The “IF” statement is considered a conditional formula.
12)
13)
Calculations should be entered into the spreadsheet before data values.
13)
14)
The highlighted tab at the bottom of a datasheet displays the creation date of the datasheet.
14)
15)
Nested “IF” statements can be entered in no particular order.
15)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
16)
Explain why spreadsheets are considered to be a common business application.
17)
How do you center the text in a range of cells?
18)
How do managers reduce the risk of mathematical errors and why?
19)
What do you need to do to enter data without the values exceeding the size of the cells?
20)
Why is the ordering in nested “IF” statements critical?
3