Basic Spreadsheet Vocabulary for Cyber Foundations

A spreadsheet is a:

• type of document used to organize and analyze data in rows and columns

• software for creating presentations

• tool for editing images

• programming language

A Cell in a spreadsheet is:

• a single data point or element in a spreadsheet

• a collection of multiple spreadsheets

• a type of chart used in data analysis

• a function to sort data

A Row in a spreadsheet is:

• A vertical line of cells

• A horizontal line of cells

• A single cell

• A group of worksheets

A Column in a spreadsheet is:

• A vertical set of cells

• A horizontal set of cells

• A single cell

• A type of chart

A Cell Address (Cell Reference) is:

• a unique identifier for a cell in a spreadsheet, consisting of the column letter and row number.

• a type of data format used in spreadsheets.

• a function used to calculate values in a spreadsheet.

• a tool for creating charts in a spreadsheet.

A Formula in a spreadsheet is:

• A set of instructions for performing calculations

• A type of chart used for data visualization

• A method for sorting data alphabetically

• A tool for formatting text

A Function in a spreadsheet is:

• A tool to format cells

• A formula to perform calculations

• A way to sort data

• A method to insert images

What is a SUM Function?

• A function that multiplies numbers

• A function that divides numbers

• A function that adds numbers

• A function that subtracts numbers

What is an AVERAGE Function?

• A mathematical function that calculates the sum of numbers.

• A function that returns the largest number in a set.

• A function that calculates the arithmetic mean of a set of numbers.

• A function that returns the smallest number in a set.

What is a MIN Function?

• A function that returns the maximum value in a set of values

• A function that returns the minimum value in a set of values

• A function that returns the average value in a set of values

• A function that returns the sum of all values in a set