Grade 9 - ICT : MS Excel : Reinforcement

Microsoft Excel is a

• Word Processing Program

• Presentation Software

• Spreadsheet Application

• All of the Above

A sequence that contains values, cell references and mathematical operators.

• Equation

• Formula

• Function

• Operation

A method of adding cell reference to a formula by clicking the cell.

• Pointing

• Clicking

• Taping

• Touching

A predefined formula that performs specific calculations.

• Operation

• Calculate

• Formula

• Function

The process of joining together a series of text strings.

• Concatenation

• Text Addition

• Interconnection

• String Joining

You are making a table in MS Excel. IF you want to format the cells according to specific condition which features of MS Excel will help you?

• Block Formatting

• Editing

• Cell Formatting

• Conditional Formatting

You are going to create a formula in a cell. Which symbol you type first in a cell to begin a formula.

• Equal To

• Dollar

• Ampersand

• Underscore

Excel calculates the formula from left to right, according to a specific order for each mathematical operator in the formula. What is this order is called?

• Order of operation

• Order of process

• Order of action

• Order of evaluation

In what order Excel evaluates a formula which contains mathematical operators with the same precedence?

• Higher to Lower

• Left to Right

• Lower to Higher

• Right to Left

Choose the correct definition of a cell.

• Vertical arrangement of cells.

• Horizontal arrangement of cells.

• Intersection of a row and a column.

• All of the above.