Vocab
A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators such as +, -, *, and /
What is a formula
Function that enters in the current date
What is the NOW Function
Chaffee was founded in this year
What is 1905
Double clicking on a columns width changes the size to
What is best fit
What was the highest grossing movie of 2024
Who is Inside out 2
This number format contains a fixed dollar sign ($)
What is the Accounting Style
2nd and 3rd Arguments in the IF function
What is the TRUE, FALSE
The motto of the town is
What is The City with a Smile
A chart that fits inside of an idividual cell
What is a Sparkline Chart
What is the most streamed song of 2024
what is A bar song by shaboozy
In a formula, a cell address that refers to a specific cell and does not change when you copy the formula
What is an Absolute Reference
To add up the total of a group of cells
What is the SUM Function
How many square miles is the town of Chaffee
What is 1.8 mi2
G$8 is called a ____ Reference
What is Mixed
What fish is used to make calamari
What is squid
Special formatting that is applied if values meet specified criteria
What is conditional formatting
What is the Logical Test
The town was named after this officer in the Spanish-American War
Who is Adna Romanza Chaffee
These are basic cell references that adjust and change when copied or when using AutoFill
What is Relative Cell Reference
What was Beyoncé's debut single?
What is Crazy in Love
A function inside of another function is called
What is a Nested Function
A feature that reverses the trial-and-error process by allowing you to specify an output value and then working backward to find the input value needed to reach that goal
What is Goal Seek
What was the 2010 population
What is 2955
An Excel feature that looks for patterns in the data you enter and automatically fills or formats data in remaining cells based on those patterns
What is Flash Fill
What is the longest bone in the human body?
What is the femur