Spreadsheet Terminologies and Features Quiz

Define Workbook

• A workbook is a spreadsheet file, it contains at least one worksheet, and may contain several worksheets. 

• A workbook is a digital document that only contains text.
• A workbook is a single sheet of paper used for writing notes.
• A workbook is a type of calculator used for financial analysis.

Define Worksheet

(Spreadsheet)

• A worksheet is a document used for financial accounting.
• A worksheet is a type of spreadsheet software.
• A worksheet is a single page in a spreadsheet file.

• A worksheet is a form of digital presentation software.

What is a Cell Address?

• A type of data format for images.
• A cell address identifies a single cell in a worksheet. The letter indicates the column and the number indicates the row. 

• A formula used to calculate values in a spreadsheet.
• A method for sorting data in a table.

What is a range?

• The range is the highest value in a dataset.
• The range is the average of all values in a dataset.
• A range identifies a rectangular block of cells on a worksheet. 

• The range is the total number of values in a dataset.

What is a label in spreadsheet?

• A label is a formula used to calculate values.
• A label is a type of chart in a spreadsheet.
• A label is a hidden feature that stores data.
• A label is text entered into a cell that explains the content of other cells. 

What is a value in spreadsheet?

• A value is only a number in a spreadsheet.
• A value in a spreadsheet is any data entered into a cell, such as numbers, text, or formulas.
• A value refers to the color of a cell.
• A value is the title of the spreadsheet.

What is the cell address of the highlighted cell?

• A1
• C5
• D2
• C4

What is the range of cells from B2 to D4?

• B1:D3
• A2:C4
• B2:D5
• B2:D4

What is the value in cell C3?

• The value is 72.

• The value is 100.
• The value is a formula.
• The value is empty.

Write the formula you would use to find the sum of the values in cells A1 to A10.

• =SUM(A1:A10)
• =SUMMATION(A1:A10)
• =TOTAL(A1:A10)
• =ADD(A1:A10)