Excel Formulas (Beginners)
9th Grade
•13 Qs
Similar activities
S2 Subject Choice Quiz
8th - 10th Grade
•10 Qs
NCT-L9 Tiet 1-3
9th Grade
•12 Qs
Grade 4 Computer Science Quiz
4th Grade - University
•17 Qs
CPU
7th - 12th Grade
•13 Qs
ทดสอบทักษะความเข้าใจด้านการใช้เทคโนโลยีดิจิตอล
1st - 12th Grade
•11 Qs
PENILAIAN TENGAH SEMESTER - INFORMATIKA KELAS VII -
9th Grade
•15 Qs
Hari 3 - Kuis Coding & Perkenalan AI - Fitri Yanti
1st - 12th Grade
•12 Qs
Excel
1st - 12th Grade
•8 Qs
Excel Formulas (Beginners)
Quiz
•
Computers
•
9th Grade
•
Practice Problem
•
Hard
Deon Strydom
Used 6+ times
FREE Resource
Enhance your content in a minute
13 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to sum a range of cells in Excel?
=TOTAL(range)
=SUM(cells)
=ADD(range)
=SUM(range)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you multiply two cells in Excel using a formula?
=A1-B1
=A1+A1
=SUM(A1,B1)
=A1*B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the difference between absolute and relative cell references in Excel formulas.
Absolute cell references change based on the formula's position, while relative cell references do not
Absolute cell references and relative cell references are interchangeable in Excel formulas
Absolute cell references adjust when copied, while relative cell references remain constant
Absolute cell references do not change when copied, while relative cell references adjust based on the formula's position.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to find the average of a range of cells in Excel?
=SUM(range)
=AVERAGE(range)
=MAX(range)
=MIN(range)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the formula to calculate the percentage of a total in Excel?
(Part*100)/Total
(Total-Part)/Total
(Part/Total)*100
(Total/Part)*100
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function to count the number of cells that contain data in Excel?
COUNTB
COUNTA
COUNTC
COUNTD
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Explain the difference between COUNT and COUNTA functions in Excel.
COUNT function counts only numerical values, while COUNTA function counts all values including text in Excel.
COUNT function counts all values including text, while COUNTA function counts only numerical values in Excel.
COUNT function counts cells with errors, while COUNTA function counts cells without errors in Excel.
COUNT function counts cells without errors, while COUNTA function counts cells with errors in Excel.
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Scratch Application: Look and Pen Blocks
Quiz
•
9th Grade
14 questions
Introducción a Excel
Quiz
•
9th Grade
15 questions
Partes de la computadora
Quiz
•
7th - 9th Grade
10 questions
Probando Conocimientos de Excel
Quiz
•
9th - 12th Grade
10 questions
Power Point Prezentation kviz 1
Quiz
•
7th Grade - University
10 questions
Алгоритми
Quiz
•
1st - 12th Grade
10 questions
Working with tables
Quiz
•
5th - 12th Grade
10 questions
Электронные таблицы. Основные понятия.
Quiz
•
5th - 11th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
