Download
1 / 27
270 likes | 361 Views
Lesson 4 Study Guide Review Microsoft Office 2003. Cell references that adjust when a formula is copied to a new location use ____. a. absolute referencing b. PMT c. relative referencing d. a function.
E N D
Cell references that adjust when a formula is copiedto a new location use ____. a. absolute referencing b. PMT c. relative referencing d. a function
2. The cell A1 contains the function =$C$3+$D$4. You move that function to A2. How will the function in A2 read? • =$D$3+$E$4 • =$C$4+$D$4 • =$C$3+$D$3 • =$C$3+$D$4
3. Which series of steps would you take to filter a worksheet? • Data>Filter>Rows • Data>Filter>AutoFilter • Format>Data>AutoFilter • Data>Rows>AutoFilter
4. Which of the following finds the sum of cells C3 through C22? • =SUM(C3:C22) • SUM(C3:C22) • =SUMC3:C22 • SUM=(C3:C22)
5. Use a(n) ____ when more than one formula refers to the same cell. • relative reference • filter • absolute reference • cell reference
6. The NOW function ____. • immediately recalculates the Worksheet • displays the date and time • calculates a payment • adds up data in the selected range
7. The ____ function can be used to calculate monthly payments for a loan. • SUM • NOW • Rate • PMT
8. When the result from the PMT function is red it represents ____. • the loan is paid off • a negative amount • the total amount • the Present Value
9. What function can determine the number of cells in a specific column that contain numbers? • SUM • PV • IF • Count
10. The ____ dialog box allows you to modify a chart. • Chart Options • Chart Selection • Edit Chart • Chart Argument
11. To which of the following can you apply a filter? • a row • a chart • a function • a cell range
12. Which menu contains the Sort function? • Edit • Data • Insert • Format
13. Which function allows you to make a choice by comparing two values? • NOW • PMT • IF • Count
14. On the Titles tab of the Chart Options dialog box you can create labels for ____. • the category axis • the value axis • the chart title • all of the above
15. When using the PMT function, which of the following stands for the total number of payments required to pay off the loan? • SUM • PMT • NPER • PV
16. In the following worksheet, what value would be placed in cell B10 if the Count function was applied? • 133 • 724 • 103 • 7
17. What happens when the box in the upper-left corner of this worksheet (where the pointer is currently positioned) is clicked? • The column heads are all selected. • The contents of the entire worksheet are deleted. • The contents of the entire worksheet are selected. • The first column of the worksheet is widened.
18. Which of the following functions cannot be accessed by clicking the AutoSum drop-down menu? • Sort • Count • IF • NOW
19. What value will appear in cell C2 when the [ENTER] key is pressed? • 100 • 15 • 85 • An error will be produced.
20. Which of the following best explains the purpose of this IF function? • If the value in B3 is over $20,000, the total charge will be decreased by 10%. • If the value in B3 is less than $20,000, the total charge will be increased by 10%. • If the discount is over 10%, the total charge will be increased by 1%. • If the discount is less than 10%, the total charge will be increased by 1%.
21. Which of the following is not a value that the PMT function uses to calculate its result? • The number of payments to be made. • The number of days in a year. • The interest rate. • The amount being borrowed.
22. When #### is displayed in a cell containing data you must ___ to see all of the data. widen the column
23. Use ___ when you only want to display items that contain specific values. AutoFilter
24. The ___ function performs a logical test that always evaluates as either true or false. IF
25. If you wanted to sort a column of names alphabetically, like they are in a telephone book, you could use the Sort ___button. ascending
This Concludes Lesson 4 Review
