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
Advertisement
Related Mcqs:
- 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,...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- In excel columns are labelled as____________?
- A. A, B, C, etc. B. 1, 2, 3, etc. C. A1, A2, A3, etc. D. $A$1, $A$2, etc. Submitted by: Anwar Haleem...
- Actual working area of Computer’s Microsoft Excel is ________ ?
- A. Workbook B. Worksheet C. Notesheet D. Notebook Submitted by: Rashid Mehmood...
- In Excel, Conditional formatting is in: ______________?
- A. Insert Tab B. Page layout C. View Tab D. Home Tab Submitted by: Farhan Rana...
Advertisement
