Excel Basics
What is the difference between a workbook and a worksheet?
Workbook = file; Worksheet = sheet inside the file.
Rows are labeled with
Numbers.
What formula adds all values from A1 to A5?
=SUM(A1:A5)
What formula finds the smallest number in C1–C5?
=MIN(C1:C5)
What is conditional formatting used for?
To automatically change cell appearance based on rules.
What do we call the intersection of a row and a column?
ACell.
Columns are labeled with
Letters.
What formula calculates the average of cells B1–B10?
=AVERAGE(B1:B10)
What formula finds the largest number in D1–D10?
=MAX(D1:D10)
Give an example of a rule you can apply with conditional formatting.
Highlight cells greater than 50, or Any Rule.
What file extension does Excel usually use?
.xlsx (or .xls for older versions).
What is the address of the cell in Row 3, Column B?
B3.
If A1=5 and A2=15, what does =SUM(A1:A2) return?
20
Write an IF formula that shows “Pass” if A1 ≥ 50, otherwise “Fail.”
=IF(A1>=50,"Pass","Fail")
How do you highlight all cells in Column B that are greater than 50?
Select Column B → Conditional Formatting → Highlight Cell Rules → Greater Than → type 50.
Which symbol must every formula start with?
The equals sign (=).
How do you quickly select an entire row?
Click the row number on the left.
What does =AVERAGE(10,20,30) return?
20
What will =MIN(7,12,4,9) return?
4
Can conditional formatting change text color, cell color, or both?
Both.
Name 3 types of data you can enter into an Excel cell.
Text, numbers, dates (also formulas).
What is the first cell in an Excel worksheet?
A1.
How are SUM and AVERAGE different?
SUM = adds all numbers; AVERAGE = adds all numbers then divides by count.
What will =IF(AVERAGE(A1:A5)>60,"Good","Needs Work") return if the average is 55?
“Needs Work”
Apply conditional formatting so that cells below 40 turn red, and cells 40 and above turn green.
Use two rules:
Rule 1: Format cells <40 → red fill.
Rule 2: Format cells >=40 → green fill.