What is the correct formula to calculate the average of the values in the range B1 to B10 in Excel?
Excle
1st Grade
•11 Qs
Similar activities
S1 Spreadsheets
1st - 2nd Grade
•16 Qs
Database Fundamentals
KG - University
•10 Qs
Spreadsheet Basics
KG - 5th Grade
•10 Qs
San Isidro ES LAC on MS Excel
KG - University
•9 Qs
Microsoft Excel
KG - 2nd Grade
•15 Qs
Spreadsheets 1
1st - 3rd Grade
•10 Qs
IT Spreadsheet
1st - 5th Grade
•13 Qs
S1 Intro to Spreadsheets
1st Grade
•9 Qs
Excle
Quiz
•
Computers
•
1st Grade
•
Hard
zeyad ELROUBY
FREE Resource
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=AVG(B1:B10)
MEAN(B1:B10)
=AVERAGE(B1:B10)
=MID(B1:B10)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to round the number 3.14159 to 2 decimal places in Excel?
=ROUND(3.14159, 2)
=ROUND(3.14159. 2)
=ROUND(3.14159 2)
=ROUND(3.14159; 2)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel finds the smallest number in a specified range?
=MINIMUM(C1:C10)
=MIN(C1:C10)
=LEAST(C1:C10)
=SMALL(C1:C10)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel finds the largest number in a specified range?
=MAXIMUM(D1:D10)
=MAX(D1:D10)
=LARGE(D1:D10)
=GREATEST(D1:D10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the VLOOKUP function do in Excel?
Searches for a value in the first row and returns a value in the same column from a specified row
Searches for a value in the left-most column and returns a value in the same row from a specified column
Searches for a value in a specified column and returns a value in the same row from the first column
Searches for a value in the first column and returns a value in the same row from a specified column
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the HLOOKUP function do in Excel?
Searches for a value in the left-most column and returns a value in the same row from a specified column
Searches for a value in the first row and returns a value in the same column from a specified row
Searches for a value in a specified column and returns a value in the same row from the first column
Searches for a value in the first column and returns a value in the same row from a specified column
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the XLOOKUP function do in Excel?
Searches for a value in the left-most column and returns a value in the same row from a specified column
Searches for a value in the first row and returns a value in the same column from a specified row
Searches for a value in the first row and returns a value in the same column from a specified row
Searches for a value in a specified range and returns a corresponding value from another specified range
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Microsoft
Apple
Others
Similar Resources on Quizizz
15 questions
EPP4 Q1 Week5 WORD PROCESSOR
Quiz
•
1st - 12th Grade
10 questions
Spreadsheets 1
Quiz
•
1st - 3rd Grade
15 questions
Basic Excel
Quiz
•
1st Grade
16 questions
S1 Spreadsheets
Quiz
•
1st - 2nd Grade
10 questions
Database Fundamentals
Quiz
•
KG - University
12 questions
4-5 Q
Quiz
•
1st - 5th Grade
10 questions
Grade 1 - MS Excel
Quiz
•
1st Grade
8 questions
Flexbox
Quiz
•
1st Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts
Quiz
•
4th Grade
20 questions
Math Review - Grade 6
Quiz
•
6th Grade
20 questions
math review
Quiz
•
4th Grade
5 questions
capitalization in sentences
Quiz
•
5th - 8th Grade
10 questions
Juneteenth History and Significance
Interactive video
•
5th - 8th Grade
15 questions
Adding and Subtracting Fractions
Quiz
•
5th Grade
10 questions
R2H Day One Internship Expectation Review Guidelines
Quiz
•
Professional Development
12 questions
Dividing Fractions
Quiz
•
6th Grade