54
EXL
3
Top 10 Movies
7. Delete row 11.
8. Adjustthe"Rank"columnsothat9,10and11arerenumbered8,9,and10.
9. Left-alignallofthedataincellsA4throughE13.
10. Carefully proofread your work for accuracy and format.
11. Resavethefile.
12. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
13. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Thecenteroftheheadershouldcontainthetext"THEREELHUBPOPCORNPICKS"
· The sheet should show gridlines
· Thescalingshouldbesettofittoonepage
14. Print a copy of the document if required by your instructor.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
A
B
C
D
Top 10 Most Requested Movies at The Reel Hub
Rank
Movie
Director
Genre
1 Pirates of the Carribean: On Stranger Tides
Rob Marshall
Action/Adventure
2 Fast Five
Justin Lin
Action/Adventure
3 Thor
Kenneth Branagh Action/Adventure
4 Something Borrowed
Luke Greenfield
Romance
5 Rio
Mike Posner
Animation
6 Mechanic
Simon West
Action/Adventure
7 The Dilemma
Ron Howard
Comedy
8 The Green Hornet
Michel Condry
Action/Adventure
9 No Strings Attached
Iven Reitman
Comedy
10 Justin Bieber: Never Say Never
Jon M. Chu
Documentary
11 Super 8
JJ Abrams
Sci-Fi
Figure ExL-3.1
For Evaluation Purposes Only