{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
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

{[ snackBarMessage ]}