DCA MS Excel Mock Test, DCA Excel Online Test in English
Finish Quiz
0 of 50 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
Information
DCA MS Excel Online test, Free DCA MS Excel Mock Test 2024, DCA Computer Quiz. CAknowledge provide DCA MS Excel Mock Test Series 1 in English. DCA Online test is free for all students. find DCA MS Excel online test in english with dca top 50 question. The Course on Computer Concepts programme by DCA, earlier known as DOEACC has been conceived to impart Basic IT and Computer Knowledge. Get some practice through this online DCA MS Excel mock test, get evaluated and improve your scores by attempting maximum questions. Take Free DCA MS Excel Computer Online Test Series 1 in Hindi, DCA DCA Online exam, DCA Questions and answer..
- This paper has 50 questions.
- Time allowed is 60 minutes.
- Language – English
DCA Basic Computer 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 50 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
- Answered
- Review
-
Question 1 of 50
1. Question
VBA stands for ______________________.
Correct
Incorrect
-
Question 2 of 50
2. Question
The Excel 2007 worksheet contains _______ columns.
Correct
Incorrect
-
Question 3 of 50
3. Question
MS Excel 2007 displays ____ worksheets by default.
Correct
Incorrect
-
Question 4 of 50
4. Question
A cell reference in a spreadsheet can refer to _________________.
Correct
Incorrect
-
Question 5 of 50
5. Question
In Excel, a cell on a different sheet of the same spreadsheet is addressed as
_______________.Correct
Incorrect
-
Question 6 of 50
6. Question
Full form of OLE is __________________.
Correct
Incorrect
-
Question 7 of 50
7. Question
Keyboard shortcut to show a shortcut menu in Excel, is _______________.
Correct
Incorrect
-
Question 8 of 50
8. Question
Excel gives a ______ extension to the template file.
Correct
Incorrect
-
Question 9 of 50
9. Question
Which function is used in Excel to enter current date?
Correct
Incorrect
-
Question 10 of 50
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 50
11. Question
Keyboard shortcut to save a workbook in Excel, is _____.
Correct
Incorrect
-
Question 12 of 50
12. Question
In MS Excel, references to cells in other workbooks are called _____.
Correct
Incorrect
-
Question 13 of 50
13. Question
In Excel, when E$5 is copied down or across, the _________ reference can change.
Correct
Incorrect
-
Question 14 of 50
14. Question
Which of these is a valid range name in Excel?
Correct
Incorrect
-
Question 15 of 50
15. Question
How to name a range in Excel?
Correct
Incorrect
-
Question 16 of 50
16. Question
Which operator is used for exponentiation in Excel?
Correct
Incorrect
-
Question 17 of 50
17. Question
In Excel, ____ are structured programs that calculate a specific result.
Correct
Incorrect
-
Question 18 of 50
18. Question
In Excel, FACT(2.9) returns __________.
Correct
Incorrect
-
Question 19 of 50
19. Question
In Excel, LOG function returns the ________________.
Correct
Incorrect
-
Question 20 of 50
20. Question
In Excel, MROUND(1.3, 0.2) returns _______.
Correct
Incorrect
-
Question 21 of 50
21. Question
In Excel, __________ returns the average of the absolute deviations of data points from
their mean.Correct
Incorrect
-
Question 22 of 50
22. Question
In Excel, ___ error message is given if the formula contains a blank cell.
Correct
Incorrect
-
Question 23 of 50
23. Question
In Excel, _________ error message is given if the formula contains text that Excel doesn’t
recognize.Correct
Incorrect
-
Question 24 of 50
24. Question
To manually calculate all the formulas in a worksheet, press _______.
Correct
Incorrect
-
Question 25 of 50
25. Question
To have column and row headings visible while scrolling the worksheet,
_______________ feature is used.Correct
Incorrect
-
Question 26 of 50
26. Question
If a cell is formatted as Accounting in Excel, zero values are shown as ________.
Correct
Incorrect
-
Question 27 of 50
27. Question
By default, MS-Excel aligns error values in the ________.
Correct
Incorrect
-
Question 28 of 50
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 50
29. Question
Which of the following is not a chart type in Excel?
Correct
Incorrect
-
Question 30 of 50
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 50
31. Question
How are data organized in a spreadsheet?
Correct
Incorrect
-
Question 32 of 50
32. Question
A worksheet range is a
Correct
Incorrect
-
Question 33 of 50
33. Question
With which of the following all formulas in excel starts?
Correct
Incorrect
-
Question 34 of 50
34. Question
How can we set Page Border in Excel?
Correct
Incorrect
-
Question 35 of 50
35. Question
On an excel sheet the active cell in indicated by?
Correct
Incorrect
-
Question 36 of 50
36. Question
What term describes explanatory text attached to a cell?
Correct
Incorrect
-
Question 37 of 50
37. Question
How do you change column width to fit the contents?
Correct
Incorrect
-
Question 38 of 50
38. Question
How we can view a cell comment?
Correct
Incorrect
-
Question 39 of 50
39. Question
Which of these will not select all the cells in a document?
Correct
Incorrect
-
Question 40 of 50
40. Question
To insert three columns between columns A and B you would
Correct
Incorrect
-
Question 41 of 50
41. Question
The default style for new data keyed in a new workbook is?
Correct
Incorrect
-
Question 42 of 50
42. Question
If you press ___, the cell accepts your typing as its contents?
Correct
Incorrect
-
Question 43 of 50
43. Question
Which of the following keyboard shortcut can be used for creating a chart from the selected cells?
Correct
Incorrect
-
Question 44 of 50
44. Question
Formula palette is used to?
Correct
Incorrect
-
Question 45 of 50
45. Question
A value used in a formula that does not change is called a?
Correct
Incorrect
-
Question 46 of 50
46. Question
To open an existing workbook, click the Open button on the ___ toolbar?
Correct
Incorrect
-
Question 47 of 50
47. Question
Which among following is not associated with spelling dialogue box?
Correct
Incorrect
-
Question 48 of 50
48. Question
What term describes a background that appears as a grainy, non smooth surface?
Correct
Incorrect
-
Question 49 of 50
49. Question
Which among following is associated with excel?
Correct
Incorrect
-
Question 50 of 50
50. Question
Which of the following is not a valid Zoom percentage in Excel?
Correct
Incorrect