Excel Review

Quiz
•
Business
•
10th Grade
•
Hard
Laura Miley
Used 23+ times
FREE Resource
24 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the formula to calculate the average of a set of numbers?
=MEAN
=AVERAGE
=AVG
=COUNTA
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the formula to find the highest value in a set of cells?
=HIGH
=HIGHEST
=MAXIMUM
=MAX
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the correct way to write cells A1 through C10?
A1-C10
A1:C10
A1,C10
A1;C10
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is the correct way to write cells A1 AND C10?
A1,C10
A1&C10
A1;C10
A1 and C10
5.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Which tabs do you find the AutoSum (Σ) function on? PICK TWO
Home
Insert
Page Layout
Formulas
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
What is it called when an equation remains constant no matter where it is copied to?
Constant Cell Reference
Relative Cell Reference
Same Cell Reference
Absolute Cell Reference
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
You have a ranged table from B2:D8 named "Sales". How would you reference this range in an equation? (Pick 2)
=sum(B2:D8)
=sum(B2:D8,Sales)
=sum(Sales)
=sum(B2Sales)
Create a free account and access millions of resources
Similar Resources on Wayground
22 questions
Business Operations & Production Methods

Quiz
•
10th Grade
20 questions
AES Excel 2: Quiz Unit 1-Using Formulas & Functions

Quiz
•
8th - 12th Grade
20 questions
Team Engagement

Quiz
•
10th Grade
20 questions
KUIS SPREADSHEET KELAS X AKL

Quiz
•
10th Grade
24 questions
SDA - Lesson 6

Quiz
•
9th - 12th Grade
20 questions
#1 LATIHAN SOAL ELEMEN 6 & 7

Quiz
•
10th Grade
25 questions
Chapter 3 PPT

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade