Quiz-summary
0 of 32 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
- 32
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 32 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
- 32
- Answered
- Review
-
Question 1 of 32
1. Question
MS-EXCEL can be used to automate
Correct
Incorrect
-
Question 2 of 32
2. Question
Pivot table comes in_______ Tab
Correct
Incorrect
-
Question 3 of 32
3. Question
Comments can be added to cells using
Correct
Incorrect
-
Question 4 of 32
4. Question
The Name box on to the left of formula bar
Correct
Incorrect
-
Question 5 of 32
5. Question
One can find “Autosum” option under
Correct
Incorrect
-
Question 6 of 32
6. Question
“Goal Seek” can be applied on
Correct
Incorrect
-
Question 7 of 32
7. Question
PROPER Function is used for
Correct
Incorrect
-
Question 8 of 32
8. Question
What does SUMIF function do?
Correct
Incorrect
-
Question 9 of 32
9. Question
Data can be arranged in ascending or descending order by using
Correct
Incorrect
-
Question 10 of 32
10. Question
To save a workbook, you:
Correct
Incorrect
-
Question 11 of 32
11. Question
To move to the previous worksheet press
Correct
Incorrect
-
Question 12 of 32
12. Question
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Correct
Incorrect
-
Question 13 of 32
13. Question
Which of the following is invalid statement?
Correct
Incorrect
-
Question 14 of 32
14. Question
The Software which contains rows and columns is called ______
Correct
Incorrect
-
Question 15 of 32
15. Question
You can use the drag and drop method to
Correct
Incorrect
-
Question 16 of 32
16. Question
Which of the following is not the correct method of editing the cell content?
Correct
Incorrect
-
Question 17 of 32
17. Question
Which one is the last column header in Excel 2007?
Correct
Incorrect
-
Question 18 of 32
18. Question
Filter option is display
Correct
Incorrect
-
Question 19 of 32
19. Question
How many characters can be typed in a single cell in Excel?
Correct
Incorrect
-
Question 20 of 32
20. Question
Extension of Excel 2007 file
Correct
Incorrect
-
Question 21 of 32
21. Question
How do you select an entire column?
Correct
Incorrect
-
Question 22 of 32
22. Question
MONTH Function is used to
Correct
Incorrect
-
Question 23 of 32
23. Question
How are data organized in a spreadsheet?
Correct
Incorrect
-
Question 24 of 32
24. Question
What is the shortcut key to insert new sheet in current workbook?
Correct
Incorrect
-
Question 25 of 32
25. Question
Formatting a cell in Number format you can’t set
Correct
Incorrect
-
Question 26 of 32
26. Question
You can edit a cell by
Correct
Incorrect
-
Question 27 of 32
27. Question
A Worksheet Range is a
Correct
Incorrect
-
Question 28 of 32
28. Question
How many sheets are there in Excel Workbook by default?
Correct
Incorrect
-
Question 29 of 32
29. Question
By default column width of Excel
Correct
Incorrect
-
Question 30 of 32
30. Question
A circular reference is
Correct
Incorrect
-
Question 31 of 32
31. Question
Excel uniquely identifies cells within a worksheet with a cell name
Correct
Incorrect
-
Question 32 of 32
32. Question
Which Chart can be created in Excel?
Correct
Incorrect