GR10 EXCEL

What is a function?

• A function is a built in option that we can get from excel.

• A function is when we use any math operators to get the answers.

• A function is clicking in a cell.

Answer explanation

A function is when we use the build in function from excel. Meaning fx. These function we use to get the total amount or number of certain data we want to calculate. For example, Sum, Min, Max, Count etc.

What does the SUM function do?

• Counts the number of cells in a range

• Calculates the total amount

• Returns the value that occurs most frequently

The function we use to count the number of empty cells in a range

The multiply symbol in Excel

• /

• -

• +

• *

The letters in Excel represents the....

• Rows

• Columns

• Cells

• Data

The numbers in Excel represent the...

• Rows

• Column

• Cells

• Data

When inserting a Formula or Function. It should always start with

• /

• =

• +

• -

What do you call the blocks on an Excel Sheet?

• Value

• Info

• Cell

• Square

What is the name of the Cell?

• A6

• B9

• B1

• B3

Choose the correct function:

The teacher needs to find out how many learners was absent

• =Sum(C2:C6)

• =Count(C2:C6)

• =Max(C2:C6)

• =Count(A2:A6)