TLE 6_L4 _Analyzing Information Using ICT

What is a computer program used for accounting and recording data using rows and columns into which information can be entered?

• Electronic Spreadsheet

• PowerPoint

• Microsoft Word

• Photoshop

What is an equation that calculates certain values from a range of cells in Microsoft Excel?

• Division

• Multiplication

• Addition

• Subtraction

What always starts with an equal sign in a formula in Microsoft Excel?

• A letter

• An equal sign

• A number

• A symbol

What is a feature in Microsoft Excel that can be used to enter or copy a formula into cells or charts?

• Status Bar

• Menu Bar

• Toolbar

• Formula Bar

What is a function in Microsoft Excel that is ready-made or predefined for computation of mathematical data?

• Formula

• Cell Reference

• Name Box

• Function

What is the intersection between a row and column in a spreadsheet called?

• Cell

• Block

• Intersection Point

• Grid

What is the cell address composed of that identifies the location of a cell?

• Letter and number

• Symbol and number

• Number and letter

• Letter and symbol

Where is the Name Box located in Microsoft Excel?

• To the right of the formula bar

• Below the formula bar

• Above the formula bar

• To the left of the formula bar

What does the MIN function in Microsoft Excel display?

• Maximum value

• Sum of values

• Minimum value

• Average value

What is a function in Microsoft Excel that displays the minimum or smallest value in a range of cells?

• SUM function

• AVERAGE function

• MAX function

• MIN function