|
Microsoft Excel Chapter 1 Exam For Questions 1-10 (E), open the spreadsheet titled, Excel Exam Data A 1. Merge cells 1A through 1D. 2. Change the font of “Company
Inventory” to 16 point Century. 3. Use a formula to subtract cells B4
from B3, C4 from C3, and D4 from D3. 4. Right Justify all cells containing
numbers. 5. Center all cells in row 2. 6. Bold all words contained in the
spreadsheet. 7. Make each number in the spreadsheet
extend to two decimal places. 8. Change rows 2 through 5 in the
spreadsheet to 12 point Century font. 9. Adjust column widths so that every
word fits. 10. Add a black border from cell A1 to D5. Save
this spreadsheet as, “Your Name –
Questions 1-10” For Questions 11-21 (E), open the spreadsheet titled, Excel Exam Data B 11. Select the entire spreadsheet, and
change the font to “Garamond” 12 point. 12. Adjust the width of columns A, B, and C
to 12. 13. Format “Grades” in cell A1 to Times New
Roman 16 point, bold font. 14. Center the cells in row 2. Save as “Problem #11 Solution”. 15. Left-Justify the numbers in columns B
and C. 16. Format numbered cells in columns B and
C to have two decimal places. 17. Merge and center cells A1 through C1. 18. Place a border around the spreadsheet
from cells A1 to C8. 19. Shade the cell in row 1 yellow. 20. Place another border around cells A2 to
C2. 21. Shade from cell A2 to cell C8 Green. Save
this spreadsheet as “Your Name –
Questions 11-21” For Questions 22-32 (E), open the spreadsheet titled, Excel Exam Data C 22. Merge cells A1 through D1. 23. Adjust the page layout to be landscape
instead of portrait. 24. Cut cells A2 through C2. Paste the
selection into cells B2 through D2. 25. Format the cells containing numbers to
“currency” with zero decimal places. 26. Delete all cells in row #5. 27. Change the font of row A to Courier New
16 point, underlined. 28. Adjust the height of row #1 to 30. 29. Format cell A1-D1 to be centered,
vertically. 30. Format column width of the entire
spreadsheet to 12. 31. Type your name, along with today’s date
in cell A7. 32. Merge cells A6 through D6. Save
the spreadsheet as “Your Name – Questions
22-32” For Questions 33-42 (E), open the spreadsheet titled, Excel Exam Data D 33. Center all cells in row 1. 34. Change the font of the entire
spreadsheet to Courier New 10 point. 35. Format all cells in column B as “Social
Security Numbers”. 36. Format the cells in column D to have
two decimal places. 37. Insert a row above the entire
spreadsheet. 38. Adjust the column widths so that every
word and number fits. 39. Select cells A1 to D7. Shade these cells light yellow. 40. Change the color of cells C3 to C6 to
red. 41. Delete “Sean Smith” and replace his
name with Your Name. 42. Place today’s date, left-justified, in
cell A1. For Questions 43-47 (M), open the spreadsheet titled, Excel Exam Data E 43. Change the word
“Speeds” in cell A1 to “Velocities.” 44. Georges’ data and Jabo’s data have been
mixed up. Switch the names so that they apply to the correct
times. 45. Since it is empty anyway, delete the
entire 4th row. (Shift cells up) 46. Select the 3rd row and bold it. Save
the spreadsheet as “Your Name –
Questions 43-47” For Questions 48-52 (M), open the spreadsheet titled, Excel Exam Data F
49. Insert a row above the column titles
and give the sheet the title: “Grade Level and Grades” 50. Merge cells A1 to F1 and center the
title using the “Merge and Center” button. 51. In cell A8, type the word “Totals.” Save
the spreadsheet as “Your Name –
Questions 48-52” For Questions 53-57 (M), open the spreadsheet titled, Excel Exam Data G 53. Merge cells A1 to C1 and center the
title using the “Merge and Center” button. 54. Adjust the column width of A1 so the
words fit in the cell. 55. Insert a new worksheet and name the
worksheet “Drinks Rule.” 56. Go back to Sheet 1, and change the word
“Beer” in cell A2 to “Soda.” 57. In cell E9, using the AVERAGE function,
determine the average price of People’s favorite drinks. (Cells C2-C7) Save
the spreadsheet as “Your Name –
Questions 53-57” For Questions 58-62 (M), open the spreadsheet titled, Excel Exam Data H 58. Go to the “Page Setup” menu and change
the orientation to “Landscape.” 59. In the 5th row calculate the
average ratings each movie got. 60. Delete cells F2-F5. (Dirty Dancing and
all cells below it) 61. In cell F2 type: “Total Points.” 62. In cells F3 and F4, using the SUM
function to determine the total number of points given to the movies by Men and
Women. 63. Select all of the cells containing
information and align them to the center. Save
the spreadsheet as “Your Name –
Questions 58-63” For Questions 64-68 (M), open the spreadsheet titled, Excel Exam Data I 64. Change the title of the worksheet to
“Student Test Averages.” 65. Insert the formula for Anne-Marie’s final grade in cell F2. (simply average all of the exams) 66. The formula for the Average Score on
Exam 3 is incorrect. Fix it. 67. Insert a row above the first row and
type the title: “Computing Class Grades.” 68. Merge and center cells A1-F1, and
change the font size to 14. Save
the spreadsheet as “Your Name –
Questions 64-68”
For Questions 69-78 (D), open the spreadsheet titled, Excel Exam Data J 69-77. Compute the totals, averages, and sum of the
totals. 78. Change the font of the entire document
to Courier size 10. Save
the spreadsheet as “Your Name –
Questions 69-78” For Questions 79-88 (D), open the spreadsheet titled, Excel Exam Data K 79-84. Compute the average number of people in each
group for all the foods. 85. Add a new Row titled “Pork” between
Row’s “Steak” and “Chicken” and enter 120 in Group 1’s cell and 163 in Group
2’s cell. 86. Compute the average number of people
per group for Pork. 87. Change
the font of all of the words in the document to Times New Roman size 12. 88. Change
the font of all of the numbers in the document to Courier size 10. Save
the spreadsheet as “Your Name –
Questions 79-88” For Questions 89-92 (D), open the spreadsheet titled, Excel Exam Data L 89. Change the font used for Cows and
Horses to Arial size 16, and make it Bold. 90. Change the font of Farm 1, Farm 2, Farm
3, and Averages to Arial size 14 and make it in Italics. 91. Compute
the average number of Cows and Horses per farm. 92. Change
the font of the numbers to Arial size 10. Save
the spreadsheet as “Your Name –
Questions 89-92” For Questions 93-95 (D), open the spreadsheet titled, Excel Exam Data M 93.
Compute the class average for the
Midterm. 94. Compute
the class average for the Final Exam. 95. Change
the font of the entire document to Verdana size 12. Save
the spreadsheet as “Your Name –
Questions 93-95” For Questions 96-101 (D), open the spreadsheet titled, Excel Exam Data N There
seem to be some errors in the Teachers grade book. 96.
Jean-Francois’ name is actually Francois-Xavier, correct his name. 97. Marie’s
grades were accidentally switched, change her grades to a 95 on the Midterm
and a 92 on the Final Exam. 98. Venantie
was never a student in the class, delete Row 7. 99. Two
students’ grades were left out. The
students are Alphonse, 77 on the Midterm and 91 on the Final, and Alain, 83 on
the Midterm and 86 on the Final. Add these students and keep the students listed in
alphabetical order. 100. Compute
the new class averages for the Midterm and the Final Exam. 101. Change
the font of the entire document to Impact size 12.
Save
the spreadsheet as “Your Name –
Questions 96-101” |
