-
Chapter 1: Data Jobs and the Spreadsheet Basics You Need5 Topics1 Quiz
-
Chapter 2: Data Capturing — Fast and Accurate5 Topics1 Quiz
-
Chapter 3: Cleaning Messy Data5 Topics1 Quiz
-
Chapter 4: Counting and Adding Up With Conditions5 Topics1 Quiz
-
Chapter 5: Lookups — VLOOKUP and XLOOKUP5 Topics1 Quiz
-
Chapter 6: Pivot Tables, Charts and Reports5 Topics1 Quiz
-
Chapter 7: Protect the Data, Get Hired and Earn5 Topics1 Quiz
Quizzes
Participants 1
Before you start: Time needed: about 25 minutes. A clean, well-built table is the foundation for everything else in this course.
Do this before you take the chapter quiz.
-
Create a workbook called My Excel Practice in Google Sheets or Excel for the web.
-
On a sheet called Sales, create these headers: Date, Branch, Cashier, Item, Qty, Price, Amount.
-
Type 15 rows of made-up sales for three branches and four cashiers.
-
In the Amount column, multiply Qty by Price, and copy the formula down.
-
Below the data (leave one empty row), add SUM, AVERAGE, MIN and MAX for the Amount column.
-
Freeze the header row and turn on filters.
Chapter complete! You know where these skills are used and you have a clean practice table. Take the quiz, then we’ll make you fast and accurate at data capturing.
Click Mark Complete below. You will go back to the chapter page, where the Chapter 1 Quiz button is waiting for you.
Enjoyed Chapter 1?
Unlock every chapter of Excel & Data Capturing: Get Hired for Admin and Data Jobs and download your certificate. R199 once-off, no monthly fees.
Get the full course – R199
Responses