Excel Practical

Anonymous
timer Asked: Apr 8th, 2018
account_balance_wallet $10

Question description

EXCEL PRACTICAL EXERCISE – 2

Charting

Instructions:

  • Copy the following data into a new Excel spreadsheet.Be sure to keep the cell data the same
  • Save the workbook as yourname_P2.
  • At G2 enter the column title: Total
    • Calculate the total for each month over the last 5 years
    • Use the fill handle to copy the formula
  • At A15 enter the row title: Yearly Total
    • Find the yearly total for each of the years
  • At A17 enter the row title: Highest
    • Find the highest temperature for each year
  • At A18 enter the row title: Lowest
    • Find the lowest temperature for each year
  • Enter the title at A1:Temperatures
  • Change the Font, Font Size and Color of your Title
    • Size 28
    • Font:Algerian
    • Color:(You Choose)
  • Center the Title across the table
  • Format the rest of the table to your liking
  • Center all of the data, except for column A
  • Make the column widths of columns B – G to be the same 24 pixels
  • Change the sheet tab name to RAINFALL
  • Color the TAB red
  • Create a Column Chart with the Total Temperatures per Month
  • Move the Graph underneath the Table
  • Enter your name, Student ID #, Date and Instructor Name
  • Complete the Document Properties:
    • Your name
    • TAGS (use a minimum of 3, separated by commas)
  • Create a LINE GRAPH comparing the lowest and highest temperatures
  • Move the graph to a new sheet.
    • Call this new sheet HIGHs and LOWs.
    • Color the tab BLUE
  • Save your work and submit

A

B

C

D

E

F

1

2

2013

2014

2015

2016

2017

3

January

12

21

23

17

19

4

February

17

23

19

28

22

5

March

36

40

33

37

36

6

April

55

59

49

58

53

7

May

66

67

65

62

62

8

June

72

71

76

71

72

9

July

76

76

74

72

75

10

August

83

81

80

81

85

11

September

75

76

77

76

78

12

October

57

59

59

54

60

13

November

35

41

44

49

42

14

December

33

35

37

32

31


GRAPH 1

GRAPH 2

Tutor Answer

Tutortitus
School: Rice University

Hello buddy, attached is the completed practical ...

flag Report DMCA
Review

Anonymous
Wow this is really good.... didn't expect it. Sweet!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors