Excel — Spring 22

Excel #1 — My Top 10 Moves

By


Instructions

I) This assignment is based on Lesson 1.

 

II) Create a spreadsheet similar to the one in Lesson 1:

— Instead of the Movie Inventory, the title of the spreadsheet is:

My Top 10 Movies

That is, you enter information about your top 10 favorite movies.

— Create the following columns in your spreadsheet:

    • Ranking
    • Title
    • Release Date
    • Genre
    • Language

 

— Create 10 rows of data for the above columns

— Follow the video’s formatting of the column headings (bold-typed) and the overall heading (centered, italicized and merged center)

— Here is the layout that you should have:

 

III) Correct file extension

When you are ready to submit your spreadsheet to Canvas, make sure that the extension of the file is .xlsx.

If the file extension is not shown on your screen when you are saving the document, then it could be because your desktop is not set to show file extensions. To show file extension on your computer, do the following:

For PC:

https://www.howtogeek.com/205086/beginner-how-to-make-windows-show-file-extensions/

For Mac:

https://support.apple.com/guide/mac-help/show-or-hide-filename-extensions-on-mac-mchlp2304/mac

 

IV) Grading Scheme

Computer work is ALL about details, details and details!

The grader will check if your spreadsheet follows the instructions listed above. Points will be deducted for each mistake. Common mistakes include but are not limited to: missing a column, missing a row, not bold-typing or merging the title, etc.

-END-



Content is copyright the author. Layout is copyright Mark Ciotola. See Corsbook.com for further notices.