NEW
Font size
Worksheets3rd Quarter - Computer 5 Review
Total questions: 30
Worksheet time: 15mins
It is an equation that calculates data.
Formula
Function
Condition
Relation
It is the symbol that represents the calculation to be applied on the operands.
Operand
Operator
Equation
Symbol
The operator used for Multiplication in Excel.
+
-
*
/
These are used to perform basic mathematical operations.
Arithmetic Operators
Concatenation
Order of Precedence
Cell Reference
It is the process of combining two or more strings together.
Operations
Concatenation
Reference
Formulation
It refers to the sequence in which the operations in the formula are evaluated.
Order of Operations
Cell Reference
Order of Precedence
Relationship
The question mark (?) is used to separate the reference for the worksheet and the cell.
True
False
These are the predefined formulas that perform calculations on a set of arguments.
Formula
Functions
Conditions
Relations
It can be a value or a cell reference in function.
Formula
Relation
Argument
Operand
it is a set of functions that performs the basic mathematical operations.
AutoSum
Financial
Logical
Date and Time
An identifier assigned to a range.
Cell name
Column name
row name
Range Name
It is a formula or expression that evaluates to either TRUE or FALSE value.
Formula
Functions
Conditions
Relations
It returns the value if the condition evaluates to a TRUE value and another value if the conditions evaluates to a FALSE value.
IF function
SUMIF function
AVERAGEIF function
COUNTA function
Double-click the sheet tab to quickly change the worksheet name.
True
False
The Colon (:) symbol is an operator that is used to indicate range.
True
False
The result of the expression 45<36 is false.
True
False
It contains all formatting options for changing the appearance of the cell or range and the data it contains.
Style
Format font
Font Style
Format cells
Workbook can only be copied within the workbook.
True
False
It is used to add another worksheet.
Insert
Tab color
Rename
Delete
It is the process of combining two or more cells together.
Mixing
Splitting
Combining
Merging
It is an editing technique that is used for
moving the selected data from one location to another
Cut and Paste
Paste
Copy and Paste
Delete
The default format of number format.
King
Average
Normal
General
The period from noon to midnignt.
Morning
NOON
PM
AM
Also known as Military time.
12-hour clock format
16-hour clock format
20-hour clock format
24-hour clock format
Which of the following is not a component of date?
Month
Year
Hours
Day
The following is the components of time except for;
Hour
Day
Minute
Second
By default, data is displayed vertically in the cell.
True
False
All formulas in Excel are preceded by this symbol.
+
-
*
=
The symbol used to indicate that a cell address is an absolute reference.
$
%
&
#
5 + 5 ^ 3 / ( 8 – 3 )
30
40
50
60
