Q4 ICT4 Lesson 1&2 Spreadsheet SJI

What is the function of the formula bar in a spreadsheet?

• Displays the active worksheet name

• Shows the content of active cells and formulas

• Contains the list of all worksheets

• Highlights selected rows and columns

What is the basic unit of a spreadsheet where data is entered and stored?

• Row

• Column

• Cell

• Formula

What is a cell range in a spreadsheet?

• A single cell reference

• A collection or block of selected cells

• A vertical set of cells

• The row number of a cell

How is a cell address represented in a spreadsheet?

• By a row number only

• By a column letter only

• By a combination of a column letter and a row number

• By the worksheet name only

What do row headings represent in a spreadsheet?

• The names of the worksheets

• Numbered labels on the left side of the grid

• Alphabetical labels at the top of the grid

• The formulas used in each row

What do column headings contain?

• Numbered labels on the left side

• A vertical line of cells identified by letters

• The sum of all values in a column

• The total number of rows in a spreadsheet

What does the name box display in a spreadsheet?

• The formula applied to a cell

• The content of an active cell

• The location of the selected cell

• The list of worksheets available

What is the function of the worksheet tab in a spreadsheet?

• It allows users to move from one worksheet to another

• It stores all the data in the spreadsheet

• It performs calculations in a cell

• It highlights selected columns

Where is the cell address located in a spreadsheet?

• Bottom right corner of the worksheet

• Top left corner of the worksheet

• Center of the worksheet

• In the formula bar

What is an example of spreadsheet software?

• Microsoft Word

• Adobe Photoshop

• Microsoft Excel

• Windows Media Player