Excel Basics Quiz: Formulas and Functions
12 Microsoft Excel questions for students and new users on cell names, formulas, copying, everyday functions, error messages and charts.
12
questions
~5 min
to play
3
question types
Free
to host
Preview and editHost this quiz liveAssign as homework
Free account. Students just need the PIN.Have a game PIN? →
Questions in this quiz
Play the first 3 free. The rest stay locked until you sign up.
- Question 1 of 3
Which name does Excel give the cell where column C meets row 5?Tap an answer
Multiple Choice
- Question 2 · unlocks after question 1
- Question 3 · unlocks after question 2
- C1 holds the formula =A1*B1. You copy it down to C2. What does the formula in C2 become?Multiple Choice
- Which reference keeps pointing at cell A1 wherever you copy the formula?Multiple Choice
- A cell filled with ##### means the formula in it has an error.True / False
- Which function adds up a group of numbers and divides by how many there are?Multiple Choice
- Which function tells you how many cells in a range hold numbers? Type just its name.Type Answer
- C2 holds =IF(B2>=50,10,0), a 10-point bonus for a score of 50 or more. B2 holds 45. What does C2 show?Multiple Choice
- A cell shows #DIV/0!. What went wrong?Multiple Choice
- Freeze Panes keeps the rows or columns you choose in view while you scroll through the rest of the sheet.True / False
- Which chart best shows how one student's test scores went up and down over a school year?Multiple Choice
Want to run this with your class?
Create a free account to host it live, assign it as homework, or copy it and change the questions.
Sign up free. No card needed.More Programming quizzes
More quizzes to play
This quiz in other languages
Sheelon