EXCEL FUNCTIONS
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Hard
LILY PAUL
Used 80+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What function was used to find the lowest grade?
average
sum
min
max
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To display the Letter Grade Equivalent, we can use the ___ function.
if
count
average
sum
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
To sort names in a worksheet, we can use this button.
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
to count any fields containing numbers we use:
countIF function
counta function
count function
countIFs function
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A company needs to highlight with red the salaries more than 8000
it should use the bucket filler
it should use the highlighter
it should use the conditional formatting
it uses the (A) button on top of the home tab
Create a free account and access millions of resources
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
0 questions
Chapter 10 Excel Questions
Quiz
•
0 questions
Excel Lesson 10-11 Review
Quiz
•
0 questions
MS Excel Functions
Quiz
•
0 questions
Functions in Excel
Quiz
•
0 questions
Excel Lessons 10-11 Test Review
Quiz
•
0 questions
Excel - 2016- Lesson 9 & Lesson 10
Quiz
•
0 questions
Functions on MOS Exam Excel
Quiz
•
0 questions
Excel Lesson 10 Quiz
Quiz
•
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade
