Information Processing 10, 20, 30

(a)	Demonstrate basic data entry and manipulation in spreadsheets.
(b)	Describe the benefits of a separate number pad when working in a spreadsheet program.
(c)	Generate spreadsheets that contain cells with all three types of information (label, value, formula) to build documents such as invoices, gradebooks or scoresheets.
(d)	Apply basic cell and document formatting features such as: changing font attributes (e.g., size, style, colour, underline, bold, italics); changing cell attributes (e.g., number category, alignment, fill, borders); adding or removing headers and footers; and, changing the page layout (e.g., margins, orientation, paper size).
(e)	Edit simple spreadsheets by: making corrections; applying the text to columns function; inserting and deleting rows or columns; combining multiple columns into one; moving and copying formulas, rows and columns; and, performing calculations and recalculations.
(f)	Identify common error values (e.g., ######error, #Name?error, #VALUE!error, #REF!error) and how to fix them.
(g)	Differentiate between absolute and relative cell references.
(h)	Explain how an IF function can be used to solve a problem on a spreadsheet.
(i)	Compare characteristics of different views (e.g., print view, frozen panes) of a spreadsheet.
(j)	Change the print orientation and margins of a worksheet for optimal viewing and information retrieval.
(k)	Print a specific set of cells or a segment of a worksheet.
(l)	Perform actions such as printing, copying, pasting and undoing, using keyboard shortcuts.

←

→