Spreadsheets

Basics

100

An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information 

What is a spreadsheet? 

200

A file that contains one or more spreadsheets

What is a workbook? 

300

An individual location in a spreadsheet- the intersection of a column and row 

What is a cell?

400

How we identity a cell, by the column letter and row number 

What is a cell reference, or cell address? 

500

A cell that is ready to receive information

What is an active cell? 

Formatting

100

Used to add identifying information to a spreadsheet, including page number, title of company, date, etc. 

What are headers and footers? 

200

These are the three main types of justification

What are left, right, and center? 

300

This is the default justification for labels

What is left? 

400

This is the default justification for values

What is right? 

500

This feature is used to align multi-line text within a cell

What is wrap-text?

Formulas & Operations

100

This is the symbol that instructs the spreadsheet software to perform a calculation

What is an equal sign?

200

This classification is used for numbers that may be used in calculations

What are values?

300

These are the four operators used in spreadsheet calculations

What is addition, subtraction, division, and multiplication? 

400

Calculations are performed according to what?

What is the order of operations, or PEMDAS?

500

This is used to create a continuation of data 

What is a fill series? 

Functions

100

This is a shortcut for a formula

What is a function? 

200

This function adds a range of cells 

What is SUM?

300

This symbol is placed between cell addresses to identify a range of cells 

What is a colon?

400

These are used to clarify the order of operations when there are multiple calculations in a numerator or denominator of a formula

What are parentheses? 

500

Write the following formula- Multiply A6 by the sum of the range of cells B1:B10, then divide by C6. 

What is =(A6*SUM(B1:B10))/C6 

Bonus

100

This symbol is keyed before a number to indicate that it is a label, not a value 

What is an apostrophe? 

200

This formatting feature is used to combine two or more cells

What is merge? 

300

When ##### appears in a cell, it indicates this error

What is too small of a column width? 

400

Write the following function- Add A1 to the highest value in the cell range B1:B10. 

=A1+MAX(B1:B10)

500

Write the following formula- Subtract B2 from the minimum value of the cell range A2:A12, then divide by C2 

What is =(MIN(A2:A12)-B2)/C2