Scribd
Upload
52 views1 page

Excel Functions Checklist

This document provides a checklist of the spreadsheet functions and skills covered in Computer Applications Technology for grades 10 through 12 in South Africa. It lists the core functions students learn each grade level, such as average, count, max and sum in grade 10, and more advanced functions like concatenate, hlookup, and vlookup in grades 11 and 12. The checklist also covers essential spreadsheet skills including formatting, sorting, printing, basic graphs, and integrating spreadsheets with other programs.

Uploaded by

Wesley Malungane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
52 views1 page

Excel Functions Checklist

This document provides a checklist of the spreadsheet functions and skills covered in Computer Applications Technology for grades 10 through 12 in South Africa. It lists the core functions students learn each grade level, such as average, count, max and sum in grade 10, and more advanced functions like concatenate, hlookup, and vlookup in grades 11 and 12. The checklist also covers essential spreadsheet skills including formatting, sorting, printing, basic graphs, and integrating spreadsheets with other programs.

Uploaded by

Wesley Malungane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

COMPUTER APPLICATIONS TECHNOLOGY - SPREADSHEET CHECKLIST

FUNCTIONS COVERED IN GRADE 10 FUNCTIONS COVERED IN GRADE 11 FUNCTIONS COVERED IN GRADE 12


AVERAGE AVERAGE AVERAGE
COUNT COUNT CONCATENATE
COUNTIF COUNTA COUNT
MAX COUNTBLANK COUNTA
MEAN COUNTIF COUNTBLANK
MIN LARGE COUNTIF
MODE MAX FIND
RAND MEAN HLOOKUP /VLOOKUP
SUM MIN LARGE
TODAY MODE LEFT
POWER LEN
SKILLS RAND MAX
CELL DATA TYPES ROUND MEAN
FORMATTING CELLS SMALL MID
FORMATTING SHEETS/ROWS/COLUMNS SUM MIN
ERROR INDICATORS SUMIF MODE
SORTING DATA TODAY POWER
RENAMING WORKSHEET RAND
HEADERS AND FOOTERS SKILLS (over and above Gr10) RIGHT
PRINTING ABSOLUTE CELL REFERENCING ROUND
GRAPHS (BASIC INTRO) AUTOFILL SMALL
BASIC INTEGRATION CHARTS AND GRAPHS (EDITING) SUM
CIRCULAR REFERENCE ERRORS SUMIF
CONDITIONAL FORMATTING SUMIFS
Compiled by M Hains FREEZING PANES TODAY
GRIDLINES VALUE
INTEGRATION WITH OTHER PACKAGES VLOOKUP
INTEGRATION WITHIN PACKAGE
PRINT OPTIONS AND AREAS SKILLS (over and above Gr11)
ROUNDING OFF NUMBERS NESTED IF'S
TEMPLATES DATE AND TIME CALCULATIONS
WORKING BETWEEN WORKSHEETS #N/A ERROR
STATISTICAL, LOGICAL, LOOKUPS AND REFERENCE
ADVANCED GRAPH EDITING
Download my Android app for your mobile device
http://bit.ly/myCATcheckList

You might also like