Introduction+to+Excel

Entering formulas and functions cell references

Info iconThis preview shows pages 2–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Entering formulas and functions Cell references Arithmetic operators (^, *, /, +, -) Order of operations Copy and paste formulas (including paste special: values) Fill handle Function syntax and arguments Ranges Name box will show the active cell Use the Shift and Ctrl keys to select multiple cells (holding down the Shift key and clicking will allow additional contiguous cells to be selected; holding down the Ctrl key and clicking will allow additional non-contiguous cells to be selected) Row range (e.g. 3:3) Column range (e.g. C:C) Copying and moving ranges Creating, saving and closing a workbook Workbooks vs. worksheets Add and delete a worksheet Rearrange worksheets Rename a worksheet (and change the color of the tab) Extensions (xlsx, xlsm, etc) Viewing options Compare sheets side by side Freeze panes Split windows
Background image of page 2

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Printing Excel files Orientation Specifying print area Scale to fit Print titles Printing gridlines Changing page breaks – page break preview Headers and footers
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page2 / 3

Entering formulas and functions Cell references Arithmetic...

This preview shows document pages 2 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online