wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

3rd Quarter - Computer 5 Review

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

It is an equation that calculates data.

a)

Formula

b)

Function

c)

Condition

d)

Relation

2.

It is the symbol that represents the calculation to be applied on the operands.

a)

Operand

b)

Operator

c)

Equation

d)

Symbol

3.

The operator used for Multiplication in Excel.

a)

+

b)

-

c)

*

d)

/

4.

These are used to perform basic mathematical operations.

a)

Arithmetic Operators

b)

Concatenation

c)

Order of Precedence

d)

Cell Reference

5.

It is the process of combining two or more strings together.

a)

Operations

b)

Concatenation

c)

Reference

d)

Formulation

6.

It refers to the sequence in which the operations in the formula are evaluated.

a)

Order of Operations

b)

Cell Reference

c)

Order of Precedence

d)

Relationship

7.

The question mark (?) is used to separate the reference for the worksheet and the cell.

a)

True

b)

False

8.

These are the predefined formulas that perform calculations on a set of arguments.

a)

Formula

b)

Functions

c)

Conditions

d)

Relations

9.

It can be a value or a cell reference in function.

a)

Formula

b)

Relation

c)

Argument

d)

Operand

10.

it is a set of functions that performs the basic mathematical operations.

a)

AutoSum

b)

Financial

c)

Logical

d)

Date and Time

11.

An identifier assigned to a range.

a)

Cell name

b)

Column name

c)

row name

d)

Range Name

12.

It is a formula or expression that evaluates to either TRUE or FALSE value.

a)

Formula

b)

Functions

c)

Conditions

d)

Relations

13.

It returns the value if the condition evaluates to a TRUE value and another value if the conditions evaluates to a FALSE value.

a)

IF function

b)

SUMIF function

c)

AVERAGEIF function

d)

COUNTA function

14.

Double-click the sheet tab to quickly change the worksheet name.

a)

True

b)

False

15.

The Colon (:) symbol is an operator that is used to indicate range.

a)

True

b)

False

16.

The result of the expression 45<36 is false.

a)

True

b)

False

17.

It contains all formatting options for changing the appearance of the cell or range and the data it contains.

a)

Style

b)

Format font

c)

Font Style

d)

Format cells

18.

Workbook can only be copied within the workbook.

a)

True

b)

False

19.

It is used to add another worksheet.

a)

Insert

b)

Tab color

c)

Rename

d)

Delete

20.

It is the process of combining two or more cells together.

a)

Mixing

b)

Splitting

c)

Combining

d)

Merging

21.

 It is an editing technique that is used for

moving the selected data from one location to another

a)

Cut and Paste

b)

Paste

c)

Copy and Paste

d)

Delete

22.

The default format of number format.

a)

King

b)

Average

c)

Normal

d)

General

23.

The period from noon to midnignt.

a)

Morning

b)

NOON

c)

PM

d)

AM

24.

Also known as Military time.

a)

12-hour clock format

b)

16-hour clock format

c)

20-hour clock format

d)

24-hour clock format

25.

Which of the following is not a component of date?

a)

Month

b)

Year

c)

Hours

d)

Day

26.

The following is the components of time except for;

a)

Hour

b)

Day

c)

Minute

d)

Second

27.

By default, data is displayed vertically in the cell.

a)

True

b)

False

28.

All formulas in Excel are preceded by this symbol.

a)

+

b)

-

c)

*

d)

=

29.

The symbol used to indicate that a cell address is an absolute reference.

a)

$

b)

%

c)

&

d)

#

30.

5 + 5 ^ 3 / ( 8 – 3 )

a)

30

b)

40

c)

50

d)

60