NEW
Font size
WorksheetsFormulas in excel
Total questions: 15
Worksheet time: 8mins
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
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
If you copy the formula =$B38 into another cell, the result will be:
a. The column part will remain the same
b. The row part will remain the same
c. Both the column and row will remain the same
d. Both will change
Which of the following is not a function of MS - Excel?
a. AVERAGE
b. ADD
C.MIN
d. MAX
Which error is obtained when a formatted number does not fit within a cell?
a.#####
b.#DIV/0
c.#DIV@
d.#VALUE!
What´s the difference between a formula and a function?
There is no difference
Functions are more complicated than formulas
Formulas are designed by the user and functions are predefined in Excel
They both start with the =
to count any fields containing numbers we use:
countIF function
counta function
count function
countIFs function
