Quiz-summary
0 of 31 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
Information
PYQ 2024 MS OFFICE EXCEL.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 31 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- MS EXCEL 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- Answered
- Review
-
Question 1 of 31
1. Question
Presenting data in a form of graph, we use
Correct
Incorrect
-
Question 2 of 31
2. Question
How does a reference to a range appear in the Consolidate dialog box?
Correct
Incorrect
-
Question 3 of 31
3. Question
A function inside another function is known as ?
Correct
Incorrect
-
Question 4 of 31
4. Question
The cell reference for cell range of G2 to M12 is _______
Correct
Incorrect
-
Question 5 of 31
5. Question
One can find “Merge & Center” option under
Correct
Incorrect
-
Question 6 of 31
6. Question
Getting data from a cell located in a different sheet is called …
Correct
Incorrect
-
Question 7 of 31
7. Question
Predict the output of the follwing function: power(5,2)
Correct
Incorrect
-
Question 8 of 31
8. Question
MAX Function is used for
Correct
Incorrect
-
Question 9 of 31
9. Question
Vlookup operation present in
Correct
Incorrect
-
Question 10 of 31
10. Question
Which of the following formulas will Excel Not be able to calculate?
Correct
Incorrect
-
Question 11 of 31
11. Question
To protect a worksheet, you can choose Protection and the Protect Sheet from the_______tab
Correct
Incorrect
-
Question 12 of 31
12. Question
How can you remove borders applied in cells?
Correct
Incorrect
-
Question 13 of 31
13. Question
You can check the conditions against __________ when applying conditional formatting
Correct
Incorrect
-
Question 14 of 31
14. Question
In Microsoft Office 2007 version, an Excel sheet contain _________ no of rows
Correct
Incorrect
-
Question 15 of 31
15. Question
How do you rearrange the data in ascending or descending order?
Correct
Incorrect
-
Question 16 of 31
16. Question
You can create hyperlinks from the Excel workbook to
Correct
Incorrect
-
Question 17 of 31
17. Question
You can use the horizontal and vertical scroll bars to
Correct
Incorrect
-
Question 18 of 31
18. Question
The concatenate(), combine
Correct
Incorrect
-
Question 19 of 31
19. Question
By Formatting a cell in Currency format, you can specify ?
Correct
Incorrect
-
Question 20 of 31
20. Question
Excel uniquely identifies cells within a worksheet with a cell name
Correct
Incorrect
-
Question 21 of 31
21. Question
Red triangle at the top right corner of a cell indicates
Correct
Incorrect
-
Question 22 of 31
22. Question
$A$2 is an example of :
Correct
Incorrect
-
Question 23 of 31
23. Question
Excel is a
Correct
Incorrect
-
Question 24 of 31
24. Question
Which of the following formulas will Excel Not be able to calculate?
Correct
Incorrect
-
Question 25 of 31
25. Question
Which of the following is not the correct method of editing the cell content?
Correct
Incorrect
-
Question 26 of 31
26. Question
Getting data from a cell located in a different sheet is called …
Correct
Incorrect
-
Question 27 of 31
27. Question
A quick way to return to a specific area of a worksheet is to type in the _____
Correct
Incorrect
-
Question 28 of 31
28. Question
What is the shortcut key to hide entire row?
Correct
Incorrect
-
Question 29 of 31
29. Question
Which of the following is correct?
Correct
Incorrect
-
Question 30 of 31
30. Question
Excel probably considers the cell entry January 1, 2000 to be a
Correct
Incorrect
-
Question 31 of 31
31. Question
To select all of the boxes of an organization chart
Correct
Incorrect