Computer Applications – Mrs. Miñoso

Chapter 7 Lecture Notes

• What is a Spreadsheet
• Parts of the Excel Screen (worksheet)
• Entering Data into A Spreadsheet
• Editing a Cell
• Print Preview
• Gridlines and Row and Column Headings
• Headers and Footers
• Changing a Columns Width
• Highlighting Cells
• Formatting Alignments and Fonts
• Formatting Numeric Data
• Number
• Currency
• Percentages
• Time/Date
• Using Formulas to Perform Calculations
• Using Cell References
• Using Functions
• Sum
• Average
• Round

• Displaying Formulas
• Copying Formulas

	Sale Price	Quantity	Using Formulas
Apples
Kiwi
Cherries
Bananas
Mango
Total

	Test	Test	Test	Average
Amy	98%	98%	88%
Brian	25%	89%	78%
Mary	56%	87%	85%
Benny	88%	84%	65%
Cindy	78%	85%	77%
Sophie	95%	96%	44%
Chris	78%	25%	65%
David	99%	77%	30%