1 Computer App used for organization, analysis, and storage of data; table of values arranged in rows and columns
Spreadsheet
2is a collection of information organized in a way where a computer can quickly access the data it needs.
Database
3A collection of one or more worksheets in one file.
Excel Workbook
4 data arranged in a set of rows and columns
Table
5 numbered horizontal groups of cells
Row
6numbered vertical groups of cells
Column
7 a cell where a single piece of data, such as text, a number, or a formula is entered
Cell
8A column letter and row number that corresponds to the location of a cell in a spreadsheet
Cell address or reference
9a cell that’s referenced regardless of the formula’s position
Absolute reference
10a cell that’s referenced while being dependent on the current cell’s position
Relative reference
11 the equations that you can use
Formula
12 It’s a built-in formula in Excel
Function
13a chart that’s similar to bar charts; vertical bars are used to compare separate items
Column chart
14a chart that’s used to show the parts of a whole in percentage form
Pie chart
15a chart that’s used to show fluctuations in continuous trends over time
Line chart
16a chart comprised of several column series stacked vertically with the length being dependent on the value of each data point
Stacked Column
17a formula that returns one value if the condition is True and a different value if the condition is False
Conditional formulas
18the process of isolating a smaller part of one’s entire data set and using it for viewing and analysis
Filtering
19allows you to summarize and analyze a lot of data in tables and lists by dragging and dropping columns to different rows, columns, or summary positions; changes how the data looks, not what it is
Pivot table
20A function that looks at a value, compares it to a given table, and returns the corresponding value from the table
V-Lookup
21What is the difference between a Spreadsheet and a database?
Spreadsheets manage and analyze data while databases store and organize data quickly
22Example of when a spreadsheet is used:
When the frequency or popularity of a product is analyzed for future use
23Example of when a database is used:
When large amounts of data regarding products, their cost, their customers, etc. needs to store and easily found
24What is an example of when a pie chart is preferred?
to show survey results
25What is an example of when a bar chart is preferred?
to compare separate items like the popularity of two or more products
26What is an example of when a line chart is preferred?
to show costs over a period of time
27What is the difference between a Pivot Table and a VLOOKUP table?
Pivot tables change how a set of table looks while a VLOOKUP table translates one piece of data into another based on a separate table
28 Give an example of when a Pivot table is used:
When you want to find everyone who got a B or above in a table full of grades
29 Give an example of when a VLOOKUP table is used:
When you want to translate numerical grades into letter grades through a table
30returns the amount of cells that have numerical values in a given range
=COUNT
31returns the amount of cells that have some value (text, number, character, etc.) in in a given range
=COUNTA
32returns the amount of cells that meet the condition(s) given
=COUNTIF(S)
33checks a condition and returns a value if it’s false and another value if it’s true
=IF
34checks a pair of conditions and returns a value if it’s false and another value if it’s true (both conditions need to be true)
=IF(AND(
35checks a pair of conditions and returns a value if it’s false and another value if it’s true (only one condition needs to be true)
=IF(OR(
36checks if there's an error and returns a value if true
=IFERROR
37allows you to determine how much your payments are, granted that you know the interest rate, the how long you have to pay them back, etc
=PMT
38a list of color coded titles or labels that can be placed anywhere on the excel sheet
legend
39Another word for legend
key
40automated set of operations, saving keystrokes
macro
41A pivot tables changes how data _________ not what it is
looks