What is the function of the IF function in Excel?

Related Mcqs:

1. What is the function of the SUM function in Excel?

   A. To add up a range of cells B. To find the average of a range of cells C. To count the number of cells in a range D. To find the maximum value in a range of cells Submitted by: Areesha Khan...

2. What is the function of the VLOOKUP function in Excel?

   A. To perform a vertical lookup and return a value based on a specified criteria B. To perform a horizontal lookup and return a value based on a specified criteria C. To add up a range of cells D. To find the average of a range of cells Submitted by: Areesha Khan...

3. In Excel which key is used to open the excel formula window?

   A. Shift+F6 B. Shift+F3 C. Alt+Shift+F3 D. Alt+Shift+F6 Submitted by: Muhammad Danish...

4. Which function calculates the largest value in a set of numbers in Excel?

   A. Average B. Count C. Minimum D. Maximum Submitted by: UMAR ASGHAR SANDHU...

5. In Ms Excel, which of the following special function keys allow the content in cell?

   A. Shift B. Esc C. Tab D. Space Submitted by: Malik Asghar Hussain...

6. What is the function of Vlookup formula in Excel ?

   A. VLOOKUP retrieve data base on specified criteria from the most left column of the table, searching vertically down for a specified value. B. VLOOKUP stands for “Value Lookup,” which searches horizontally across the top row of a table for a specified value. C. VLOOKUP returns a value from the same row as the lookup value,...

7. Which function allows to define names/text in formulas except the use of selection in MS Excel?

   A. Defined Names B. Create from Selection C. Formulas Bar D. Name Manager Submitted by: Aon Ali Gopang...

8. Which Shortcut keys are used to strikethrough highlighted selection in Excel?

   A. Ctrl+4 B. Ctrl+5 C. Ctrl+6 D. None of the above. Submitted by: Farjan Ahmed Soomro...

9. What does the term “filter” refer to in Excel?

   A. To permanently delete rows or columns B. To format the appearance of cells C. To temporarily hide certain data based on specific criteria D. To create a chart...

10. What is the use of a horizontal Scroll Bar in MS Excel?

    A. to view the data from left to the right B. to view the data in Excel from up and down C. to view the data from right to the left D. None of these Submitted by: Areesha Khan...