1. What is the purpose of Goal Seek feature in Excel?
a) Analyzes a range of data
b) To achieve the desired result
c) Create a goal-oriented dashboard
d) Finds the average of a range of values
2. Which of the following functions is not in MS Excel?
a) MAX ()
b) AVG()
c) MIN()
d) SUM()
3. Which key is used to create a new line within a cell in Excel?
a) Enter
b) Shift
c) Alt
d) Ctrl
4. How do you rearrange data in ascending or descending order in MS Excel 2019?
a) Data>Form
b) Data > Table
c) Data > Sort
d) Data>Subtotal
5. What does the AGGREGATE function do in Excel 2019?
a) Adds values to the range
b) Aggregate analysis performers on range of data
c) Multiplies the values in the range
d) Adds text to the range
6. Anand wants to auto sum in cell A7 in his worksheet, for this he wants to use the autosum shortcut key ALT+=. Look at the picture given here and choose the correct answer from the given options.
a) The error will appear in cell A7 because the range
b) The sum of the range A5 : A6 will appear in cell A7.
c) The sum of the range A2:A6 will appear in cell A7.
d) A message appears asking you to enter a number in cell A4.
7. Which language is used to create macro in Excel?
a) C
b) VB
c) Visual C++
d) Java
8. Which function is used to find the highest value in Excel 2019?
a) MAX()
b) MIN()
c) SUM()
d) AVG()
9. Which of the following formulas is not entered correctly in Excel?
a) =97+445
b) =C8*B1
c) 97+45
d) = C9+16
10. Which menu option can be used to split windows in Excel 2019?
a) Review>Window>Split
b) Page Layout>Split
c) Review>Split
d) View > Split
11. Columns are labeled in Excel.
a) 1,2,3…
b) A1, A2…. SA1, SA2….
c) A, B, C…
12. The title of the worksheet is visible in cell A1, but Suresh wants it to appear in the center from cell A1 to cell F1, what should Suresh do for this?
a) Write the title in cell C1
b) Select cells A1 to F1 and press Merge & Center.
c) Select A1 to F1 and send the title
d) Write the title in cell C1 and increase the indent.
13. Using the example shown in the figure below, what will be the result of the formula? =IF(MAX(A2:A8)>A5,MAX(A2:A8)*MIN(B2:B8)
a) 9
b) 1
c) 72
d) 14
14. What do you mean by Excel Workspace?
a) Row’s group
b) Group of worksheets
c) Group of workbooks
d) Group of columns
15. What does the function COUNT( ) do in Excel 2019?
a) Counts the number of cells in a range
b) Adds values into a range
c) Finds the average of a range
d) Multiplies values in a range
16. Shortcut key Ctrl+R is used in Excel.
a) To right align the contents of a cell
b) To fill the selection of active cells to the right
c) Deleting the contents of selected cells
d) None of the above
17. Looking at the diagram of the database, choose the correct formula that can be used to calculate the fields in the database. Should be written in B10, where class is Biology and instructor is Vijay
a) #NAME?
b) = DCOUNT ( A1 :D8, 4, F2:G3)
c) =DCOUNT(A1:D8, Marks, F2:G3)
d) Both 1 and 2 are correct
18. For the example of DSUM shown in the figure, which of the given statements are true?
a) DSUM calculates total profit: Tree having Apple
b) DSUM calculates total profit: Tree Mango having
c) Both 1 or 2
d) None of the above
19. Which statement is true for the folder option marked in blue circle in the picture?
a) All recent file locations where you saved the workbook
b) Properties of workbook
c) Neither 1 nor 2 statements are true
d) Both statements 1 and 2 are true
20. How is the HLOOKUP function different from the VLOOKUP function in Excel 2019?
a) HLOOKUP searches horizontally, while VLOOKUP searches vertically.
b) HLOOKUP is used for text, and VLOOKUP is used for
c) HLOOKUP always returns an exact match, whereas VLOOKUP always returns an exact match.
d) HLOOKUP and VLOOKUP are interchangeable, they perform the same function.
21. Which feature in Excel 2019 can be used to visualize data through bars, lines or pie slices?
to submitIs it done for?
a) Conditional formatting
b) Pivot Tables
c) Charts
d) Data validation
22. Which is the correct formula to calculate the largest number among the numbers kept in cells B1 to B7?
a) =LARGE(B1,B7)
b) =LARGE(B1:B7)
c) (s) = LARGE (B1, B7,1)
d) = LARGE (B1:B7,1)
23. Cell G2 to cell M12 are the correct references for the cell range?
a) G2M12
b) G2;M12
c) G2:M12
d) G2-M12
24. The COUNT function can also count dates if written properly in the correct format Rose wants to count how many date entries there are in Column A of her Excel worksheet, see the picture and what will be the value displayed in cell B2?
a) 10
b) 9
c) 7
d) 8
25. Ankit wants to calculate the average of marks of Biology class where Suresh is the instructor. Look at the figure shown below and select the correct criteria which should be given in the yellow highlighted cells to get the desired result?
a) Biology and Suresh
b) Biology and Suresh, Vijay
c) Biology and Vijay
d) All of the above
26. As shown in the figure below, what criteria does the DSUM function use?
a) OR
b) AND
c) Both statements 1 and 2 are true
d) None of the above
27. Look at the picture and choose the correct answer which should be displayed in cell D2?
a) 16
b) 160
c) 26
d) 30
28. In the following example, the field argument is omitted, if the formula =DCOUNT(A1:D8, F2:G3) is typed in cell B10, find the correct answer by looking at the figure below.
a) 8
b) 3
c) 0
d) D entry formula is wrong