2023-2024-Term1-ELECTIVE-ICT-SPREADSHEETSHS3-Activity-3

What is a wordsheet?

• A type of bedsheet used for writing on

• A form of poetry

• A wordsheet is a misspelling of the word 'worksheet', which refers to a paper or electronic document used for organizing and analyzing information.

• A type of spreadsheet used for word processing

How do you identify rows and columns in a workbook?

• By using the combination of letters and numbers to reference specific cells in the workbook.

• By using different colors for each row and column

• By using only numbers to reference specific cells in the workbook

• By counting the number of cells in each row and column

What is the purpose of labeling cells and values in a wordsheet?

• The purpose of labeling cells and values in a worksheet is to organize and categorize data, making it easier to understand and analyze.

• To confuse the user

• To waste time

• To make the worksheet look pretty

How are functions used in cells in a wordsheet?

• Functions are used in cells in a spreadsheet to cook food

• Functions are used in cells in a spreadsheet to play music

• Functions are used in cells in a spreadsheet to send emails

• Functions are used in cells in a spreadsheet to perform calculations, manipulate data, and automate tasks.

Define the term 'Workbook'.

• A workbook is a file that contains one or more worksheets where data is entered and analyzed, commonly used in spreadsheet software like Microsoft Excel.

• A workbook is a type of cooking utensil

• A workbook is a type of musical composition

• A workbook is a type of novel

What is the definition of a row in a wordsheet?

• A row in a wordsheet is a type of font used in a table or spreadsheet.

• A row in a wordsheet is a vertical line of cells or data in a table or spreadsheet.

• A row in a wordsheet is a horizontal line of cells or data in a table or spreadsheet.

• A row in a wordsheet is a function used to calculate data in a table or spreadsheet.

Explain the concept of a column in a wordsheet.

• A column in a spreadsheet is identified by a number at the top of the sheet

• A column in a spreadsheet is a horizontal arrangement of data

• A column in a spreadsheet is used to organize and store unrelated information

• A column in a spreadsheet is a vertical arrangement of data, where each column is identified by a letter at the top of the sheet (e.g., A, B, C, etc.). It is used to organize and store related information in a structured manner.

What is a cell reference in a wordsheet?

• A cell reference in a spreadsheet is a combination of the column letter and row number that identifies a specific cell, such as A1 or B2.

• A cell reference is the font style used in the spreadsheet

• A cell reference is the name of the person who created the spreadsheet

• A cell reference is the date and time when the spreadsheet was last edited

What is the difference between a value and a formula in a wordsheet?

• A value is always negative, while a formula is always positive

• A value is a letter, while a formula is a number

• A value is a static piece of data, while a formula is a dynamic expression that calculates a value based on other values or functions.

• A value is used for addition, while a formula is used for subtraction