C2M3

Question 1

Average

Answer 1

A spreadsheet function that returns an average of the values from a selected range

Question 2

Borders

Answer 2

Lines that can be added around two or more cells on a spreadsheet

Question 3

Cell reference

Answer 3

A cell or a range of cells in a worksheet typically used in formulas and functions

Question 4

Count

Answer 4

A spreadsheet function that counts the number of cells in a range that meet a specific criteria

Question 5

Equation

Answer 5

A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)

Question 6

Fill handle

Answer 6

A box in the lower-right-hand corner of a selected spreadsheet cell that can be dragged through neighboring cells in order to continue an instruction

Question 7

Filtering

Answer 7

The process of showing only the data that meets a specified criteria while hiding the rest

Question 8

Header

Answer 8

The first row in a spreadsheet that labels the type of data in each column

Question 9

Math expression

Answer 9

A calculation that involves addition, subtraction, multiplication, or division (also called an equation)

Question 10

Math function

Answer 10

A function that is used as part of a mathematical formula

Question 11

MAX

Answer 11

A spreadsheet function that returns the largest numeric value from a range of cells

Question 12

MIN

Answer 12

A spreadsheet function that returns the smallest numeric value from a range of cells

Question 13

Open data

Answer 13

Data that is available to the public

Question 14

Order of operations

Answer 14

Using parentheses to group together spreadsheet values in order to clarify the order in which operations should be performed

Question 15

Operator

Answer 15

A symbol that names the operation or calculation to be performed

Question 16

Problem domain

Answer 16

The area of analysis that encompasses every activity affecting or affected by a problem

Question 17

Range

Answer 17

A collection of two or more cells in a spreadsheet

Question 18

Report

Answer 18

A static collection of data periodically given to stakeholders

Question 19

Return on investment (ROI)

Answer 19

A formula that uses the metrics of investment and profit to evaluate the success of an investment

Question 20

Revenue

Answer 20

The total amount of income generated by the sale of goods or services

Question 21

Scope of work (SOW)

Answer 21

An agreed-upon outline of the tasks to be performed during a project

Question 22

Sorting

Answer 22

The process of arranging data into a meaningful order to make it easier to understand, analyze, and visualize

Question 23

SUM

Answer 23

A spreadsheet function that adds the values of a selected range of cells