Terms
A chart that remains in the same worksheet
What is an embedded chart?
This function combines text.
What is CONCAT?
To add outlining or subtotals, you navigate to this tab in the ribbon.
What is the data tab?
This is how you change the worksheet tab color and name.
Alex's height
What is 6'6?
A chart that moves to another worksheet.
What is a chart sheet?
The two functions that can calculate the days between two dates.
What is DAYS and DATEDIF?
To add conditional formatting to your workbook, you navigate to this tab in the ribbon.
What is the home tab?
The new mayor in New York.
Who is Zohran Mamdani?
What is a macro?
The function that corrects text to have correct capitalization.
What is PROPER?
To change a chart element (legend, axis title, etc.), you navigate to this tab on the ribbon.
What is the Chart Design tab?
How to select non-adjacent cells.
Hold down command.
The first five presidents.
Who are George Washington, John Adams, Thomas Jefferson, James Madison, and James Monroe.
In a formula, what are the addition, subtraction, multiplication, and division signs called?
What is an operator.
The function to find the value of the loan at the end of five years.
What is future value?
What is the view tab?
The keyboard shortcut for switching to absolute reference.
What is Command + T?
List in the correct order the past five presidents.
What is Joe Biden, Donald Trump Jr, Barack Obama, George W. Bush, and Bill Clinton
Combining multiple functions within a single function.
What is nesting?
The syntax for vlookup.
What is VLOOKUP(lookup value, table array, column index number, range lookup (TRUE or FALSE)
The four fields on a Pivot Table.
What is filters, columns, rows, and values?
How to create a pivot table.
What is highlight the necessary text, navigate to the insert tab, and click the Pivot Table button.
In what state was the first shot fired for the Civil War.
What is North Carolina?