# Extended Functions, Sorting & Sheets

> This section builds Grade 10 Spreadsheets skills beyond basic totals. You use the COUNTIF function with relational operators, round values through cell formatting, rename worksheet tabs, sort tables…

- Page: https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets/extended-functions-sorting-and-sheets

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Grade 10](https://www.hlayiso.com/grade-10) › [Computer Applications Technology](https://www.hlayiso.com/grade-10/computer-applications-technology) › [Notes](https://www.hlayiso.com/grade-10/computer-applications-technology/notes) › [Spreadsheets](https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets) › [Extended Functions, Sorting & Sheets](https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets/extended-functions-sorting-and-sheets)

## Full notes

This is a preview of the Extended Functions, Sorting & Sheets notes for Grade 10 Computer Applications Technology. Create a free Hlayiso account to read the full notes, practise every question and track your progress.

## More in Spreadsheets

- [Cell References, Formatting & Basic Functions](https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets/cell-references-formatting-and-basic-functions) — Previous section
- [Charts, Integration & Problem Solving](https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets/charts-integration-and-problem-solving) — Next section
- [All Spreadsheets sections](https://www.hlayiso.com/grade-10/computer-applications-technology/notes/spreadsheets)

## Frequently asked questions

### What will I learn in "Extended Functions, Sorting & Sheets"?

This section covers Extended Functions, Sorting & Sheets as part of Spreadsheets in Grade 10 Computer Applications Technology. You'll find clear explanations, worked examples, and key definitions aligned to the CAPS curriculum.

### Is this section aligned with the CAPS curriculum?

Yes. All notes on Hlayiso, including "Extended Functions, Sorting & Sheets", are written against the official CAPS curriculum and ATP for Grade 10 Computer Applications Technology.

### What should I study after "Extended Functions, Sorting & Sheets"?

Continue with the next section in Spreadsheets, or test your understanding with the interactive quiz linked to this section.

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.