Formulas in Excel
Authored by Manya N
Computers
6th - 9th Grade
Used 302+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a formulas in excel sheet
The address of the cells
The defined expression that contains values, constants, Call reference, functions and operators
Numbers or text values that can be entered directly in a formula
2.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
Excel displays the error values (a) when the formula contains invalid data
3.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
The (a) function Is used to multiply the content Of the cells
4.
FILL IN THE BLANK QUESTION
30 sec • 1 pt
(a) Specify the type of Operation you want to perform
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An error that occurs when a formula is not spelt correctly
#NAME?
#VALUE!
#DIV/0!
#####
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What feature is particularly useful when you want to add all numbers in a row or column
Autosum
Product
Operators
Hierarchy
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The call references contain values to be used for calculation passed to the function are called
Arguments
Operators
Product
Autosum
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?
