What is the function of the SUM function in Excel?

Related Mcqs:

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

   A. To perform a logical test and return a value based on the result B. To add up a range of cells C. To find the average of a range of cells D. To count the number of cells in a range 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. In Excel which key is used for create a formula to sum all of the above cells?

   A. Ctrl+= B. Alt+- C. Alt+= D. Ctrl+- Submitted by: Muhammad Danish...

5. 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...

6. 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...

7. 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,...

8. 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...

9. 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...

10. Which shortcut key is used to create chart in MS Excel?

    A. F10 B. F12 C. F11 D. None Submitted by: Areesha Khan...