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.  
47.       Insert a new column between columns E and F.

 

Save the spreadsheet as “Your Name – Questions 43-47”

 

For Questions 48-52 (M), open the spreadsheet titled, Excel Exam Data F


48.       Adjust the column widths so that the column titles can be read.

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.”
52.       Change the “0” in cell D7 to a “14.”

 

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”

 

 Back to Menu