Cell - an indvidual box containing a label or value, Workbook - This will contain one or several worksheets, Column Letters - A, B , C etc, Row Numbers - 1, 2, 3 etc, Active cell - The cell where the cursor is flashing, Cell reference - Location: For example D3, A1, Z6 ..., Label - Name used for information in a row or column of data, Value - This will be a number, Graph - A picture of data from a spreadsheet, Pie, Line, Bar, Column - Names of Charts & Graphs, Basic Formula - add, subtract, multiply and or division, Typicla Functions - =Sum(), now(), Min(), Max(), Average(), Formula bar - Shows the formula in an active cell, Cross Hairs (square box in right-bottom corner of the cell) - Duplicate a formula to cells in a range when dragged!, Formatting Skills - Wrap text, change height/width, merge cells, Styles - Bold, underline, shading, borders, italics, M sideways - SUM, Ctrl + Pipe Key ... - Shows formula in a worksheet, Wrap Text - Not Christmas paper perhaps..., Alignment - The position of text or number(s) in a cell or range of cells, Font - Arial, Calibri, Tahoma ..., Absolute Cell - This has a dollar sign in the formula e.g. $A$6,

IT8-Spreadsheets 1

von
Drucken
Einbetten

Bestenliste

Visueller Stil

Einstellungen

Vorlage ändern

Soll die automatisch gespeicherte Aktivität wiederhergestellt werden?