
SS Lesson 3 - Working with Formulas and Functions
Authored by Julie Krost
Computers
7th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The MIN and MAX functions ignore what cell content?
jerry
pictures
text
numbers
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Addition, subtraction, multiplication, division, and exponentiation are examples of what
multiplication
Conditional Formatting
formulas
funtions
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What character is used in a spreadsheet formula to represent exponent calculation?
$
@
%
^
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formulas shows the correct use of the SUM funtion
(g6-/hy7)=SUM
=SUM(G3:G10
+SUM(H3-B7)
(D5+G7)=SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SUM, average, count, maximum value, and minimum value are examples of what?
multiplication
conditional formatting
formulas
functions
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the cell reference B$5, What part of the cell reference would remain unchanged?
row 8
row 7
row 5
row 6
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the cell reference $A5, what part of the cell reference would remain unchanged
column D
column C
column A
column B
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?