WorksheetsQuiz on Excel IX B
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Which of the following is a spreadsheet software developed by Microsoft?
a)
MS Word
b)
MS PowerPoint
c)
MS Excel
d)
MS Outlook
2.
What is a cell in MS Excel?
a)
A row in a spreadsheet
b)
A column in a spreadsheet
c)
A single data entry point within a spreadsheet
d)
A formula used for calculations
3.
Which function in MS Excel is used to add up a range of cells?
a)
COUNT
b)
AVERAGE
c)
SUM
d)
MAX
4.
Which keyboard shortcut can be used to copy selected cells in MS Excel?
a)
Ctrl+C
b)
Ctrl+V
c)
Ctrl+X
d)
Ctrl+Z
5.
Which function in MS Excel can be used to find the highest value in a range of cells?
a)
COUNT
b)
AVERAGE
c)
SUM
d)
MAX
6.
Which function in MS Excel is used to round a number to the nearest whole number?
a)
ROUNDUP
b)
ROUNDDOWN
c)
ROUND
d)
INT
7.
Which of the following button should you click to adjust the height and width of the cells of a worksheet?
a)
Insert
b)
Format
c)
Delete
d)
Cell Styles
8.
Which sign is used to keep the cell referencing in MS Excel absolute?
a)
*
b)
&
c)
$
d)
%
9.
Which symbol is used to indicate a formula in Excel?
a)
+
b)
-
c)
=
d)
~
10.
Which of the following MS Excel Function can you use to multiply the numeric values of two cells?
a)
SUM()
b)
RANK()
c)
PRODUCT()
d)
MULTIPLY()
11.
An example of an absolute cell referencing is
a)
A3
b)
B$4
c)
$C5
d)
$A$2
12.
What is the keyboard shortcut key used to convert a cell referencing from relative to absolute?
a)
F1
b)
F2
c)
F3
d)
F4
13.
What does the COUNT function in Excel do?
a)
Counts the number of cells that contain numbers within a specified range
b)
Calculates the average of a range of cells
c)
Returns the largest value from a range of cells
d)
Calculates the total sum of a range of cells
14.
What does the autofill handle look like in Excel?
a)
Plus sign (+)
b)
Minus sign (-)
c)
Arrowhead
d)
Dollar sign ($)
15.
All of the following are the arguments of the rank function EXCEPT
a)
number
b)
ref
c)
order
d)
position
100 %
