3.2 Test your knowledge on using formulas in spreadsheets

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/3

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 1:12 AM on 6/20/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai

No analytics yet

Send a link to your students to track their progress

4 Terms

1
New cards

What is the operator for a formula that uses division?

A. Asterisk (*)

B. Backward slash (\)

C. Forward slash (/)

D. Colon (:)

C. Forward slash (/)

2
New cards

Fill in the blank: A cell ____ is composed of the letter of the cell's column and the number of its row.

A. reference

B. value

C. formula

D. range

A. Reference

3
New cards

What error message will appear when a formula cannot be interpreted as it is written?

A. LOOKUP

B. ERROR

C. N/A

D. DIV

B. ERROR

4
New cards

What should be done to resolve a NAME error?

A. Insert a comma between the cell ranges.

B. Make sure cell references have not been deleted.

C. Ensure the formula name is correct.

D. Do not divide a value by zero or an empty cell.

C. Ensure the formula name is correct.