Glossary Week 3

Question 1

Cell reference

Answer 1

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

Question 2

Equation

Answer 2

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

Question 3

Fill handle

Answer 3

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 4

Filtering

Answer 4

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

Question 5

Header

Answer 5

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

Question 6

Math function

Answer 6

A function that is used as part of a mathematical formula

Question 7

Open data

Answer 7

Data that is available to the public

Question 8

Operator

Answer 8

A symbol that names the operation or calculation to be performed

Question 9

Problem domain

Answer 9

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

Question 10

Scope of work (SOW)

Answer 10

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

Question 11

Sorting

Answer 11

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