Spreadsheet - Insert / Comment or Right-click / Insert...

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

View Full Document Right Arrow Icon
Spreadsheet grid of rows and columns Rows Numerical indicator Columns Alphabetical indicator Worksheet Right-click on sheet and Insert/Delete/Rename/Move/ Copy/Change Tab Color OR select from Insert / Format menu items Workbook consists of worksheets Cell Alphanumerical cell reference (A1, AB80) can contain - text IDS 100 - number (numbers are always left-aligned by default) - arithmetic operation =(2*3+38)*2-2^3 - function =SUM(A1:A8) - a cell address =A1 - combination of above =SUM(A1:A8)*4 =SUM(A1:A8)*Round(3.1416,2) Formula Aritmetic operation (follows aritmetic rules with +,-,*,/,^) Order : paranthesis, exponentiation, multiplication or division in left to right order, addition or subtraction in left to right order Should begin with "=" Name Cell Mark cells (range) / Click Name Box / Insert Name Edit Cell F2 OR Double-click/formula bar Insert Cell Insert / Cell / Shift cells right or down OR Right-click / Insert / Shift cells right or down Insert Comment
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Insert / Comment or Right-click / Insert Comment Comments are copied/moved if the cell is copied or moved Edit Comment Right-click Edit or Delete Comment Delete Comment Display Cell Formula Tools/Options/View /Formulas OR CTRL + ~ (tilde) AutoComplete On Tools/Options/Edit Column Mark the column (s) / Right-click on column and following Insert / Delete Cut or Copy/Paste Format Column Width Hide / Unhide OR select from Insert / Format menu items Row Mark the row (s) / Right-click on row and following Insert / Delete Cut or Copy/Paste Format Row Height Hide / Unhide OR select from Insert / Format menu items Page Setup Change page orientation Adjust % or fit to option Adjust margins (left, right, bottom, top) and header/footer Center to page Header / Footer entries Sheet options : print area, gridlines, page order Print Preview Arrange margins Arrange pagebreaks Change page setup options...
View Full Document

This document was uploaded on 10/21/2010.

Page1 / 2

Spreadsheet - Insert / Comment or Right-click / Insert...

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

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