Page 1 of 6
Office 2016– Excel Basics 01
Video/Class Project #13
Excel Basics 1: Introduction to Excel 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
Topics Covered in Video:
1) Excel file = “Workbook”, not “Document”
2) Columns (Represented by Letters)
3) Rows (Represented by Numbers)
4) Cells = Intersection of Column and Row = Name or Address like B5 or A1
5) Worksheet = Sheet = All the Cells
6) Sheet Tab = Name of worksheet
i. Double-click Sheet Tab to highlight sheet name, then type sheet name, then hit Enter
ii. You can add new sheets with Plus button to the right of the sheets:
7) Workbook = All the sheets = File = File Name
8) Selection Cursor is the “thick white cross with a slight black shadow” cursor.
9) Move Cursor
i. White diagonal arrow with four-way pointing black arrow underneath.
ii. Click and drag to move things (like cells) in Excel
10) Fill Handle = after you select a cell the little black square in the lower right corner.
11) Cross Hair or “Angry Rabbit” Cursor
i. This black cross cursor that allows you to click on the Fill Handle and drag the cell to copy numbers, text
or formulas.
1. If you have text and numbers, the numbers will increment, like: Quiz 01, Quiz 02…
2. If you have words like Monday or January, it will increment those also
3. If you have formulas, it will copy the formulas
4. If you have a number, it will copy it
5. If you want to increment numbers (like 1, 2, 3):
i. Type 1 and 2 in two cells, highlight both cells, then use Angry Rabbit
ii. Type number and instead of clicking and dragging Angry Rabbit with only Mouse, hold
Ctrl and use Mouse
iii. Type number and then highlight the cell with the number and an empty cell next to the
number and then use Angry Rabbit to click and drag
ii. Double Click Fill Handle with Angry Rabbit and the formula is automatically copied down (if there is stuff
in column to left or right or below)