Sheets: Formulas
6th Grade
•18 Qs
Similar activities
A words - GCSE Computer Science
1st - 10th Grade
•13 Qs
Grade6Review
6th Grade
•21 Qs
Y7 - Small Basic - HL 1
6th - 7th Grade
•20 Qs
Databases
5th - 7th Grade
•19 Qs
DPS Jorhat - Robotics Skill Assessment
6th - 8th Grade
•20 Qs
Q7/Q8 Email Vocabulary (Basics in 21t4s)
5th - 9th Grade
•17 Qs
LEVEL 2. BÀI 1 CĂN BẢN VỀ CÔNG NGHỆ 17.3.23
6th - 8th Grade
•16 Qs
Gaming Lesson 1
6th - 8th Grade
•15 Qs
Sheets: Formulas
Quiz
•
Computers
•
6th Grade
•
Medium
Franki Mitchell
Used 65+ times
FREE Resource
Enhance your content
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What character is used in a spreadsheet formula to represent exponent calculation?
^
*
+
/
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the term "absolute" mean for a formula?
The formula changes based on its location.
The formula remains unchanged when it is moved.
The formula is related to another spreadsheet.
The formula is related to the cells before it.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
Functions
Conditional formatting
Formulas
Spreadsheet Data
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formulas shows the correct use of the AVERAGE function?
=(AVERAGE(L3:L10))/7
=AVERAGE(L3:L10)
+AVERAGE(L3;L10)
=AVERAGE(L3..L10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the term "relative" mean for a formula?
The formula is related to the cells before it.
The formula changes based on its location.
The formula remains unchanged when it is moved.
The formula is related to another spreadsheet.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What symbol is used to begin a formula?
>
+
=
-
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What result does the COUNT function show?
Total number of cells containing numbers in the selected range
Total number of cells containing text only in the selected range
Total number of cells containing the TRUE value specified in a logical test
Total number of cells containing data in the selected range
Create a free account and access millions of resources
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
14 questions
Scratch Basics Term 3 Final
Quiz
•
KG - University
16 questions
Python Basics
Quiz
•
KG - University
20 questions
7.5 MCQ Assessment
Quiz
•
6th Grade
20 questions
Grade 6 Exam
Quiz
•
6th Grade
20 questions
Computer Programming Language
Quiz
•
6th - 7th Grade
18 questions
NGHS GCSE PROGRAMMING LANGUAGES
Quiz
•
6th Grade
20 questions
New Scratch
Quiz
•
6th - 8th Grade
15 questions
History of Computers
Quiz
•
6th - 12th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
