Worksheets1.5.3 Progressive 1
Total questions: 47
Worksheet time: 24mins
Name
Class
Date
1.
1. To select multiple non-adjacent cells in
a worksheet, click on the cells whilst
holding the
a)
ALT KEY
b)
CTRL KEY
c)
SHIFT KEY
d)
CTRL + ALT KEY
2.
2. Which of the following displays the
content of an active cell in a
worksheet?
a)
Formula Bar
b)
Menu Bar
c)
Name Box
d)
Status Bar
3.
3. A cell formatted to have an accounting
style shows negative numbers in
a)
bold
b)
brackets
c)
double quotes
d)
parentheses
4.
4. The process of identify specific rows and columns so that these rows and columns are always visible on the screen is
a)
fixing
b)
freezing
c)
locking
d)
selecting
5.
5. To select multiple non-adjacent cells in
a worksheet, click on the cells while
holding down the
a)
ALT KEY
b)
CTRL KEY
c)
CTRL + ALT KEY
d)
SHIFT KEY
6.
6. Which of the following displays the
contents of an active cell in workbook?
a)
Formula bar
b)
Menu bar
c)
Name box
d)
Status bar
7.
7. The process of identifying specific
rows and columns so that these rows
and columns are always visible on the
screen is called
a)
fixing
b)
freezing
c)
looking
d)
selecting
8.
8. In a spreadsheet, which of the
following is a text function?
a)
COUNT()
b)
DMAX()
c)
ROUND()
d)
UPPER()
9.
9. A red triangle at the top right comer of
a cell in a spreadsheet program
indicates that
a)
the value in the cell is incorrect
b)
the cell cannot accept formula
c)
there is a comment associated with the cell
d)
the formula entered into the cell has an error
10.
10. Which of the following displays the
contents of an active cell in a
worksheet?
a)
Name box
b)
Menu bar
c)
Formula bar
d)
Status bar
11.
11. A cell formatted to have an accounting
style shows negative number in
a)
bold
b)
brackets
c)
double quotes
d)
parenthesis
12.
12. When a formatted number does not fit
within a cell, it displays
a)
########
b)
#DIV/0!
c)
#DIV/1
d)
#VALUE!
13.
13. What symbol is used to enter a number
as text into a spreadsheet?
a)
,
b)
"
c)
=
d)
+
14.
14. A red triangle at the top right comer of
a cell indicates that
a)
the value in the cell is incorrect
b)
Option 2the cell cannot accept formula
c)
there is a comment associated with the cell
d)
the formula entered into the cell has an error
15.
15. To open the Save As dialogue box in a spreadsheet, press the keyboard key
a)
F1
b)
F2
c)
F3
d)
F12
16.
16. Which of the following operators is
used to concatenation in spreadsheet
application?
a)
Ampersand
b)
Apostrophe
c)
Exclamation
d)
Hash
17.
17. To move to a specific cell
worksheet, enter data in the
a)
Formula box
b)
Name box
c)
Search box
d)
Zoom box
18.
18. When user creates two or more separate windows containing part of the spreadsheet that can be viewed, such a user has created
a)
panes
b)
sections
c)
subsets
d)
views
19.
19. Which of the fallowing symbols is
required when inserting a
formula/function in a spreadsheet
application?
a)
//
b)
#
c)
*
d)
=
20.
20. Spreadsheet applications are designed to
a)
create QBASIC programs for display
b)
generate slides for presentation
c)
store, edit and format graphics and other images
d)
enter and store data organized in rows and columns
21.
21. A grid of rows and columns is called
a)
cell
b)
column
c)
row
d)
table
22.
22. The function key F12 in a spreadsheet application opens the
a)
close dialogue box
b)
font dialogue box
c)
open dialogue box
d)
save as dialogue box
23.
24. Which of the following runs vertically in a table?
a)
Border
b)
Cell
c)
Column
d)
Row
24.
25. The concatenated operator symbol used in a spreadsheet is
a)
,
b)
!
c)
£
d)
&
25.
26. In spreadsheet, a user can create a relationship between two cells using
a)
formula
b)
numbers
c)
parenthesis
d)
text
26.
27. The most appropriate form of graphics used for presenting facts and figures information is
a)
background
b)
chart
c)
flowchart
d)
legend
27.
28. Which of the following formulas will spreadsheet not be able to compute?
a)
=SUM(Scales) - A3
b)
= SUM(A1:A5) * 5
c)
=SUM(A1:A5)/(10 - 10)
d)
=SUM(A1:A5) - 10
28.
29. A function inside another function in a spreadsheet application is called
a)
nested function
b)
round function
c)
sum function
d)
text function
29.
30. The power of spreadsheet applications lies in its
a)
cells
b)
formulas
c)
labels
d)
worksheets
30.
31. Which of the following symbols is used for absolute cell reference in spreadsheet applications?
a)
#
b)
!
c)
&
d)
$
31.
32. Which of the following commands will move the cursor to the previous worksheets?
a)
Control + Page up
b)
Control + Page down
c)
Shift + tab
d)
Ctrl + tab
32.
33. MS-Excel files have the default extension
a)
.doc
b)
.ppt
c)
.txt
d)
.xls
33.
34. Which of the following application uses cells?
a)
QBASIC
b)
Spreadsheet
c)
Presentation package
d)
Communication software
34.
35. Which of the following terms is not a valid data type in a spreadsheet application?
a)
Character
b)
Date
c)
Number
d)
Text
35.
36. Rounding errors in a spreadsheet application can occur when
a)
addition and subtraction are used in a formula.
b)
hidden decimal place values of computation occurs.
c)
multiplication, division and exponentiation are used in a formula
d)
showing the results of formulas with different decimal place values
36.
37. It is acceptable to let long text flow into adjacent cells on a worksheet when
a)
there is no time to format the text
b)
data will be entered in the adjacent cells
c)
there is no suitable abbreviation of the text
d)
no data will be entered in the adjacent cells
37.
38. Which of the following methods cannot be used to enter data in a spreadsheet cell?
a)
Pressing an arrow key
b)
Pressing the tab key
c)
Pressing the ESC key
d)
Clicking on the formula bar
38.
39. The symbol that precedes a number to make it a label in spreadsheet application is the
a)
quote sign.
b)
equal to sign.
c)
underscore sign.
d)
apostrophe sign.
39.
40. Which of the following application is made up of cells?
a)
Spreadsheet
b)
Word processor
c)
Presentation package
d)
Communication software.
40.
41. Which of the following formulas will display the current minute's part the hour of the clock in a spreadsheet application?
a)
=MINUTE ()
b)
MINUTE (NOW ))
c)
=MINUTE (YEAR () )
d)
=MINUTE (HOUR (NOW () ))
41.
42. Which of the following features is not in a spreadsheet application?
a)
Ability to produce charts
b)
Mail merging a performa letter
c)
Capability of making accurate calculations
d)
Files are easily re-opened, re-used and updated
42.
43. What will be the result of writing the formula =today ( ) + 7 in a worksheet of a spreadsheet if the current calendar date is 14 August, 1960?
a)
7 August, 1960
b)
21 August, 1953
c)
21 August, 1960
d)
21 August, 1967
43.
44. If today's is 02/02/2018, what will be the result of typing =today () + 1 in a cell of a spreadsheet?
a)
02/03/2018
b)
03/02/2018
c)
03/03/2018
d)
02/02/2019
44.
45. The term What-If Analysis associated with
a)
database application
b)
desktop publishing application
c)
spreadsheet application.
d)
word processing application
45.
46. Which of the following statements are true about gridlines in spreadsheet?
l. Gridline may be turned off for display but turned on for printing
ll. Gridline may be turned on or off for printing
lll. Gridline may be turned off for display and printing
a)
I and Il only
b)
I and III only
c)
II and III only
d)
l, ll and IIl
46.
47. The comment function in a spreadsheet application is used to:
l. Take and attach notes to cells
ll. Remind the user of complex formulas.
lll. Take and attach notes to cells
a)
I and Il only
b)
l and III only
c)
ll and III only
d)
I, II and IIl
47.
48. Which of the following formulas will display the present calendar month in a spreadsheet application?
a)
=TODAY
b)
=MONTHO
c)
=MONTH(NOW))
d)
=TODAY(MONTHO)
100 %
