Basics
What is the default file extension for an Excel workbook?
xlsx
(Double Jeopardy):
What is the formula to multiply the values in cells C1 and C2?
=C1 * C2
What function calculates the average of a range of cells?
AVERAGE()
How do you change the font size of a cell's content?
Use the Font Size dropdown in the Home tab
How do you sort data in a column from A to Z?
Click "Sort A to Z" in the Data tab
Double Jeopardy):
How do you add a new worksheet to a workbook?
Click the "+" button next to the sheet tabs
How do you create a formula to subtract cell B1 from cell A1?
=A1 - B1
How do you find the maximum value in a range of cells?
MAX()
(Double Jeopardy):
How do you apply a border to a cell or range of cells?
Use the Borders button in the Home tab
What tool allows you to filter data in a worksheet?
Filter
What is the intersection of a row and a column called?
Cell
What is the formula to add the values in cells A1 and A2?
=A1 + A2
What function counts the number of cells that contain numbers?
COUNT()
What is the feature that allows you to apply a color to a cell?
Fill Color
How do you create a chart from a selection of data?
Select the data and click "Insert" and then "Chart"
How do you save an Excel workbook for the first time?
Click "File" and then "Save As"
How do you reference cell A1 in a formula?
A1
How do you sum a range of cells?
SUM()
How do you merge cells in Excel?
Select the cells and click "Merge & Center"
What feature allows you to automatically fill cells with data?
AutoFill
What is the term for a single box in an Excel worksheet?
Cell
What symbol is used to start a formula in Excel?
=
(Double Jeopardy):
What function returns the current date and time?
NOW()
What is the shortcut for bolding text in a cell?
Ctrl + B
Final Jeopardy (Related to Both Word and Excel)
What feature allows you to embed an Excel chart or table directly into a Word document, ensuring that updates in Excel are reflected in Word?
Object Linking and Embedding (OLE)