Excel Mastery Challenge
Authored by Chadie Natividad
Computers
7th Grade
Used 3+ 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
10 sec • 1 pt
You have a list of scores in cells A1 to A10. You need to find the total score. Which formula would you use?
=SUM(A1:A10)
=AVERAGE(A1:A10)
=MAX(A1:A10)
=COUNT(A1:A10)
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
You are managing a budget spreadsheet and need to find the highest expense from a range of values in cells B1 to B20. Which function would you use?
=MIN(B1:B20)
=AVERAGE(B1:B20)
=MAX(B1:B20)
=COUNT(B1:B20)
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
You are preparing a contact list and need to combine the first name (cell A1) and last name (cell B1) into a single cell. Which formula would you use?
=COMBINE(A1, B1)
=MERGE(A1, B1)
=JOIN(A1, B1)
=CONCATENATE(A1, B1)
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
You're putting up a business and need to calculate the total cost by multiplying the quantity in cell A1 with the price in cell B1. Which formula would you use?
=SUM(A1*B1)
=PRODUCT(A1,B1)
=AVERAGE(A1*B1)
=MAX(A1,B1)
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
You're working with a large dataset and want to sort the data based on multiple criteria (e.g., first by general average, then by gender). What command enables you to do this?
Sort by Color
Custom Sort
Filter
Freeze Panes
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
You're analyzing survey responses and need to categorize responses as "Satisfied" or "Dissatisfied" based on a certain score threshold. Which Excel function would you use?
=AVERAGE( )
=IF( )
=TRIM( )
=PROPER( )
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
What symbol is used in Excel to indicate the beginning of a formula?
+
--
*
=
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
15 questions
bài 4: SỬ DỤNG CÁC HÀM ĐỂ TÍNH TOÁN
Quiz
•
7th Grade
10 questions
Google Sheets - Fast and Curious!
Quiz
•
6th - 7th Grade
10 questions
Excel If function WSC 4.2.3
Quiz
•
7th Grade - University
10 questions
Yr 7 Google Sheets Task
Quiz
•
7th Grade
12 questions
test bài 8 tin 7
Quiz
•
7th Grade
10 questions
Tin 7 Bài 6: Làm quen với PM Bảng tính 1
Quiz
•
7th Grade
15 questions
Spreadsheets
Quiz
•
1st - 12th Grade
10 questions
Year 7 Spreadsheet basics
Quiz
•
6th - 7th Grade
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
