
Formulas and Functions in Excel
Authored by Paola Miranda
Education
University
Used 9+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
6 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The formula used to do additions
SUMIF
SUMIFS
SUM
SUBTOTAL
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Average Concept
The sum of the numbers divided by how many numbers are in the list
The value that occurs the most
The sum of the number divided by 100
The value in the middle of a data set. Meaning that 50% of data points are under the average and the other 50% are over the average.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Use the COUNT function to get
Use the COUNT function to count the number of selected characters (numeric or alphanumeric)
Use the COUNT function to count the number of alphanumeric characters.
Use the COUNT function to count the number of numeric characters.
Use the COUNT function to make an addition (the total of all numeric characters selected)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
True or False. The minimum and maximum value can be identified organizing the data from largest to smallest or vice versa, and enabling the option min and max in the Sum function.
True
False
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
False or True. Organizing the data of a column from the Largest to the Smallest is the faster way to now the minimum and maximum value of the column.
True
False
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
It is the quickest and more practical functionality to do an interactive summary of data in Excel.
Filters
Pivot Table
Count Function
Sum (Addition) Function
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
11 questions
DEMAND AND SUPPLY
Quiz
•
University
7 questions
How Well Do You Know Our Leopard Cats?
Quiz
•
KG - Professional Dev...
11 questions
Research Objectives & Research Background
Quiz
•
University
9 questions
HUSTer! Rung chuông vàng TOEIC!
Quiz
•
University
10 questions
velykos
Quiz
•
University
10 questions
Teaching terminologies
Quiz
•
University
10 questions
Units & Dimensions
Quiz
•
University
11 questions
[QTEDU] HSK 4 - Buổi 6: 经理对我印象不错 (2)
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Education
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
5 questions
Examining Theme
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University