Formulas & Functions
What symbol do all formulas in Excel start with?
"=" (equal)
What is the name of the row of tabs like Home, Insert, and Page Layout?
Ribbon
What tool lets you quickly copy formatting from one cell to another?
Format Painter
Which type of chart is best for showing parts of a whole?
Pie Chart
Which key do you press to save quickly?
Ctrl + S
This function adds up numbers in a range.
SUM()
What’s the name of a box where a row and column intersect?
a cell
Which button do you click to bold your text?
"B" icon.
What chart type is best to compare values across categories?
Bar Chart
What does Ctrl + Z do?
Undo
Which function calculates the average of a range of numbers?
Average ()
What do you call the bar that shows what you’re typing into a cell?
formula bar
Which tab contains most formatting options like font, color, and alignment?
Home Tab
How do you insert a chart in Excel?
Go to the Insert tab and choose a chart type.
What is the Fill Handle used for?
To copy cell content or continue a series
What does the PMT function calculate?
payment for a loan based on constant payments and a constant interest rate
What is the name of the grid of letters and numbers in Excel?
What does “wrap text” do to your cell content?
It fits the content in the same cell across multiple lines.
What feature shows the values under the chart in a table format?
Data Table
What’s the shortcut to create a new workbook?
Ctrl + N
What function adds numbers based on a condition?
SUMIF ()
How do you identify a specific cell (example: B4)?
cell reference
How can you apply a cell style with color and borders?
Use the Cell Styles button in the Home tab
How can you change the chart title?
Click on it and start typing or use the Chart Tools Format tab.
What does “Freeze Panes” do?
Keeps rows or columns visible while you scroll.