Data Entry and Office Administration Certificate Course

1. Learn About Being a Data Entry Clerk

4 Topics | 1 Quiz

Being a Data Entry Clerk – What it Entails?

Requirements for data entry personnel

Data Entry Clerk work environment

Learn About Being a Data Entry Clerk – Quiz

2. Computer types

7 Topics | 1 Quiz

The Personal Computer or PC

Microcontroller

Computer Types – Quiz

3. Main Components of the Computer

4 Topics | 1 Quiz

Hardware & software

Basic operations

Names for different sizes of Data

Main Components of the Computer – Quiz

4. Data Management

7 Topics | 1 Quiz

What is data management?

Managing data acquisition

Managing data utilization

Managing data maintenance

Managing data protection

Managing data confidentiality

Managing data integrity

Data Management – Quiz

5. Getting to know Excel

5 Topics | 1 Quiz

Working with the Excel environment

Changing the Ribbon Display Options

The Quick Access Toolbar

Views on the Worksheet

Getting to know Excel – Quiz

6. Workbooks in Excel

3 Topics | 1 Quiz

Creating a new blank workbook

Utilising templates

Saving and Sharing Workbooks

Workbooks in Excel – Quiz

7. Working with Cells

3 Topics

Understanding cells

Cell Content (Part 1)

Cell Content (Part 2)

8. Using Find & Replace in Excel

2 Topics | 1 Quiz

Finding Content

Replacing the Cell Content

Using Find and Replace in Excel – Quiz

9. Formulas and Functions

3 Topics | 1 Quiz

Comprehending Formulas in Excel

Operator Precedence

Inserting Function

Formulas and Functions – Quiz

10. Most Used Functions

10 Topics | 1 Quiz

INDEX and MATCH

Most Used Functions – Quiz

11. How To Create A Database In Excel For Customers

4 Topics | 1 Quiz

How To Create A Database In Excel For Customers With Examples And Templates

How To Create Data Base In Excel: Step By Step Instructions

Database Maintenance In Excel

How To Filter Data

How To Create A Database In Excel For Customers – Quiz

12. Excel Worksheets – Checking the Integrity of your Worksheets

1 Topic | 1 Quiz

Checking the Integrity of your Excel Worksheets

Excel Worksheets – checking the integrity of your worksheets – Quiz

13. Filing Systems

3 Topics | 1 Quiz

Why should there be a thorough filing system for organisations?

Setting up a Filing System – Part 1

Setting up a Filing System – Part 2

Filing – Quiz

14. Knowledge of General Office Procedures

2 Topics | 1 Quiz

General Office Procedures – Part 1

General Office Procedures – Part 2

Knowledge of General Office Procedures – Quiz

15. What You Need To Know About The Popi Act

1 Topic | 1 Quiz

Basics Of The Popi Act

What You Need To Know About The Popi Act – Quiz

Formulas and Functions – Quiz

Data Entry and Office Administration Certificate Course 9. Formulas and Functions Formulas and Functions – Quiz

Time limit: 0

Quiz Summary

0 of 4 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 4 Questions answered correctly

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4

Current
Review
Answered
Correct
Incorrect

Question 1 of 4

1. Question
Excel uses a _______ _______ where calculations take place
- Ascending Order
- Default Order
- Descending Order
Question 2 of 4

2. Question
Multiple Choice: What are the steps required to enter a formula in Excel ?
- Choose a cell
- Type the formula
- Type an plus sign
- Type an equal sign
Question 3 of 4

3. Question
Multiple Choice: What does Excel display in the formula bar when you pick a cell ?
- Value
- Functions
- Formulas
Question 4 of 4

4. Question
What does Excel change automatically for each new cell when a formula is copied ?
- Cell References
- Paste Options