spreadsheet features and terminologies

Question 1

Workbook

Answer 1

The entire spreadsheet file that can contain multiple worksheets.

Question 2

Worksheet

Answer 2

A single page or sheet in a workbook where data is entered and organized in rows and columns.

Question 3

Column

Answer 3

A vertical set of cells labeled with letters (A, B, C, etc.).

Question 4

Row

Answer 4

A horizontal set of cells labeled with numbers (1, 2, 3, etc.).

Question 5

Cell

Answer 5

The intersection of a column and a row; a single data box (e.g., B4).

Question 6

Cell Address

Answer 6

The specific location of a cell, identified by its column letter and row number (e.g., A1, C5).

Question 7

Range

Answer 7

A group of selected cells (e.g., A1:A5 or B2:D4).

Question 8

Label

Answer 8

Text entered in a cell, usually used to describe data (e.g., “Name”, “Total”).

Question 9

Value

Answer 9

Numeric data or actual content entered into a cell that can be used in calculations.

Question 10

Formula

Answer 10

An expression used to calculate values (e.g., =A1+B1).

Question 11

Function

Answer 11

A built-in formula to perform specific tasks (e.g., =SUM(A1:A5), =AVERAGE(B1:B5)).