What is the main purpose of conditional formatting?

To highlight cells based on rules

To insert a chart automatically

To protect a sheet with a password

A teacher wants students to choose only “Yes” or “No” in cell D2. Which data validation rule is most appropriate?

Text contains the word “Maybe”

Column A contains departments, and column B contains salaries. Which formula finds the average salary for the Sales department?

=AVERAGEIF(A2:A20,"Sales",B2:B20)

=AVERAGEIF(B2:B20,"Sales",A2:A20)

=COUNTIF(A2:A20,"Sales",B2:B20)

A teacher wants cells with scores below 60 to have a red background. Which setup is best?

Apply conditional formatting with the rule “Less than 60”

Use data validation to allow only scores below 60

A class list has columns for Student, Grade, and Attendance. The teacher wants to see the lowest attendance first while keeping each student's information together. What should the teacher do?

Create a filter and sort the entire range by Attendance from A to Z

Sort only the Attendance column without selecting the other columns

Use Autofill on the Attendance column

Apply a percent format to the Student column

A school store table lists Item IDs in A2:A20, item names in B2:B20, and prices in C2:C20. A student enters an Item ID in F2, but VLOOKUP returns the wrong item. The student used TRUE for the last argument. What is the best correction if the IDs are not sorted?

Change the last argument to FALSE for an exact match

Change the column index to 1 in every case

A teacher wants grades labeled “Excellent” for 90 or higher, “Good” for 75–89, “Needs Practice” for 60–74, and “Fail” below 60. Which IFS formula correctly assigns the label for the score in B2?

=IFS(B2>=90,"Excellent",B2>=75,"Good",B2>=60,"Needs Practice",B2

=IFS(B2=90,"Excellent",B2=75,"Good",B2=60,"Needs Practice",B2=0,"Fail")

=IFS(B2>=60,"Fail",B2>=75,"Needs Practice",B2>=90,"Good",B2

Which formula in C2 correctly assigns an "A" for scores 90 and above, a "B" for scores 80-89, and a "C" for anything lower?

=IFS(B2>=90, "A", B2>=80, "B", B2<80, "C")

=IFS("A", B2>=90, "B", B2>=80, "C", B2<80)

=IFS(B2>90, "A", B2>80, "B", TRUE, "C")

Shipping is $5 for under 5 lbs, $10 for 5 to 10 lbs, and $20 for over 10 lbs. Which formula correctly calculates the fee for Order 5001 in C2?

=IFS(B2>10, 20, B2>=5, 10, B2<5, 5)

=IFS(B2<5, 5, B2<10, 10, B2>10, 20)

=IFS(B2>10=20, B2>5=10, B2<5=5)

Which formula calculates the average daily revenue specifically for the "North" locations?

=AVERAGEIF(A2:A4, "North", B2:B4)

=AVERAGEIF(B2:B4, "North", A2:A4)

=AVERAGEIFS(A2:A4, B2:B4, "North")

To arrange this table so the Last Names are in alphabetical order from A to Z, what should you do?

Create a Filter and sort Column A

Use Conditional Formatting on Column A

[AP CSP] Spreadsheets Review

Authored by Tommy Nguyen

Computers

9th Grade

Used 10+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which function looks up a value in the first column of a table and returns related information from another column?

IFS

VLOOKUP

AVERAGEIF

COUNTIF

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which function checks several conditions and returns a result for the first condition that is true?

IFS

SUM

FILTER

VLOOKUP

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which function finds the average of cells that meet a condition?

COUNT

AVERAGEIF

MAX

IFERROR

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which function counts cells that meet a specific condition?

COUNTA

COUNTIF

SUMIF

AVERAGE

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What does data validation do in Google Sheets?

Deletes duplicate worksheets

Changes the color of every row

Restricts the type of data entered in a cell

Sorts all columns alphabetically

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which tool changes how numbers appear as percentages, dates, or currencies without changing their values?

Conditional formatting

Data validation

Autofill

Number formatting

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which feature automatically continues a pattern, such as Monday, Tuesday, and Wednesday?

Data validation

Freeze panes

VLOOKUP

Autofill

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Popular Resources on Wayground

10 questions

Safety Day 2026 – Student Review

Quiz

•

9th Grade

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

Discover more resources for Computers

32 questions

Unit 3: Intro to App Design (APCSP 22-23, Code.org)

Quiz

•

9th - 12th Grade

15 questions

AP CSP - Code.org Unit 3 Review

Quiz

•

9th - 12th Grade

40 questions

Introduction to Microsoft Word

Quiz

•

8th - 12th Grade

[AP CSP] Spreadsheets Review

Which function looks up a value in the first column of a table and returns related information from another column?

Which function checks several conditions and returns a result for the first condition that is true?

Which function finds the average of cells that meet a condition?

Which function counts cells that meet a specific condition?

What does data validation do in Google Sheets?

Which tool changes how numbers appear as percentages, dates, or currencies without changing their values?

Which feature automatically continues a pattern, such as Monday, Tuesday, and Wednesday?

Cell B2 contains 18, and cell C2 contains 7. Which formula adds these values?

What is the main purpose of conditional formatting?

Which command can display only the rows that match selected criteria?

Access all questions and much more by creating a free account

Popular Resources on Wayground

Discover more resources for Computers