EXCEL BASICS
What is the intersection of a row and a column called?
Cell
Which function adds numbers together?
SUM
Which formatting option makes text darker and heavier?
BOLD
What feature arranges data alphabetically or numerically?
Sort
What formula would you use to multiply A2 by B2?
=A2*B2
What symbol must begin a formula?
Equal sign (=)
Which function calculates the average?
AVERAGE
Which number format should you use for monetary values?
Currency
What feature displays only the records that meet specific criteria?
Filter
What formula would calculate 7% tax on the amount in C5?
=C5*7%
What is the difference between a workbook and a worksheet?
A workbook is the entire Excel file; a worksheet is one sheet within the workbook.
Which function identifies the largest value in a range?
MAX
What feature combines multiple cells into one larger cell?
Merge & Center
What command allows you to keep headings visible while scrolling?
Freeze Panes
What function counts cells containing numbers?
COUNT
What is the address of the cell in Column C, Row 7?
C7
Which function identifies the smallest value in a range?
MIN
Which feature automatically changes the appearance of cells based on their values?
Conditional Formatting
What feature can identify repeated entries in a dataset?
Conditional Formatting / Remove Duplicates, depending on the task
What function counts cells based on a specific condition?
COUNTIF
What are the letters at the top of an Excel worksheet called
Column headings/labels
Write a formula that calculates the average of cells B2 through B10.
=AVERAGE(B2:B10)
What Excel feature allows you to display text on multiple lines within one cell?
Wrap Text
If you only want to see employees whose sales are greater than $5,000, what Excel feature could you use?
Filter
Write a formula that displays "PASS" if A2 is 70 or higher and "FAIL" if it is below 70.
=IF(A2>=70,"PASS","FAIL")