16.4 Formatting a
Spreadsheet
Formatting a spreadsheet involves using different fonts, justifying text, wrapping text, adding or deleting rows and columns, changing column widths and row heights, or changing the cell formats.
Cell formats can be general, fixed (decimal places), currency, comma (every three places), percentage or scientific.
Write out the sentence and fill in the missing word
|
????? is a rectangular grid made up of rows and columns to organise and store data that requires some type of calculation. |
|
????? is the intersection of a row and column. |
|
????? is the position of the cell in the spreadsheet. |
|
????? is text entered into a cell to provide some explanation of the spreadsheet. |
|
????? are numbers stored in a spreadsheet on which calculations are carried out. |
|
????? are instructions to perform a calculation. |
|
????? perform a process and are used to build up required formulas |
|
????? copies the formula exactly, with the cell references remaining the same. |
|
????? copies the mathematical processes such as the operators and functions, but changes the cell references so that they relate to the cell destination. |
|
????? is a document created for repeated use. |
Write out the sentence and fill in the missing words
|
All spreadsheets consist of rows that run ????? across the screen |
|
All spreadsheets consist of columns that run ????? down the screen. |
|
Every cell in a spreadsheet has a different cell ????? |
|
Calculations are not carried out on ????? |
|
Data is entered into a ????? as either a label, value, or a formula. |
|
Whenever values are changed, the ????? recalculate and produce new results |
|
To use a function you must follow special rules or ????? |
|
The ????? command copies cells down a column. |
|
The ????? command copies cells across a row. |
|
A ????? contains labels and formulae and you enter values to obtain the required solution. |