Excel Assignment

Inventory Sheet 1 Movie Guide

The numbers refer directly to the steps in the instruction sheet.

1-4 : Entering all items

5-9 : Formatting cells

10 : Sort

11-12 : Calculate

13 : Functions

14-15 : If statement and Text concatenation

16 : Absolute reference (% of total)

17-end : Page formatting and window freeze pane