CA ITT MS Excel Online Test
Finish Quiz
0 of 60 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
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
Information
CA ITT MS Excel Online Test. CA ITT Question and Answers in English. Take MS Excel Free Online Test in English. CA ITT MS Excel Online mock test paper is free for all students and Very Helpful for Exam Preparation. CA ITT MS Excel Online Quiz. CA Information Technology Online Test. CA ITT Online Mock test for MS Excel Topic. Here we are providing CA ITT MS Excel Online Test Series in English. Check CA ITT Mock Test Series 2024-2024.
This paper has 60 questions.
Time allowed is 60 minutes.
The CA ITT online Mock Test Exam is Very helpful for all students. Now Scroll down below n click on “Start Quiz” or “Start Test” and Test yourself.
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 60 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score |
|
Your score |
|
Categories
- Not categorized 0%
Pos. | Name | Entered on | Points | Result |
---|---|---|---|---|
Table is loading | ||||
No data available | ||||
- 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
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- Answered
- Review
-
Question 1 of 60
1. Question
VBA stands for ______________________.
Correct
Incorrect
-
Question 2 of 60
2. Question
The Excel 2007 worksheet contains _______ columns.
Correct
Incorrect
-
Question 3 of 60
3. Question
MS Excel 2007 displays ____ worksheets by default.
Correct
Incorrect
-
Question 4 of 60
4. Question
A cell reference in a spreadsheet can refer to _________________.
Correct
Incorrect
-
Question 5 of 60
5. Question
In Excel, a cell on a different sheet of the same spreadsheet is addressed as
_______________.Correct
Incorrect
-
Question 6 of 60
6. Question
Full form of OLE is __________________.
Correct
Incorrect
-
Question 7 of 60
7. Question
Keyboard shortcut to show a shortcut menu in Excel, is _______________.
Correct
Incorrect
-
Question 8 of 60
8. Question
Excel gives a ______ extension to the template file.
Correct
Incorrect
-
Question 9 of 60
9. Question
Which function is used in Excel to enter current date?
Correct
Incorrect
-
Question 10 of 60
10. Question
To delete selected rows in Excel 2007, click the arrow next to Delete in Cells group in
Home tab, and then click ______________.Correct
Incorrect
-
Question 11 of 60
11. Question
Keyboard shortcut to save a workbook in Excel, is _____.
Correct
Incorrect
-
Question 12 of 60
12. Question
In MS Excel, references to cells in other workbooks are called _____.
Correct
Incorrect
-
Question 13 of 60
13. Question
In Excel, when E$5 is copied down or across, the _________ reference can change.
Correct
Incorrect
-
Question 14 of 60
14. Question
Which of these is a valid range name in Excel?
Correct
Incorrect
-
Question 15 of 60
15. Question
How to name a range in Excel?
Correct
Incorrect
-
Question 16 of 60
16. Question
Which operator is used for exponentiation in Excel?
Correct
Incorrect
-
Question 17 of 60
17. Question
In Excel, ____ are structured programs that calculate a specific result.
Correct
Incorrect
-
Question 18 of 60
18. Question
In Excel, FACT(2.9) returns __________.
Correct
Incorrect
-
Question 19 of 60
19. Question
In Excel, LOG function returns the ________________.
Correct
Incorrect
-
Question 20 of 60
20. Question
In Excel, MROUND(1.3, 0.2) returns _______.
Correct
Incorrect
-
Question 21 of 60
21. Question
In Excel, __________ returns the average of the absolute deviations of data points from
their mean.Correct
Incorrect
-
Question 22 of 60
22. Question
In Excel, ___ error message is given if the formula contains a blank cell.
Correct
Incorrect
-
Question 23 of 60
23. Question
In Excel, _________ error message is given if the formula contains text that Excel doesn’t
recognize.Correct
Incorrect
-
Question 24 of 60
24. Question
To manually calculate all the formulas in a worksheet, press _______.
Correct
Incorrect
-
Question 25 of 60
25. Question
To have column and row headings visible while scrolling the worksheet,
_______________ feature is used.Correct
Incorrect
-
Question 26 of 60
26. Question
If a cell is formatted as Accounting in Excel, zero values are shown as ________.
Correct
Incorrect
-
Question 27 of 60
27. Question
By default, MS-Excel aligns error values in the ________.
Correct
Incorrect
-
Question 28 of 60
28. Question
If cells A2, A3, B2 and B3 in a worksheet are merged, the cell reference for the merged
cell is _______.Correct
Incorrect
-
Question 29 of 60
29. Question
Which of the following is not a chart type in Excel?
Correct
Incorrect
-
Question 30 of 60
30. Question
In MS-Excel, a 3-D column chart uses three axes – a horizontal axis, a vertical axis, and a
________ axis.Correct
Incorrect
-
Question 31 of 60
31. Question
In which of the following situations, Excel’s pie chart should be used?
Correct
Incorrect
-
Question 32 of 60
32. Question
In a clustered bar chart in Excel, the ___________ are typically organized along the
vertical axis.Correct
Incorrect
-
Question 33 of 60
33. Question
In which of the following situations, Excel’s XY charts are not required to be used?
Correct
Incorrect
-
Question 34 of 60
34. Question
Volume-open-high-low-close subtype of stock charts in Excel, requires _____ series of
values.Correct
Incorrect
-
Question 35 of 60
35. Question
In Excel, a 3-D surface chart displayed without color is called a ___________ 3-D surface
chart.Correct
Incorrect
-
Question 36 of 60
36. Question
In Excel, if user wants to create a hyperlink to a specific location in the file or on the Web
page, click _________.Correct
Incorrect
-
Question 37 of 60
37. Question
When a record is deleted using a data form in Excel, __________.
Correct
Incorrect
-
Question 38 of 60
38. Question
In Excel, the user can sort up to _____ levels using the Data Sort dialog box.
Correct
Incorrect
-
Question 39 of 60
39. Question
In Excel, the default criteria setting for AutoFilter in each field is _______.
Correct
Incorrect
-
Question 40 of 60
40. Question
External data source for an Excel workbook can be __________.
Correct
Incorrect
-
Question 41 of 60
41. Question
Which of the following cannot store connection information of an external data source in
Excel?Correct
Incorrect
-
Question 42 of 60
42. Question
A _____________ in Excel, summarizes the columns of information in a database in
relationship to each other.Correct
Incorrect
-
Question 43 of 60
43. Question
In Excel, pivot charts don’t have _________________.
Correct
Incorrect
-
Question 44 of 60
44. Question
Excel’s default margins are _______ on each side.
Correct
Incorrect
-
Question 45 of 60
45. Question
Macros option is in Code group of ________ Ribbon in Excel.
Correct
Incorrect
-
Question 46 of 60
46. Question
In Excel, a ___________ is a grid made up of horizontal rows and vertical columns.
Correct
Incorrect
-
Question 47 of 60
47. Question
In Excel, an absolute cell reference is indicated by prefixing the row and column numbers
with ________.Correct
Incorrect
-
Question 48 of 60
48. Question
Keyboard shortcut for Auto Fill in Excel, is ____________.
Correct
Incorrect
-
Question 49 of 60
49. Question
By default, Excel range names use ___________ cell references.
Correct
Incorrect
-
Question 50 of 60
50. Question
In Excel, INT(-5.7) returns __________.
Correct
Incorrect
-
Question 51 of 60
51. Question
In _______ function in Excel, text and logical values are compared as well as numbers.
Correct
Incorrect
-
Question 52 of 60
52. Question
While tracing precedents of a cell in Excel, if the cell is referenced by a cell on another
worksheet or workbook, a _________ arrow points from the selected cell to a worksheet
icon.Correct
Incorrect
-
Question 53 of 60
53. Question
To apply a gradient or texture to selected cells in a worksheet, use _________________.
Correct
Incorrect
-
Question 54 of 60
54. Question
In Excel, the _______ charts emphasize the magnitude of change over time.
Correct
Incorrect
-
Question 55 of 60
55. Question
Which of the following is not a chart subtype of Excel’s radar charts?
Correct
Incorrect
-
Question 56 of 60
56. Question
In Excel, a macro’s series of commands and functions are stored in
___________________.Correct
Incorrect
-
Question 57 of 60
57. Question
OLAP stands for ________________________.
Correct
Incorrect
-
Question 58 of 60
58. Question
In Excel, a macro can be accessed using ___________.
Correct
Incorrect
-
Question 59 of 60
59. Question
Excel’s ______________ feature doesn’t work with the data form.
Correct
Incorrect
-
Question 60 of 60
60. Question
A __________ is used in Excel, to select records that meet a specific criterion and
temporarily hide all the other records.Correct
Incorrect