Ask Questions To Make Data Driven Decisions (Terms) Flashcards

1
Q

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

A

Fill handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Equation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Math expression

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Cell reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A chart created from the fields in a pivot table

A

Pivot chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A collection of two or more cells in a spreadsheet

A

Range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A computer programming language used to communicate with a database

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A data summarization tool used to sort, reorganize, group, count, total, or average data

A

Pivot table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A digital worksheet

A

Spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Return on investment (ROI)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A function that is used as part of a mathematical formula

A

Math function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A measurable goal set by a company and evaluated using metrics

A

Metric goal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

A place to keep data online, rather than a computer hard drive

A

Cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A process or set of rules followed for a specific task

A

Algorithm

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A question that has significance to the problem to be solved

A

Relevant question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A question that is simple, significant, and focused on a single topic or a few closely related ideas

A

Specific question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A question that makes assumptions or is difficult to answer honestly

A

Unfair question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A question that specifies a timeframe to be studied

A

Time-bound question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

A question that steers people toward a certain response

A

Leading question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A question whose answers can be quantified and assessed

A

Measurable question

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

A question whose answers lead to change

A

Action-oriented question

22
Q

A single, quantifiable type of data that is used for measurement

A

Metric

23
Q

A specific and objective measure, such as a number, quantity, or range

A

Quantitative data

24
Q

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

A

SUM

25
Q

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

A

COUNT

26
Q

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

A

AVERAGE

27
Q

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

A

MAX

28
Q

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

A

MIN

29
Q

A static collection of data periodically given to stakeholders

A

Report

30
Q

A subjective and explanatory measure of a quality or characteristic

A

Qualitative data

31
Q

A symbol that names the operation or calculation to be performed

A

Operator

32
Q

A tool for determining a question’s effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound

A

SMART methodology

33
Q

A tool that monitors live, incoming data

A

Dashboard

34
Q

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

A

Scope of work (SOW)

35
Q

Data that is available to the public

A

Open data

36
Q

Exploring different data sources to find out what they have in common

A

Data-inspired decision-making

37
Q

Large, complex datasets typically involving long periods of time, which enable data analysts to address far-reaching business problems

A

Big data

38
Q

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

A

Borders

39
Q

Refer to Structured Query Language

A

SQL

40
Q

Restating a problem or challenge, then redirecting it toward a potential resolution

A

Reframing

41
Q

Small, specific data points typically involving a short period of time, which are useful for making day-to-day decisions

A

Small data

42
Q

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

A

Problem domain

43
Q

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

A

Header

44
Q

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

A

Sorting

45
Q

The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying options

A

Structured thinking

46
Q

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

A

Filtering

47
Q

The rate at which employees voluntarily leave a company

A

Turnover rate

48
Q

The sequence of stages that data experiences, which include plan, capture, manage, analyze, archive, and destroy

A

Data life cycle

49
Q

The six phases of ask, prepare, process, analyze, share, and act whose purpose is to gain insights that drive informed decision-making

A

Data analysis process

50
Q

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

A

Revenue

51
Q

The various problems that data analysts encounter, including categorizing things, discovering connections, finding patterns, identifying themes, making predictions, and spotting something unusual

A

Problem types

52
Q

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

A

Order of operations