
Quiz de Excel bien EZ
Authored by Jim Santos
Computers
11th Grade
Used 2+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
14 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the most direct way to remove a hyperlink in a cell?
Insert > Link > Picture
Home > Format Cells
Insert > Link > Insert Link
Insert > Link > Remove Link
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which option automatically adjusts the width of a column?
Home > Wrap Text
Home > Format > AutoFit Column Width
Home > Format > Column Width
Format > Manual Column Width
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula uses a column and row absolute reference?
=A1*B1
=$A$1*B1
=A$1*$B1
=A1*$B1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does Auto Fill do with the cell “Monday”?
Fills with formulas
Fills with the word “Monday” repeatedly
Fills with “Monday, Tuesday, Wednesday…”
Does nothing automatically
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To convert the text in a cell to lowercase, which function is used?
MIN()
SMALL()
LOWER()
LCASE()
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which format option applies a money format to a number?
Text Format
Time format
Accounting Format
Percentage Style
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =SUMIF(A1:A10, "X", B2:B10) do?
Add the values in column B if the cells in column A are marked with an X.
Adds values in column A from row 1 to 10
Returns the highest value
Calculates the average
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
17 questions
Cyber Camps 2018 - Review Day 3 Windows
Quiz
•
7th - 12th Grade
10 questions
Bài 25 tin 10
Quiz
•
9th Grade - University
12 questions
Premiere Pro CC File Formats
Quiz
•
6th Grade - University
12 questions
Tin học 2
Quiz
•
11th Grade
13 questions
Data Visualization Quiz
Quiz
•
9th - 12th Grade
13 questions
Python Fundamentals and Programming
Quiz
•
11th - 12th Grade
19 questions
Unity. Lesson 1
Quiz
•
9th - 12th Grade
15 questions
Grade 12-Python selection&iteration
Quiz
•
11th - 12th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade