MODULE 6: USING FUNCTIONS AND FORMULAS IN SPREADSHEET

It is an electronic application program designed to perform basic mathematical and arithmetic operations.

• Sheet

• Calculator

• Spreadsheet

• Worksheet

To create and enter formulas and functions in spreadsheet, always start with an equal sign (=).

• TRUE

• FALSE

Type the function.

Average of 12 and 18.

Type the function.

Lowest number in Column B.

Type the function.

Count data in Row 5.

Type the formula.

Multiply A3 and B6.

Type the formula.

Divide 12 by 4.