Sheets: Formulas
Authored by Franki Mitchell
Computers
6th Grade
Used 65+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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
20 questions
KTTX TIN 6 HK2
Quiz
•
6th Grade
14 questions
Taylor Chess Quiz
Quiz
•
4th - 12th Grade
16 questions
Formatting and Editing
Quiz
•
6th - 7th Grade
15 questions
computer language
Quiz
•
5th - 10th Grade
16 questions
PowerPoint 2013
Quiz
•
6th Grade
15 questions
Yr 7.2: LC Assessment
Quiz
•
6th Grade
17 questions
MS excel Keyword quiz
Quiz
•
6th Grade
15 questions
Spacing and Indention
Quiz
•
5th - 6th 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
