Here's the study guide for chapter 7 - Using a Spreadsheet
A spreadsheet is a computer application for storing and analyzing data.
A spreadsheet document is called a workbook.
Each workbook contains three worksheets or sheets.
Rows are horizontal and are labeled with numbers
Columns are vertical and are labeled with letters.
A cell is the intersection of a row and a column.
The name box displays the name of the current cell.
The active cell is displayed with a dark border.
The formula bar is to the left of the name box and is where formulas are entered into a cell.
It is important to plan the layout of a spreadsheet before starting.
Enter key moves you down, tab moves you across, and arrow keys are used to move around the spreadsheet from cell to cell.
Undo will reverse an edit.
Cells can be formatted as text, with bold, italics, underline, and alignment.
Numeric data can be formatted as well by going to format -> cells.
- Number displays a value with two decimal places
- Currency displays a value with a dollar sign and two decimal places.
- Accounting is the same as currency except the dollar sign aligns to the left side
- Percentage displays a value as a percentage with two decimal places.
- Scientific uses scientific notation
Know how to select a range of cells.
File->Print preview allows you to preview the document as it will print.
Know PEMDAS and what it means in Excel (order of operations)
Exponentiation ^
Multiplication *
Division /
Addition +
Subtraction -
Common Errors
- #DIV/0 - divided by zero
- #### - cell to small to display contents
Ctrl+`(grave accent) displays the formulas instead of formula results
Know the difference between cell references and cell contents
Know how to format borders of a range of cells.