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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- how to draft business plan
- example of draft letter
- is there a draft now
- business marketing plan draft sample
- draft status 1 y
- military draft status codes
- draft classification 1y
- us military draft classifications
- vietnam draft classification 1h
- 1 h draft classification
- wwii draft classifications
- draft classification crossword