Excle
Authored by zeyad ELROUBY
Computers
1st Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
11 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to calculate the average of the values in the range B1 to B10 in Excel?
=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
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
10 questions
CHAPTER 4 - SQL (4.1.1 - 4.1.3)
Quiz
•
1st - 3rd Grade
10 questions
Intellectual Property Rights
Quiz
•
1st - 5th Grade
11 questions
Soal Photoshop Dasar 1
Quiz
•
1st Grade - University
10 questions
Tin học đại cương
Quiz
•
1st Grade
10 questions
MATLAB
Quiz
•
KG - University
16 questions
Information Communication Technology
Quiz
•
1st Grade
10 questions
Scratch intro & Pen Commands Quiz
Quiz
•
1st - 10th Grade
16 questions
Y9 refresher
Quiz
•
1st - 9th 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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
20 questions
Telling Time to the Hour and Half hour
Quiz
•
1st Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
13 questions
Fractions
Quiz
•
1st - 2nd Grade
20 questions
CVC Words
Quiz
•
KG - 1st Grade
15 questions
Place Value tens and ones
Quiz
•
1st Grade
16 questions
Money - Coins
Lesson
•
1st - 2nd Grade
20 questions
Halves and Fourths
Quiz
•
1st Grade