Excel Masterclass Part 2
Quiz
•
Professional Development
•
Professional Development
•
Practice Problem
•
Medium
Stuart Luxmore
Used 6+ times
FREE Resource
Enhance your content in a minute
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Clicking on the button indicated will allow me to
Apply formatting
Sort Data
Count Items
Format Cells
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
To convert this range of cells into an Excel table I need to:
Click on the 'Insert' tab (ribbon) and choose Table
Copy the cells and paste to a new worksheet
3.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
The formatting in Column F (left) is called:
Colour Scale
Cell Formatting
Icon Set
Data Bars
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When your data is set out like this.....
Columns are known as records
Individual cells are known as names
Rows are known as records
The first row is known as Pivot Fields
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The conditional formatting rules manager enables me to.....
Sort the cells previously activated
Apply a filter to the chosen cells
Apply a function to the active cell
Edit existing rules
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
constructivist Approach
Quiz
•
Professional Development
10 questions
Inglese ascolto e rispondo
Quiz
•
Professional Development
10 questions
Motorcycle and ATV
Quiz
•
Professional Development
10 questions
Vitamin C 2024
Quiz
•
Professional Development
10 questions
Business Writing 4
Quiz
•
Professional Development
10 questions
Military Must-Know-Words 1 - 10 (Quiz 2)
Quiz
•
Professional Development
10 questions
New Hire Orientation
Quiz
•
Professional Development
10 questions
Objection Handling, Creating Urgency and Sales Closure
Quiz
•
Professional Development
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
