Spreadsheets  

Manipulate and arrange data easily, perform calculations

https://www.computerhope.com/jargon/s/spreadsheet.htm

General Office Screen Area Names

• Ribbon
• Quick Access Toolbar
• Mini Toolbar
• Status bar (Average, Count, Sum)

• Zoom slider

Excel Screen Area Names

Navigation

• Selecting        

• click header
• Ctrl + click
• Shift + click

• Double click to resize columns

Home Ribbon

• Number Format
• Insert row / column
• Format as Table
• AutoSum
• Sort & Filter

Basic Charts

Page Layout Tab

• Print Gridlines

Formula Components

• References:  The cell or range of cells that you want to use in your calculation
• Operators:  Symbols (+, -, *, /, etc.) that specify the calculation to be performed
• Constants:  Numbers or text values that do not change
• Functions:  Predefined formulas in Excel

Resources

• F1 key, question mark icon
• Microsoft Support - https://support.office.com/en-us/excel
• FGCU Technology Skills Orientation - http://www.fgcu.edu/support/

• Excel 2016 Tutorial - https://www2.fgcu.edu/Support/excel2016.html

• bit.ly/prof-v