53
EXL
3
M
uchliketablesinMicrosoftWord,Excelcanbeusedtoorganizedatain
rowsandcolumnsmakinginformationmorereadable.Anumberedlist
caneasilybecreatedsinceAutoFill,afeatureinExcelthatfillsinsequential
informationautomatically,canbeused.
1. Ifthedatafollowsasequentialpattern,suchasdaysoftheweek,monthsof
theyear,orascendingnumbers,useAutoFilltohaveExcelentertheremaining
data.
2. Selectentirerowsandcolumnspriortoinsertingordeletingrowsandcolumns.
This will ensure all data remains intact.
3. Readthroughallinstructionspriortocompletingtheproject.
1. UsingMicrosoftExcel,createanewblankworkbook.
2. SavetheworkbookasProjectEXL-3MovieListinyour"Excel"folderunder
"The Hub" folder.
3. KeythedataasitappearsinFigureEXL-3.1intothespreadsheet.Unless
otherwisenoted,thefontshouldbesettoArial10point.
Hint:
Use AutoFill to insert the rank 1 11 in column A.
4. Changethefontstyleofrow1toElephant(optional)size24point.
5. UseAutoFitincolumnsBthroughDtoadjustthewidthofthecolumnssothat
datafitsappropriately.
6. InsertacolumnbetweenDirectorandGenreandtitleitLength.Keythe
following song lengths:
Length
2:17
2:10
1:54
1:43
1:57
2:08
1:49
2:18
2:01
1:52
1:57
your TASK
Your task is to create a
spreadsheet containing
a list of movies that
have been requested
in the past two
months. Use AutoFill
to number the list. Be
sure to resize columns
and format text. This
spreadsheet is what
The Hub uses to create
the list from which
patrons can select the
movie they would like
to see -- The Reel Hub
Popcorn Pick.
the SKILLS
· Formattext
· UseAutoFill
· Insert rows
· Delete rows
Top 10 Movies
For Evaluation Purposes Only