G6 - Unit 3 - Task 1&2

Microsoft Excel has few number of formulas and functions.

• True

• False

Some of Microsoft Excel functions are for numbers and some for text and dates.

• True

• False

When you do calculations you do them from left to right.

• True

• False

Function returns the number of the cells that contains numbers.

• COUNT

• CONCAT

• LEN

Function return the number of characters in a text cell.

• COUNT

• CONCAT

• LEN

Function combine two or more text cells.

• COUNT

• CONCAT

• LEN

Function combine two or more text cells.

• COUNT

• CONCAT

• LEN

Function that return the computer's date.

• NOW

• TODAY

Function that return the computer's time and date.

• NOW

• TODAY

The calculation symbol for multiplication in Microsoft Excel is:

• +

• -

• *

• /