Basic Excel functions
Authored by Aamir Aziz
Computers
8th Grade
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
23 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
The function that lets you add up a range of cells or values
SUM
AVERAGE
MIN
MAX
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
What function was used to find the highest grade?
average
min
sum
max
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
The Count column found on the Grade Count table, can be computed by this function.
counta
countif
count
countblank
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
SUM, AVERAGE, IF, MIN and MAX are examples of _______.
user-defined functions
online functions
table functions
predefined functions
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
The function COUNT is specific for ___________
counting cells
counting numbers
counting text
counting tables
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
To display the Letter Grade Equivalent, we can use the ___ function.
if
count
average
sum
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
$
&
#
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
WE VIDEO KEYS
Quiz
•
5th - 8th Grade
20 questions
My Digital World - Smart Searching
Quiz
•
7th - 8th Grade
20 questions
Microsoft Publisher/Graphic Design Extra Credit Review
Quiz
•
6th - 8th Grade
18 questions
Word Tables and Tabs
Quiz
•
4th - 11th Grade
20 questions
Quiz
•
7th - 12th Grade
20 questions
Word Processing Lesson 1
Quiz
•
5th - 9th Grade
19 questions
Presentation & Business Skills
Quiz
•
6th - 8th Grade
20 questions
Excel Spreadsheet Intro
Quiz
•
KG - University
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
