Draft



Draft | |

|Report: |Test Answer Key |

|Test: |9_12 Business and IT 6411 - Comp Apps 1 PostAssess 1 |

|Description: |Spreadsheets |

|Form: |501 |

Please use the following graphic for questions 1 through 8:

[pic]

|1. |In Figure 24, the amount in Cell F9 is the result of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|2. |In Figure 24, the amount in Cell C10 is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Date |

| |B.  |IF |

| |C.  |List |

| |D.  |LookUp f which function? |

|3. |In Figure 24, the amount in Cell F6 is the result of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|4. |In Figure 24, the automatic completion of the numbers in Cells A5:A8 is the result of: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |embedding. |

| |B.  |fill series. |

| |C.  |freeze panes. |

| |D.  |linking. |

|5. |In Figure 24, the alignment of the main heading in Row 1 is the result of which formatting? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Autosum |

| |B.  |Fill series |

| |C.  |Merge cells |

| |D.  |Wrap text |

|6. |In Figure 24, the size of Column B is the result of what formatting? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Fill series |

| |B.  |Height |

| |C.  |Width |

| |D.  |Wrap text |

|7. |In Figure 24, what formatting resulted in the placement of data in Cells C4 and D4? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Borders |

| |B.  |Height |

| |C.  |Width |

| |D.  |Wrap text |

|8. |In Figure 24, the formatting applied to the data in Cell F9 is an example of: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |currency. |

| |B.  |date. |

| |C.  |decimal. |

| |D.  |percent. |

[pic]

Please use the following graphic for questions 9 through 14:

[pic]

|9. |In the EZ Credit spreadsheet, the data in Column F is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Days360 |

| |B.  |LookUp |

| |C.  |Now |

| |D.  |VLookUp |

|10. |In the EZ Credit spreadsheet, the customer numbers listed in Column A are the result of which operation? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze panes |

| |D.  |Link |

|11. |In the EZ Credit spreadsheet, the data in Column G is the result of which formula? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Days360 |

| |B.  |LookUp |

| |C.  |Now |

| |D.  |VLookUp |

|12. |In the EZ Credit spreadsheet, the data in Cell B15 is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|13. |In the EZ Credit spreadsheet, the data in Cell B17 is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|14. |In the EZ Credit spreadsheet, which function will result in the total number of entries in the cell range B5:B14? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

[pic]

Please use the following graphic for questions 15 through 19:

[pic]

|15. |In Figure 26, the placement of the individual income items in Cells A3:A6 and expense items in Cells A8:A15 is the result of|

| |which formatting? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Indent |

| |C.  |Merge |

| |D.  |Wrap |

|16. |In Figure 26, the Net Income/Loss value in Cell C16 is the result of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|17. |In Figure 26, which operation was used to calculate the value in Cell C6? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|18. |In Figure 26, which operation was used to calculate the value in Cell C15? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|19. |In Figure 26, what formatting was applied to result in the appearance of Cell C6? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Indent |

| |C.  |Merge |

| |D.  |Wrap |

[pic]

Please use the following graphic for questions 20 through 24:

[pic]

|20. |In the Corner Bistro spreadsheet, the data has been sorted by which column? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |A |

| |B.  |B |

| |C.  |C |

| |D.  |G |

|21. |In the Corner Bistro spreadsheet, which function will result in the total number of employees when applied to Cells B5:B22? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |IF |

| |C.  |LookUp |

| |D.  |Max |

|22. |In the Corner Bistro spreadsheet, if the dairy manager wishes to view the data for her/his department only, she/he should |

| |use: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |count. |

| |B.  |if. |

| |C.  |list. |

| |D.  |sum. |

|23. |In the Corner Bistro spreadsheet, the format applied to Rows 1-7 is an example of which operation? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Fill series |

| |B.  |Freeze panes |

| |C.  |Link |

| |D.  |Sort |

|24. |In the Corner Bistro spreadsheet, if the Bonus is calculated using the data in Figure A, what function is used? |

| |[pic](NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |IF |

| |C.  |List |

| |D.  |LookUp |

[pic]

|25. |Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to |

| |calculate a final grade for each student? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Average |

| |B.  |Count |

| |C.  |If |

| |D.  |Sum |

|26. |Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part |

| |of the sort operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Ascending |

| |B.  |Descending |

| |C.  |Primary |

| |D.  |Secondary |

|27. |Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This |

| |is an example of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze |

| |D.  |Link |

|28. |What operation will Eve use to keep rows and columns visible so that they don't scroll off the screen as she moves around |

| |the worksheet? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze |

| |D.  |Link |

|29. |What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |CountA |

| |C.  |Fill Series |

| |D.  |If |

|30. |In the formula =F10*$J$4, F10 is an example of a/an: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |absolute reference. |

| |B.  |mixed reference. |

| |C.  |range. |

| |D.  |relative reference. |

|31. |In the formula =F10*$J$4, $J$4 is an example of a/an: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |absolute reference. |

| |B.  |mixed reference. |

| |C.  |range. |

| |D.  |relative reference. |

|32. |In the formula =$A1 + B1, $A1 is an example of a/an: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |absolute reference. |

| |B.  |mixed reference. |

| |C.  |range. |

| |D.  |relative reference. |

|33. |What procedure should be followed to ensure that an object does NOT change in a word processing document when it is edited |

| |in the spreadsheet of its original creation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Import |

| |C.  |Link |

| |D.  |Target |

|34. |Which function can an accounting department use in Cell A2 that will result in the current date? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |CountA |

| |C.  |Days360 |

| |D.  |Now |

|35. |Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?|

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |CountA |

| |C.  |Days360 |

| |D.  |Now |

|36. |What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total |

| |merchandise cost? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Average |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|37. |Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items|

| |when they reach a certain quantity. Which function should he use? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |If |

| |B.  |LookUp |

| |C.  |Max |

| |D.  |Min |

|38. |What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when |

| |otherwise? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |If |

| |B.  |LookUp |

| |C.  |Max |

| |D.  |Min |

|39. |What function should Eva use to calculate her final grade if her exam counts 25%, her test grades count 25%, and her daily |

| |work counts 50%? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Average |

| |B.  |If |

| |C.  |Max |

| |D.  |Min |

|40. |Purchase discounts are awarded as follows: 3% for sales of $300, 5% for sales of $500, and 9% for sales of $900 or more. |

| |What function is used to determine which discount is allowed based on the purchase price? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |Days360 |

| |C.  |List |

| |D.  |Lookup |

|41. |A spreadsheet is created with drop down items that a user can select from. This is an example of which function? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |Fill series |

| |C.  |List |

| |D.  |Lookup |

|42. |What formula will divide the value in Cell E5 by the value in Cell E6? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=E5/E6 |

| |B.  |=E5:E6 |

| |C.  |=E6/E5 |

| |D.  |=E6:E5 |

|43. |The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the |

| |number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have |

| |occurred? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=IF(D740,D7-40) |

| |C.  |=MAX(D1:D7)*1.5 |

| |D.  |=OVERTIME(D7*E7) |

Please use the following graphic for questions 44 through 47:

[pic]

|44. |In the Middle School Band spreadsheet, what formula will calculate the total cost per year for the saxophone? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=B2*C2/10 |

| |B.  |=B2/10*C2 |

| |C.  |=C2/D2 |

| |D.  |=C2*D2 |

|45. |In the Middle School Band spreadsheet, what format has been applied to Cells C1 and D1? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Merge |

| |C.  |Shade |

| |D.  |Wrap |

|46. |In the Middle School Band spreadsheet, what formula is used to calculate the total cost of the clarinet? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=B3*C3 |

| |B.  |=C3*D3 |

| |C.  |=C3/D3 |

| |D.  |=E3/C3 |

|47. |In the Middle School Band spreadsheet, what formula is used to calculate the Total Rental Fee? (NCCTE.9_12.BE.6411.PP104.01)|

| |A.  |=SUM(C2:E6) |

| |B.  |=SUM(D2:D6) |

| |C.  |=SUM(E2:E6) |

| |D.  |=TOTAL(C2:C6)*(D2:D6) |

[pic]

Please use the following graphic for questions 48 through 56:

[pic]

|48. |In Figure 23, the #### in Cell E14 is the result of which formatting error? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Height |

| |B.  |Justification |

| |C.  |Width |

| |D.  |Wrap text |

|49. |In Figure 23, the alignment of "Transaction" in Cell A8 and "Credits" in Cell E8 are the result of which formatting error? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Height |

| |B.  |Justification |

| |C.  |Width |

| |D.  |Wrap text |

|50. |In Figure 23, the alignment of "Running Balance" in Cell F8 is the result of which formatting? (NCCTE.9_12.BE.6411.PP104.01)|

| |A.  |Height |

| |B.  |Shading |

| |C.  |Width |

| |D.  |Wrap text |

|51. |In Figure 23, the automatic completion of the Transaction Numbers in Column A is the result of which operation? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze panes |

| |D.  |Link |

|52. |In Figure 23, the alignment of the main heading in Row 1 is the result of which formatting? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Autosum |

| |B.  |Merge cells |

| |C.  |Fill series |

| |D.  |Wrap text |

|53. |In Figure 23, the value of Cell F11 is the result of: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |addition. |

| |B.  |division. |

| |C.  |multiplication. |

| |D.  |subtraction. |

|54. |In Figure 23, the number format applied to the values in B10:B17 is: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |currency. |

| |B.  |date. |

| |C.  |decimal. |

| |D.  |percent. |

|55. |In Figure 23, what function was used to calculate Total Debits in Cell C4? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Average |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|56. |In Figure 23, the amount in Cell F10 is the result of: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |addition. |

| |B.  |division. |

| |C.  |multiplication. |

| |D.  |subtraction. |

[pic]

Please use the following graphic for questions 57 through 58:

[pic]

|57. |In the FBLA Candy Sales spreadsheet, the formatting applied to the data in Cell C8 is an example of: |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |currency. |

| |B.  |date. |

| |C.  |decimal. |

| |D.  |percent. |

|58. |In the FBLA Candy Sales spreadsheet, the value of Cell E4 is the result of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

[pic]

Please use the following graphic for questions 59 through 64:

[pic]

|59. |In Figure 25, the data in Column F is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Days360 |

| |B.  |HLookUp |

| |C.  |Now |

| |D.  |VLookUp |

|60. |In Figure 25, the Customer Numbers in Column A are the result of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze panes |

| |D.  |Link |

|61. |In Figure 25, the numerical data in Column G is the result of which formula? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Days360 |

| |B.  |LookUp |

| |C.  |Now |

| |D.  |VLookUp |

|62. |In Figure 25, the numerical data in Cell B15 is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|63. |In Figure 25, the data in Cell B17 is the result of which function? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

|64. |In Figure 25, which function will result in the total number of entries in the cell range B5:B14? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |Max |

| |C.  |Min |

| |D.  |Sum |

[pic]

Please use the following graphic for questions 65 through 69:

[pic]

|65. |In the Monthly College Budget spreadsheet, the placement of the individual income items in Cells A3:A6 and expense items in |

| |Cells A8:A16 is the result of which formatting? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Indent |

| |C.  |Merge |

| |D.  |Wrap |

|66. |In the Monthly College Budget spreadsheet, the Net Income/Loss value in Cell B17 is the result of which operation? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|67. |In the Monthly College Budget spreadsheet, which operation was used to calculate the value in Cell B6? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|68. |In the Monthly College Budget spreadsheet, which operation was used to calculate the value in Cell B16? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Addition |

| |B.  |Division |

| |C.  |Multiplication |

| |D.  |Subtraction |

|69. |In the Monthly College Budget spreadsheet, what formatting was applied to result in the appearance of Cell B6? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Indent |

| |C.  |Merge |

| |D.  |Wrap |

[pic]

Please use the following graphic for questions 70 through 73:

[pic]

|70. |In Figure 28, the data has been sorted by column: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |A. |

| |B.  |B. |

| |C.  |C. |

| |D.  |H. |

|71. |In Figure 28, which function will result in the total number of employees when applied to Cells B3:B20? |

| |(NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |CountA |

| |B.  |IF |

| |C.  |LookUp |

| |D.  |Max |

|72. |In Figure 28, the format applied to Rows 1-5 is an example of: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |fill series. |

| |B.  |freeze panes. |

| |C.  |link. |

| |D.  |sort. |

|73. |In Figure 28, if the Bonus is calculated using data in Figure B what function is used? |

| |[pic](NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |If |

| |C.  |List |

| |D.  |LookUp Figure B |

[pic]

|74. |Which function should Edna use to calculate her total tips for every Saturday in October? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Average |

| |B.  |Count |

| |C.  |If |

| |D.  |Sum |

|75. |Earl sorted the student athletes in the following order: last name, first name, GPA, and homeroom. First name is classified |

| |as which type of sort? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Ascending |

| |B.  |Descending |

| |C.  |Primary |

| |D.  |Secondary |

|76. |Eli arranged his spreadsheet so that he could view the cell range B1:C10 and Row 2 while he worked in cells on Row 535. This|

| |is an example of which operation? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Fill series |

| |C.  |Freeze |

| |D.  |Link |

|77. |What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass"|

| |or "Fail"? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |CountA |

| |C.  |If |

| |D.  |Sum |

|78. |In the formula =A1 + B1, A1 is an example of a/an: (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |absolute reference. |

| |B.  |mixed reference. |

| |C.  |range. |

| |D.  |relative reference. |

|79. |What procedure should be followed to ensure that an object placed in a target document changes when its source document is |

| |edited? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Embed |

| |B.  |Freeze |

| |C.  |Link |

| |D.  |LookUp |

|80. |What function should Ester use to calculate the length of time that will elapse between now and when her car is paid in |

| |full? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Count |

| |B.  |Days360 |

| |C.  |If |

| |D.  |LookUp |

|81. |What formula should Diane use to subtract C3 from D7? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=C3-D7 |

| |B.  |=D7-C3 |

| |C.  |=D8-C3 |

| |D.  |=D8-D7-C3 |

|82. |Which formula will determine the amount of overtime hours worked if regular hours = 40 and the number of hours worked is in |

| |D7? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |=IF(D7=40,D7-40,0) |

| |D.  |=IF(D7>40,D7-40,0) |

Please use the following graphic for this question.

[pic]

|83. |In the FBLA Candy Sales spreadsheet, what format has been applied to Cells B2, D2, and E2? (NCCTE.9_12.BE.6411.PP104.01) |

| |A.  |Border |

| |B.  |Merge |

| |C.  |Shading |

| |D.  |Wrap |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download