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

Words in the spreadsheets are called ____

• labels

• values

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.

• So the total of the cells can be multiplied rather than added.

• So the calculation will be done last.

Which response best completes the following statement: A formula is used to

• perform calculations or other actions.

• find averages.

• Look Up data

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

• True
• False

Which of the following option is a formula?

• A. =SUM(A1:A5)

• B. Add A1 - A5

• C. Subtract the numbers

• D. A1 = A5

An Excel spreadsheet is primarily used for calculating which of the following options

• A. Data

• B. Finances

• C. Numbers

• D. All of the above

All formulas in Excel begin with the following symbol

• A. +

• B. =

• C. %

• D. #

Which function can find the highest value in a cell range?

• a. MAXVALUE

• b. HIGHEST

• c. TOP

• d. MAX

In MS-Excel value used in a formula that does not change is called a

• A.Cell address

• B.Constant

• C.Function

• D.None of these