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
9 questions
S1 Intro to Spreadsheets
Quiz
•
1st Grade
10 questions
Internet Browser Quiz
Quiz
•
KG - 6th Grade
8 questions
SCR1 Recap Day 3
Quiz
•
1st Grade
15 questions
Types of chart
Quiz
•
1st - 4th Grade
10 questions
INFORMATIKA
Quiz
•
1st - 12th Grade
14 questions
Table Formatting
Quiz
•
KG - University
10 questions
Properties
Quiz
•
1st Grade
7 questions
Technology Quiz
Quiz
•
1st 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