Numbers and Excel
Understand how to create and manipulate workbooks using spreadsheet software.
CA2.1 Format a spreadsheet to enhance its appearance
Examples:
-
Preview a spreadsheet
-
Change cell dimensions
-
Insert and delete cells
-
Add borders and shading to cells
-
Customize print jobs
-
Use the spell check feature
-
Use the undo and redo feature
-
Sort data
-
Create a list
-
Find and replace data in a spreadsheet
CA2.2 Insert formulas into a worksheet to enhance its functionality
Examples:
-
Use the auto sum button
-
Write formulas with mathematical operators
-
Use absolute and mixed cell references in a formula
CA2.3 Manipulate data within and between workbooks
Examples:
-
Move, copy, and paste data into cells
-
Create a workbook with multiple worksheets
-
Work and print within a range
-
Change worksheet names
CA2.4 Create charts within a spreadsheet to represent data graphically
Examples:
-
Create and format a chart
-
Delete a chart
-
Size and resize a chart to move
-
Change data in the cells of the chart
