Worksheets3rd PT - Computer
Total questions: 43
Worksheet time: 22mins
Name
Class
Date
1.
Which of the following is the argument that pertains to the sum of my allowance for Week 1?
a)
A1:A7
b)
=SUM(B5:B7)
c)
B1:B7
d)
B4:B7
2.
Which of the following formulas will compute for my monthly allowance for Meals alone?
a)
=SUM(B4:E4)
b)
=SUM(B4:E7)
c)
=SUM(B4:B7)
d)
all of the above
3.
Which of the following formulas will compute for the sum of my Week 4 allowance?
a)
=(E4+E5+E6+E7)
b)
=SUM(E4:E7)
c)
=SUM(E4,E5,E6,E7)
d)
all of the above
4.
Which of the following formulas will compute the sum of my Week 1 and Week 2 allowance?
a)
=SUM(B4:B7,C4:C7)
b)
=SUM(B4:C7)
c)
=SUM(B4:B7)+SUM(C4:C7)
d)
all of the above
5.
Which of the following formulas will compute for my monthly allowance for Requirements alone?
a)
=SUM(B7:E7)
b)
=SUM(B4:E7)
c)
=SUM(E4:E7)
d)
All of the above
6.
In =SUM(A5:A12), what is the function name?
a)
=
b)
SUM
c)
A5:A12
7.
In =SUM(A5:A12), what is the argument?
a)
=
b)
SUM
c)
A5:A12
8.
Formatting tools in MS Excel are located on the _________ group box on the Home Tab.
a)
Font and Alignment
b)
Clipboard
c)
Number
d)
Style
e)
Cell
9.
If you want to make the size of the text bigger or smaller.
a)
change the font size
b)
change the font
c)
change font color
d)
change the fill color
10.
If you want to change the text from Times New Roman to Comic Sans.
a)
change the font size
b)
change the font
c)
change font color
d)
change the fill color
11.
If you want to make the cell content to be green.
a)
change the font size
b)
change the font
c)
change font color
d)
change the fill color
12.
If you want to make the group cells color yellow.
a)
change the font size
b)
change the font
c)
change font color
d)
change the fill color
13.
Ctrl + B
a)
Bold
b)
Italic
c)
Underline
14.
Ctrl + I
a)
Bold
b)
Italic
c)
Underline
15.
Ctrl + U
a)
Bold
b)
Italic
c)
Underline
16.
Top align, Middle align, and Bottom align
a)
Vertical Alignment Commands
b)
Horizontal Alignment Commands
17.
Align left, Center, Align Right
a)
Vertical Alignment Commands
b)
Horizontal Alignment Commands
18.
This command allows you to align the content to the top of the cell.
a)
Top Align
b)
Middle Align
c)
Bottom Align
d)
Align Left
e)
Center
19.
This command allows you to align the content to the center between the top and bottom of the cell.
a)
Middle Align
b)
Bottom Align
c)
Align Left
d)
Center
e)
Align Right
20.
This command allows you to align the content to the bottom of the cell.
a)
Bottom Align
b)
Middle Align
c)
Align Left
d)
Center
e)
Align Right
21.
This command allows you to align the content to the left side of the cell.
a)
Align Left
b)
Middle Align
c)
Bottom Align
d)
Center
e)
Align Right
22.
This command allows you to align the content to the center between the left and right side of the cell.
a)
Center
b)
Middle Align
c)
Bottom Align
d)
Align Left
e)
Align Right
23.
This command allows you to align the content to the right side of the cell.
a)
Align Right
b)
Middle Align
c)
Bottom Align
d)
Align Left
e)
Center
24.
These are used for the calculations of numerical data.
a)
formulas
b)
equal sign
c)
operands
25.
Formulas must begin with _________.
a)
formulas
b)
equal sign
c)
operands
26.
These are the values involved in the computation.
a)
formulas
b)
equal sign
c)
operands
27.
What is the sign for addition?
a)
+
b)
-
c)
*
d)
/
e)
%
28.
What is the sign for subtraction?
a)
-
b)
+
c)
*
d)
/
e)
%
29.
What is the sign for multiplication?
a)
*
b)
+
c)
-
d)
/
e)
%
30.
What is the sign for division?
a)
/
b)
+
c)
-
d)
*
e)
%
31.
What is the sign for percentage?
a)
%
b)
+
c)
-
d)
*
e)
/
32.
What is the sign for exponentiation?
a)
^
b)
+
c)
-
d)
*
e)
/
33.
What is the sign for grave accent?
a)
`
b)
+
c)
-
d)
*
e)
/
34.
It is the predefined formula which can be called to perform computations.
a)
Function
b)
Syntax
c)
Function name
d)
Argument
e)
Function Library
35.
The specific way on how functions should be written
a)
Function
b)
Syntax
c)
Function name
d)
Argument
e)
Function Library
36.
The function that is being called.
a)
Function
b)
Syntax
c)
Function name
d)
Argument
e)
Function Library
37.
The individual cells or range of cells which contain the values needed to be computed.
a)
Function
b)
Syntax
c)
Function name
d)
Argument
e)
Function Library
38.
It contains all the functions that are available in MS Excel.
a)
Function
b)
Syntax
c)
Function name
d)
Argument
e)
Function Library
39.
The correct order of operations.
a)
Parentheses - Exponents - Multiplication & Division - Addition & Subtraction
b)
Exponents - Parentheses - Multiplication & Division - Addition & Subtraction
c)
Addition & Subtraction - Multiplication & Division - Parentheses - Exponents
d)
Parentheses - Multiplication & Division - Exponents - Addition & Subtraction
40.
An alternative to manually add values.
a)
=SUM(Cell Range)
b)
=AVERAGE(Cell Range)
c)
=MIN(Cell Range)
d)
=MAX(Cell Range)
41.
Automatically compute for the average of a specified cell range
a)
=SUM(Cell Range)
b)
=AVERAGE(Cell Range)
c)
=MIN(Cell Range)
d)
=MAX(Cell Range)
42.
To know the smallest value in a cell range.
a)
=SUM(Cell Range)
b)
=AVERAGE(Cell Range)
c)
=MIN(Cell Range)
d)
=MAX(Cell Range)
43.
To know the largest value in a cell range.
a)
=SUM(Cell Range)
b)
=AVERAGE(Cell Range)
c)
=MIN(Cell Range)
d)
=MAX(Cell Range)
100 %
