Formulas in Excel

What is a formulas in excel sheet

• The address of the cells

• The defined expression that contains values, constants, Call reference, functions and operators

• Numbers or text values that can be entered directly in a formula

Excel displays the error values _________ when the formula contains invalid data

The __________ function Is used to multiply the content Of the cells

____________ Specify the type of Operation you want to perform

An error that occurs when a formula is not spelt correctly

• #NAME?

• #VALUE!

• #DIV/0!

• #####

What feature is particularly useful when you want to add all numbers in a row or column

• Autosum

• Product

• Operators

• Hierarchy

The call references contain values to be used for calculation passed to the function are called

• Arguments

• Operators

• Product

• Autosum

What is error value that is displayed on the excel when the formula contains invalid data

• Autosum

• #VALUE!

• Arguments

• operators

What is Constants

• Built in formulas

• Numbers or texts values

• Microsoft Excel

• Call reference

Where is the option Autosum Present

• Formulas Tab

• Alignment Tab

• Numbers Tab

• Font Tab