2. Spreadsheet—Formulas and Functions

Click the correct answer (True or False).

The Excel operators perform actions on numeric values, text or cell references.

True

False

Click the correct answer.

Which of these application software is used to perform calculations using a formula or a function?

Word 2016

PowerPoint 2016

Excel 2016

MS Access

Click each box on the left and then click the matching box on the right.

Match the columns.

####

#NAME?

#N/A

#VALUE!

#DIV/0!

Column is not enough to display the number

Excel does not recognise the text in a formula

Date is not available

Formula contains an invalid operation

Division by zero is being performed

Click the correct answer.
The option is used to carry out different functions like Average, Count, Max and Min.

Sum

AutoSum

Min

Max

BACK
Screen resolution not supported