BECE ICT past questions – Spreadsheet Applications
Quiz-summary
0 of 110 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
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
Information
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 pass the previous Module’s quiz in order to start this quiz
Results
Results
0 of 110 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Earned Points: 0 of 0, (0)
0 Essay(s) Pending (Possible Points: 0)
Average score |
|
Your score |
|
Categories
- Spreadsheet Applications 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
- 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
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- Answered
- Review
-
Question 1 of 110
1. Question
Category: Spreadsheet ApplicationsYou can zoom a worksheet ………………………….
CorrectIncorrect -
Question 2 of 110
2. Question
Category: Spreadsheet ApplicationsYou cannot link Excel worksheet data to a word document ……………………..
CorrectIncorrect -
Question 3 of 110
3. Question
Category: Spreadsheet ApplicationsThis type of software is similar to an accountant’s worksheet.
CorrectIncorrect -
Question 4 of 110
4. Question
Category: Spreadsheet ApplicationsWhich function will calculate the number of workdays between 6/9/2004 and 8/12/2010?
CorrectIncorrect -
Question 5 of 110
5. Question
Category: Spreadsheet ApplicationsData marker on a chart are linked to data points in a worksheet, therefore …………………………..
CorrectIncorrect -
Question 6 of 110
6. Question
Category: Spreadsheet ApplicationsWhen you group worksheets ………………………………………..
CorrectIncorrect -
Question 7 of 110
7. Question
Category: Spreadsheet ApplicationsYou can use the format painter multiple times before you can turn it off by …………………………..
CorrectIncorrect -
Question 8 of 110
8. Question
Category: Spreadsheet ApplicationsThe default header for a worksheet is …………………………….
CorrectIncorrect -
Question 9 of 110
9. Question
Category: Spreadsheet ApplicationsWhich of the following is an absolute cell reference?
CorrectIncorrect -
Question 10 of 110
10. Question
Category: Spreadsheet ApplicationsWhat symbol is used before a number to make it a label?
CorrectIncorrect -
Question 11 of 110
11. Question
Category: Spreadsheet ApplicationsWhich symbol must all formula begin with?
CorrectIncorrect -
Question 12 of 110
12. Question
Category: Spreadsheet ApplicationsWhich of the following formulas is not entered correctly?
CorrectIncorrect -
Question 13 of 110
13. Question
Category: Spreadsheet ApplicationsWhich of the following formulas will Excel not be able to calculate?
CorrectIncorrect -
Question 14 of 110
14. Question
Category: Spreadsheet ApplicationsA typical worksheet has ………………………… number of columns.
CorrectIncorrect -
Question 15 of 110
15. Question
Category: Spreadsheet ApplicationsHow many characters can be typed in a single ell in Excel?
CorrectIncorrect -
Question 16 of 110
16. Question
Category: Spreadsheet ApplicationsWhich of the following is not an example of a value?
CorrectIncorrect -
Question 17 of 110
17. Question
Category: Spreadsheet ApplicationsA worksheet can have a maximum of ……………………….. number of rows.
CorrectIncorrect -
Question 18 of 110
18. Question
Category: Spreadsheet ApplicationsThe chart wizard term data series refers to ……………………
CorrectIncorrect -
Question 19 of 110
19. Question
Category: Spreadsheet ApplicationsThe chart wizard term data categories refer to:
CorrectIncorrect -
Question 20 of 110
20. Question
Category: Spreadsheet ApplicationsA worksheet range is a ……………………………
CorrectIncorrect -
Question 21 of 110
21. Question
Category: Spreadsheet ApplicationsGetting data from a cell located in a different sheet is called ………………………….
CorrectIncorrect -
Question 22 of 110
22. Question
Category: Spreadsheet ApplicationsTab scrolling button ………………………………………………..
CorrectIncorrect -
Question 23 of 110
23. Question
Category: Spreadsheet ApplicationsA numerical value can be treated as a label value if it proceeds with …………………………….
CorrectIncorrect -
Question 24 of 110
24. Question
Category: Spreadsheet ApplicationsConcatenation of text can be done using ……………………………………
CorrectIncorrect -
Question 25 of 110
25. Question
Category: Spreadsheet ApplicationsData can be arranged in a worksheet in an easy to understand manner using ……………………………….
CorrectIncorrect -
Question 26 of 110
26. Question
Category: Spreadsheet ApplicationsYou can use drag and drop to embed excel worksheet data in a word document …………………………..
CorrectIncorrect -
Question 27 of 110
27. Question
Category: Spreadsheet ApplicationsThe auto-calculate feature …………………………………
CorrectIncorrect -
Question 28 of 110
28. Question
Category: Spreadsheet ApplicationsExcel uniquely identifies cells within a worksheet with a ……………………………….
CorrectIncorrect -
Question 29 of 110
29. Question
Category: Spreadsheet ApplicationsTo view a cell comment
CorrectIncorrect -
Question 30 of 110
30. Question
Category: Spreadsheet ApplicationsWhen you want to insert a blank embedded excel object in a word document you can ………………………………………..
CorrectIncorrect -
Question 31 of 110
31. Question
Category: Spreadsheet ApplicationsTo save a workbook, …………………………………………
CorrectIncorrect -
Question 32 of 110
32. Question
Category: Spreadsheet ApplicationsYou can edit a cell by …………………………………………..
CorrectIncorrect -
Question 33 of 110
33. Question
Category: Spreadsheet ApplicationsYou can select a single range of cells by ……………………………….
CorrectIncorrect -
Question 34 of 110
34. Question
Category: Spreadsheet ApplicationsWhich elements of Worksheets can be protected from accidental modification?
CorrectIncorrect -
Question 35 of 110
35. Question
Category: Spreadsheet ApplicationsYou can use the drag and drop method to ……………………………………..
CorrectIncorrect -
Question 36 of 110
36. Question
Category: Spreadsheet Applicationsit is acceptable to let long text flow into adjacent cells on a Worksheet when ……………………………….
CorrectIncorrect -
Question 37 of 110
37. Question
Category: Spreadsheet ApplicationsHow can you delete a record?
CorrectIncorrect -
Question 38 of 110
38. Question
Category: Spreadsheet ApplicationsRight-clicking something in Excel:
CorrectIncorrect -
Question 39 of 110
39. Question
Category: Spreadsheet ApplicationsDocumentation should include ……………………………………….
CorrectIncorrect -
Question 40 of 110
40. Question
Category: Spreadsheet ApplicationsFiles created with Lotus 1-2-3 have an extension ……………………………….
CorrectIncorrect -
Question 41 of 110
41. Question
Category: Spreadsheet ApplicationsTo delete an embedded object, first …………………………………..
CorrectIncorrect -
Question 42 of 110
42. Question
Category: Spreadsheet ApplicationsComments can be added to cells using …………………………………
CorrectIncorrect -
Question 43 of 110
43. Question
Category: Spreadsheet ApplicationsWhich of the following is not a Worksheet design criterion?
CorrectIncorrect -
Question 44 of 110
44. Question
Category: Spreadsheet ApplicationsTo copy cell contents using the drag and drop, press the ……………………………
CorrectIncorrect -
Question 45 of 110
45. Question
Category: Spreadsheet ApplicationsWhich of the following is the correct formula in Excel?
CorrectIncorrect -
Question 46 of 110
46. Question
Category: Spreadsheet ApplicationsWhen you copy a formula ……………………………
CorrectIncorrect -
Question 47 of 110
47. Question
Category: Spreadsheet ApplicationsThe autofill feature ………………………………….
CorrectIncorrect -
Question 48 of 110
48. Question
Category: Spreadsheet ApplicationsWhich menu options can be used to split Windows into two?
CorrectIncorrect -
Question 49 of 110
49. Question
Category: Spreadsheet ApplicationsYou can use the formula palette to ………………………………..
CorrectIncorrect -
Question 50 of 110
50. Question
Category: Spreadsheet ApplicationsYou can convert existing Excel worksheet data and charts to an HTML document by using …………………………
CorrectIncorrect -
Question 51 of 110
51. Question
Category: Spreadsheet ApplicationsA circular reference is ………………………………
CorrectIncorrect -
Question 52 of 110
52. Question
Category: Spreadsheet ApplicationsWhich of the following is not one of Excel’s what-if functions?
CorrectIncorrect -
Question 53 of 110
53. Question
Category: Spreadsheet ApplicationsWhen you insert an Excel file into a Word document, the data is ……………………………..
CorrectIncorrect -
Question 54 of 110
54. Question
Category: Spreadsheet ApplicationsWhich of the following is not an information you can specify using the Solver?
CorrectIncorrect -
Question 55 of 110
55. Question
Category: Spreadsheet ApplicationsEach Excel file is called a Workbook because ……………………………..
CorrectIncorrect -
Question 56 of 110
56. Question
Category: Spreadsheet ApplicationsExcel probably considers the cell entry January 31st, 2013 to be a ………………………………
CorrectIncorrect -
Question 57 of 110
57. Question
Category: Spreadsheet ApplicationsWhich types of data can you enter into Worksheet cells?
CorrectIncorrect -
Question 58 of 110
58. Question
Category: Spreadsheet ApplicationsAll worksheet formula
CorrectIncorrect -
Question 59 of 110
59. Question
Category: Spreadsheet ApplicationsWhich of the following is the correct order of precedence in formula calculation?
CorrectIncorrect -
Question 60 of 110
60. Question
Category: Spreadsheet ApplicationsThe Paste Special command let you copy and paste ……………………………….
CorrectIncorrect -
Question 61 of 110
61. Question
Category: Spreadsheet ApplicationsThe numbers in our Worksheet look like this (1000). You want them to look like this ($1,000.00). How can you accomplish this?
CorrectIncorrect -
Question 62 of 110
62. Question
Category: Spreadsheet ApplicationsWhich of the following is not a valid data type in Excel?
CorrectIncorrect -
Question 63 of 110
63. Question
Category: Spreadsheet ApplicationsExcel worksheets cells work very similarly to what common elements of the Windows graphical user interface?
CorrectIncorrect -
Question 64 of 110
64. Question
Category: Spreadsheet ApplicationsWhich of the following options is not located in the Page Setup dialogue box?
CorrectIncorrect -
Question 65 of 110
65. Question
Category: Spreadsheet ApplicationsYou want to track the progress of the stock market on a daily basis. Which type of chart should you use?
CorrectIncorrect -
Question 66 of 110
66. Question
Category: Spreadsheet ApplicationsWithout using the mouse or the the arrow keys, which is the fastest way of getting to cell A1 in a spreadsheet?
CorrectIncorrect -
Question 67 of 110
67. Question
Category: Spreadsheet ApplicationsWhich of the following methods cannot be used to edit the contents of a cell?
CorrectIncorrect -
Question 68 of 110
68. Question
Category: Spreadsheet ApplicationsIf you begin typing an entry into a cell and realise that you don’t want your entry placed into a cell, ……………………………….
CorrectIncorrect -
Question 69 of 110
69. Question
Category: Spreadsheet ApplicationsWhich of the following methods cannot be used to enter data in a cell?
CorrectIncorrect -
Question 70 of 110
70. Question
Category: Spreadsheet ApplicationsWhich of the following will not cut information?
CorrectIncorrect -
Question 71 of 110
71. Question
Category: Spreadsheet ApplicationsWhich of the following is not a way to complete a cell entry?
CorrectIncorrect -
Question 72 of 110
72. Question
Category: Spreadsheet ApplicationsYou can activate a cell by ……………………………..
CorrectIncorrect -
Question 73 of 110
73. Question
Category: Spreadsheet ApplicationsText formulas …………………………….
CorrectIncorrect -
Question 74 of 110
74. Question
Category: Spreadsheet ApplicationsHow do you insert a row?
CorrectIncorrect -
Question 75 of 110
75. Question
Category: Spreadsheet ApplicationsWhich of the following is not a basic step in creating a worksheet?
CorrectIncorrect -
Question 76 of 110
76. Question
Category: Spreadsheet ApplicationsHow do you select an entire column?
CorrectIncorrect -
Question 77 of 110
77. Question
Category: Spreadsheet ApplicationsHow can you print three copies of a workbook?
CorrectIncorrect -
Question 78 of 110
78. Question
Category: Spreadsheet ApplicationsTo create a formula, you first ………………………………
CorrectIncorrect -
Question 79 of 110
79. Question
Category: Spreadsheet ApplicationsTo create worksheet titles across a range of cells, you must …………………………….
CorrectIncorrect -
Question 80 of 110
80. Question
Category: Spreadsheet ApplicationsHow do you delete a column?
CorrectIncorrect -
Question 81 of 110
81. Question
Category: Spreadsheet ApplicationsHow can you find specific information in a list?
CorrectIncorrect -
Question 82 of 110
82. Question
Category: Spreadsheet ApplicationsWhen integrating Word and Excel, word is usually the …………………………………..
CorrectIncorrect -
Question 83 of 110
83. Question
Category: Spreadsheet ApplicationsWhen a label is too long to fit within a worksheet, you typically must ………………………………
CorrectIncorrect -
Question 84 of 110
84. Question
Category: Spreadsheet ApplicationsThe name box
CorrectIncorrect -
Question 85 of 110
85. Question
Category: Spreadsheet ApplicationsComments put in cells are called ……………………………………
CorrectIncorrect -
Question 86 of 110
86. Question
Category: Spreadsheet ApplicationsWhich of these is used to perform ‘What If’ analysis?
CorrectIncorrect -
Question 87 of 110
87. Question
Category: Spreadsheet ApplicationsYou can use the horizontal and vertical scroll bars to ……………………………….
CorrectIncorrect -
Question 88 of 110
88. Question
Category: Spreadsheet ApplicationsMultiple calculations can be made in a single formula using …………………………
CorrectIncorrect -
Question 89 of 110
89. Question
Category: Spreadsheet ApplicationsHyperlinks can be …………………………………….
CorrectIncorrect -
Question 90 of 110
90. Question
Category: Spreadsheet ApplicationsTo activate the previous cell in a pre-selected range, press ………………………………….
CorrectIncorrect -
Question 91 of 110
91. Question
Category: Spreadsheet ApplicationsWhich button do you click to add up a series of numbers?
CorrectIncorrect -
Question 92 of 110
92. Question
Category: Spreadsheet ApplicationsWhen the formula bar is active, you can see ………………………………….
CorrectIncorrect -
Question 93 of 110
93. Question
Category: Spreadsheet ApplicationsTo copy formatting from one area in a worksheet and apply it to anther area, you would use ………………………….
CorrectIncorrect -
Question 94 of 110
94. Question
Category: Spreadsheet ApplicationsIn a worksheet, you can select ……………………………..
CorrectIncorrect -
Question 95 of 110
95. Question
Category: Spreadsheet ApplicationsWhen you link data maintained in an Excel workbook to a word document ……………………………..
CorrectIncorrect -
Question 96 of 110
96. Question
Category: Spreadsheet ApplicationsWhich area in an Excel window allows entering values and formulas
CorrectIncorrect -
Question 97 of 110
97. Question
Category: Spreadsheet ApplicationsTo hold row and column titles in place so that they do not scroll when you scroll a worksheet click the …………………………
CorrectIncorrect -
Question 98 of 110
98. Question
Category: Spreadsheet ApplicationsTo edit an embedded worksheet object in a Word document ………………………………
CorrectIncorrect -
Question 99 of 110
99. Question
Category: Spreadsheet ApplicationsTo create a formula, you can use ……………………………..
CorrectIncorrect -
Question 100 of 110
100. Question
Category: Spreadsheet ApplicationsStatus indicators are located on the ………………………….
CorrectIncorrect -
Question 101 of 110
101. Question
Category: Spreadsheet ApplicationsWhich of the following is the oldest spreadsheet package?
CorrectIncorrect -
Question 102 of 110
102. Question
Category: Spreadsheet ApplicationsRounding errors can occur …………………………….
CorrectIncorrect -
Question 103 of 110
103. Question
Category: Spreadsheet ApplicationsYou can copy data or formulas ………………………………
CorrectIncorrect -
Question 104 of 110
104. Question
Category: Spreadsheet ApplicationsYou cannot link Excel worksheet data to a word document ……………………………….
CorrectIncorrect -
Question 105 of 110
105. Question
Category: Spreadsheet ApplicationsWhich of the following is not a feature of the spreadsheet application window?
CorrectIncorrect -
Question 106 of 110
106. Question
Category: Spreadsheet ApplicationsAn Excel document is called ……………………………..
CorrectIncorrect -
Question 107 of 110
107. Question
Category: Spreadsheet ApplicationsIn a spreadsheet, columns are labelled as ………………………..
CorrectIncorrect -
Question 108 of 110
108. Question
Category: Spreadsheet ApplicationsIn a spreadsheet, rows are labelled as …………………………..
CorrectIncorrect -
Question 109 of 110
109. Question
Category: Spreadsheet ApplicationsThe working area in an Excel window is called ……………………………..
CorrectIncorrect -
Question 110 of 110
110. Question
Category: Spreadsheet ApplicationsThe intersection of a row and column is called …………………………..
CorrectIncorrect