background image
18
C
omingsoon.net provides movie release dates and reviews so consumers
can track informati on on movies. Besides movie release dates, the site
off ers features, movie and television news, bulleti n boards, trailers and clips,
previews, DVD news, box offi ce reports, and more. Informati on comes directly
from the studios. Whenever a ti tle goes from an esti mated release date to an
exact release date, it is the studio that provides the informati on. As with any
industry, release dates oft en change.
Many factors determine a movie's video release date including box offi ce
performance, ti me of the year, genre, and target audience. Each studio has its
own way of determining video release dates that vary from movie to movie.
The following acti vity illustrates how spreadsheets can be used to list movie
ti tles, release dates, studios, and directors.
1. Format cells
as dates in a
spreadsheet.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown.
3. Change the font size of cell A2 to 16 point.
4. Bold rows 5 and 6.
5. Select cells A8 ­ A9 and use the AutoFill feature to complete the series of
numbers for cells A8 ­ A30.
6. Format the width of column A to 8.0.
7. Center align cells A6 ­ A30.
8. Format the width of column B to 40.0 and left align.
9. Format the width of column C to 12.0 and center align.
10. Format column C as dates showing mm/dd/yyyy. Example: "12/25/2011."
11. Format the width of columns D and E to 25.0 and left align.
12. Carefully proofread your work for accuracy.
13. Save the spreadsheet as MOVIE RELEASE DATES.
14. Analyze the changes made to the data in the spreadsheet.
15. Set the Print Area to include all cells containing data in the spreadsheet.
16. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page. Set the page orientati on to Landscape.
17. Print a copy of the spreadsheet if required by your instructor.
9
Movie Release Dates
NEW SKILL
ACTIVITY
For Evaluation Purposes Only