SPREADSHEET FUNCTIONS
Authored by SUMAIYA BEEVI
Information Technology (IT)
9th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a spreadsheet, all formulae must begin with _______ sign.
#
=
$
&
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To count only numerical data's, _________ function is used.
COUNTIF
COUNTA
COUNTBLANK
COUNT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is correct for adding up a selection of numbers?
sum(A1+A10)
=sum(A1+A10)
sum(A1:A10)
=sum(A1:A10)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What two operations does the AVERAGE function perform?
Addition and Multiplication
Multiplication and Division
Addition and Subtraction
Addition and Division
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula will find the minimum value in the range C1 to C4 if the values are 7, 2, 9, and 5?
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If the values in cells D1, D2, and D3 are 15, 25, and 10 respectively, which formula will find the maximum value?
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
