Excel Formulas - Francis Bacon
Authored by 05 Computerscience
Computers
9th - 12th Grade
Used 1+ 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
All formulas must begin with
parenthesis
sign
equal sign
uppercase
2.
FILL IN THE BLANK QUESTION
1 min • 3 pts
Data without this sign is considered a (a)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SUM
Calculates the average of a range of numbers.
Counts the number of cells in a range that contain numbers.
Adds up all the numbers in a range.
Finds the largest value in a range of numbers.
4.
FILL IN THE BLANK QUESTION
45 sec • 3 pts
Calculate the sum total of all cells in a range which meet the logical test.
(a)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Calculates the average of a range of numbers.
=AVERAGEIF
=AVERAGE
=COUNT
IF
6.
FILL IN THE BLANK QUESTION
45 sec • 3 pts
Counts the number of cells in a range that contain numbers.
(a)
7.
FILL IN THE BLANK QUESTION
45 sec • 2 pts
Join two or more strings together to create one text string
(a)
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?
