Essentials of MS Excel - Formulas and Functions
Introduction to Functions and Formulas in Excel
Quiz Result
Quiz Completion Time : 00:02:17
Wrong/Skipped
Right Answer
Your Score : 70%
Passing Score : 50%
Your Strong Areas:
Lesson - Basic Excel Formulas
Lesson - Excel IF Function
1. In how many ways can you insert basic excel formulas?
Your Answer : Five
Description : Inserting basic Excel formulas can be done in five primary ways. These methods are:
Typing the formula directly into the cell.
Using the "Insert Function" button on the Formula tab.
Using keyboard shortcuts.
Select a function from the "Formulas" tab and specify the arguments.
Page 1 of 3
Copying a formula from one cell and pasting it into another.
Question Reference From : Basic Excel Formulas
2. The “If” function cannot be used for more than one condition.
Your Answer : False
Description : “If” function can be used for more than one condition or criterion in the given range of data.
Question Reference From : Excel IF Function
3. Which of the following statement is correct definition of a formula in excel?
Your Answer : It is an expression that operates on values in a range of cells or a cell
Description : In Excel, a formula is an expression that operates on values in a range of cells or a cell. For
example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Question Reference From : Basic Excel Formulas
4. What are min and max in excel?
Your Answer : Maximum and minimum numbers in the column
Correct Answer : Minimum and maximum in the selected range
Description : Min and Max are the formulas used in Excel to find out the highest and lowest values in Excel.
Question Reference From : Basic Excel Formulas
5. The IF function can help in identifying less than and greater than values in a range.
Your Answer : True
Description : Several comparison operators can be used in the If function such as; = (equal to), > (greater
than), < (less than), >= (greater than or equal to), <= (less than or equal to), and <> (not equal to).
Question Reference From : Excel IF Function
6. While using the “IF” function in Excel, always enclose the text in double _______ marks.
Your Answer : Brackets
Correct Answer : Quotation
Description : Always enclose the text in double quotation marks while mentioning the condition or the if
factor in the formula.
Question Reference From : Excel IF Function
Page 2 of 3
7. The IF function checks whether a condition is met, and returns one value if _____ and another value if
_____.
Your Answer : True or False
Description : This function performs the test, then if the result is true, uses the entry in the position true. If
the result is not true, the entry for false is used.
Question Reference From : Excel IF Function
8. What does the “IF” function do?
Your Answer : None of the Above
Correct Answer : It checks whether a condition is met
Description : The IF function checks whether a condition is met, and returns one value if true and another
value if false.
Question Reference From : Excel IF Function
9. What are the functions in excel?
Your Answer : Functions are predefined formulas in excel
Description : Functions in Excel are predefined formulas that perform specific calculations, data
manipulations, or operations on cell values.
Question Reference From : Basic Excel Formulas
10. What is the correct formula for calculating average?
Your Answer : =Average(range)
Description : While calculating average one needs to insert = sign, type Average and select the range. The
average for that particular set of data is calculated.
Question Reference From : Basic Excel Formulas
Page 3 of 3
