Data Vocabulary
What is a digital table used to organize and analyze data?
A spreadsheet
Which menu do you click to create a chart?
Insert → Chart
Which symbol must every formula begin with?
= (equal)
If a graph moves upward from left to right, what does that usually mean?
The values are increasing.
In which country was the QR code invented?
Japan
What is a collection of related information organized into rows and columns?
A dataset
What is a single box where a row and column meet?
A cell
Which function ranks numbers from highest to lowest?
RANK()
If a graph stays almost flat, what does that mean?
Very little or no change.
What video game company began in 1889 by making playing cards?
Nintendo
What does it mean to look at information to find patterns, trends, or conclusions?
Analyze data
What do you call a group of selected cells?
Which function counts how many cells meet a condition?
COUNTIF()
If sales rise quickly for three months and then suddenly drop, what should an analyst investigate?
The reason for the sudden decrease.
What real insect was famously found inside an early computer and recorded as an actual “computer bug”?
A moth
What is something that you can name and be used to store information in a program?
What is the difference between a row and a column?
Rows run horizontally.
Columns run vertically.
Which function makes a decision based on a condition?
IF()
Why do businesses look for trends in their sales data?
To make better business decisions and predictions.
In what decade was the first handheld mobile phone call made?
1970s
What set of instructions might an app use to recommend videos based on what you previously watched?
An algorithm
What is the $ symbol used for when writing functions?
It makes it so that the data does NOT change when copied and pasted.
Which function searches horizontally through a table?
HLOOKUP()
Why might a business compare this year's sales with last year's?
To see if sales have improved or decreased.
Which photography company created the first digital camera prototype?
Kodak