BASIC Formulas
What symbol must every formula in Excel begin with?
= (equal)
What function gives you the highest value in a range?
MAX()
What does "Wrap Text" do in Excel?
it makes all text visible in a cell by showing it on multiple lines.
What shortcut saves your Excel workbook?
Ctrl + S
What is a cell in Excel?
is the intersection of a row and a column
Write a formula to multiply cell A1 by B1.
=A1*B1
What function would you use to find the smallest value?
MIN()
How do you bold text in Excel?
click the Bold button or press Ctrl + B
What shortcut creates a new workbook?
Ctrl + N
What do you call a collection of related data in rows and columns?
a Table
How do you write a formula to subtract B1 from A1?
=A1–B1
What function calculates the average of a list of numbers?
AVERAGE()
How do you apply Currency formatting to a number?
click the "$" sign or go to Number Format > Currency
How do you select an entire column?
Click the column letter or press Ctrl + Space
What is a formula?
is an equation that performs a calculation
What function adds the range A1 through A10
=SUM(A1:A10)
Write the formula to find the average of A1 through A5.
=AVERAGE(A1:A5)
What is the purpose of "Merge & Center"?
to combine multiple cells into one and center the text
What is the shortcut for inserting the current date?
Ctrl + ; (semicolon)
What is a function?
is a predefined formula like SUM or AVERAGE
What formula calculates the total of A1, B1, and C1 without using SUM?
=A1+B1+C1
You want to count how many numbers are in A1 through A10. What function do you use?
COUNT()
What feature allows you to automatically color cells based on values?
Conditional Formatting
What shortcut lets you undo an action?
Ctrl + Z
What is a worksheet?
is a single page or tab within an Excel file