Name:     ID: 
 
Email: 

Chapter 6 review questions

True/False
Indicate whether the statement is true or false.
 

 1. 

A new cell style can be added to the Cell Styles gallery.
 

 2. 

The first step to inserting a column between column C and column D is to select a cell in column C.
 

 3. 

A function requires arguments to perform its calculation.
 

 4. 

Pointing is the best method for entering a cell range into a function because typing errors are avoided.
 

 5. 

$A$6 is an absolute cell reference.
 

 6. 

In Excel, MIN is categorized as a math and trigonometry function.
 

 7. 

A #### error value indicates the formula is trying to divide by 0.
 

 8. 

The key sort column is the column that contains the values that a sort is based on.
 

 9. 

One way to fit more rows and columns on a page is to increase the margins.
 

 10. 

Clearing a print area sets the entire worksheet as the print area.
 

 11. 

A method for computing equal period payments for an installment loan is called amortization.
 

 12. 

The principal of a loan increases each time a payment is made.
 

 13. 

By default, pasted data is static.
 

 14. 

Pasted data will automatically update if the source data changes.
 

 15. 

When pasting a range of cells, only the upper-left cell of the destination range needs to be selected.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 16. 

What will the formula =SUM(A1:A10) change to if row 3 is deleted?
a.
it will not change
c.
=SUM(A1:A9)
b.
=SUM(B1:B10)
d.
=SUM(A1:A11)
 

 17. 

A function performs a calculation that results in
a.
a cell reference.
c.
a range of values.
b.
a label.
d.
a single value.
 
 
nar001-1.jpg
 

 18. 

Using the data in the worksheet above, what will be displayed by the formula =MAX(A2:B3)?
a.
-10
c.
30
b.
52
d.
42
 

 19. 

Using the data in the worksheet above, what will be displayed by the formula =MIN(A1:B3)?
a.
-10
c.
30
b.
52
d.
42
 

 20. 

Using the data in the worksheet above, what will be displayed by the formula =SUM(A1:A3)?
a.
-10
c.
30
b.
45
d.
141
 

 21. 

Using the data in the worksheet above, what will be displayed by the formula =MIN(B1:B3)?
a.
2
c.
–10
b.
52
d.
26
 

 22. 

Using the data in the worksheet above, what will be displayed by the formula =IF(B1<>B2,0,5)?
a.
0
c.
–5
b.
5
d.
52
 

 23. 

Using the data in the worksheet above, what will be displayed by the formula =IF(A1<MIN(B1:B3),1,A1)?
a.
1
c.
25
b.
B1
d.
2
 

 24. 

What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to cell C7?
a.
=B6*$B$1
c.
=B7*$B$1
b.
=B7*$B$2
d.
=C6*$B$1
 

 25. 

What will be displayed by the formula =ROUND(C2, 0) if the number 21.2534 is stored in C2?
a.
22
c.
21
b.
=ROUND(C2,0)
d.
21.25
 

 26. 

The first step when sorting data in a worksheet is to
a.
click Data mc026-1.jpg Sort A to Z mc026-2.jpg.
c.
select the range to sort.
b.
click Data mc026-3.jpg Sort Z to A mc026-4.jpg.
d.
select the entire workbook.
 

 27. 

How many arguments does the IF function have?
a.
1
c.
3
b.
2
d.
5
 

 28. 

Printing a worksheet in landscape orientation
a.
changes the order of the rows in the worksheet.
b.
fits more columns and fewer rows on a page.
c.
fits more rows and fewer columns on a page.
d.
prints the worksheet on both sides of the paper.
 

 29. 

What can be used to control how a worksheet is divided into pages?
a.
page breaks
c.
rows
b.
columns
d.
functions
 

 30. 

Page Layout mc030-1.jpg Print Area mc030-2.jpg Set Print Area is used to
a.
freeze selected rows and columns.
b.
print only cells containing formulas.
c.
print a selected part of a worksheet.
d.
print only cells containing values.
 



 
         Start Over