Library
Articles
Pricing
Faculty
AudioPedia
Support
Login
Sign Up
Share
Go
or browse by category
Audio
Video
Graphics
Productivity
Web
Take a 20 question quiz to test and certify your knowledge of the tutorial-video course
Numbers 201 - Numbers Advanced.
Get a mark of 80% or higher to pass this quiz!
1
What are some kind of rules can you apply when you are using Conditional Highlighting?
Just Dates
Just Numbers
Numbers and Averages
Numbers, Dates, and Text
2
What does a stepper do?
Causes a drop down menu to appear.
Allows you to move up and down in increments.
Highlights the cell you are selecting.
Allows you to tighten your glutes.
3
How do you create a formula that uses data from two separate tables?
Select the data you want from each individual table when creating the formula.
You cannot use data from two different tables to create a formula.
Create individual formulas in each table then put them together.
Select all the cells you want at the same time.
4
How can you take out the background of an image when it is in your spreadsheet?
By using Instant Alpha
By using Edit Mask
You can't edit the image
By replacing the image
5
Can you attach a line or curve to an individual cell?
Yes
No
6
What does CSV stand for?
Comma Super Value
Comma Separated Values
Character Space Vehicle
Cool Summer Van
7
Where do you find "Resize Columns to Fit Data"?
In the File menu
In the Edit menu
In the Format menu
In the Table menu
8
What indicates that there is a comment on a cell?
The cell turns yellow
A yellow triangle in the upper left corner of the cell
A red triangle in the upper left corner of the cell
A green triangle in the upper left corner of the cell
9
If your spreadsheet spans more than what you can view on the page, how can you keep viewing your header?
Freeze Column Row
Freeze Header Row
Edit the spreadsheet
Minimize your window
10
You can change all of the stock information in your row simply by changing the stock in the first column. True or false?
False
True
11
When you make a custom format, can you save it?
No
Yes
12
If you want to go back to a previous version, how can you do that?
Click "File" and "Revert to".
Go to "Edit" and "Undo" until you get back to what you want.
Hit the backspace button.
Click "File" and "Duplicate".
13
Every table needs to have row and column headers. True or false?
True
False
14
You can paste a formula into a cell that already has data in it. True or false?
True
False
15
When you add an object to your spreadsheet, where does it land?
Behind all the text.
On the bottom layer.
Behind the text but in front of the other objects.
On the topmost layer.
16
Once you insert an image in your spreadsheet, you cannot edit it further. True or false?
False
True
17
How can you keep the file size of your Numbers spreadsheet down?
By selecting "Automatically detect lists" in Preferences.
By selecting "Optimize movies and images for iOS in Preferences.
By selecting "Use header names as labels in Preferences"
By selecting a smaller text size.
18
What can you access when you select the "Insert" dropdown?
Minimum
All answers are correct
Sum
Average
19
What is "Concatenate"?
An easy way to add large groups of cells together.
It's how you can move cells around in your spreadsheet.
"With catenate".
Combining the values of two different cells together.
20
When editing what kind of chart would "Wedges" show up in the window?
Bar Chart
Pie Chart
Venn Diagram
Medical Chart
Numbers 201
Numbers Advanced
You have answered
0
out of 20
questions.
You must
login
to take this quiz.
If you do not have an account, please
sign up
.
Get Your Grade
Cancel Quiz
Nice try! Unfortunately you didn't have enough correct answers to pass the quiz. No sweat! You can retake a quiz once per day.
-
-
You need 80% to pass this quiz
Retake Quiz
Back to the Course
View My Grades
Feedback
How are we doing?
We'd love your thoughts, feedback and questions regarding our new site. All feedback is appreciated!
We do not respond to this form! If you need support, please visit our
support page
.
Thank you for your input!
Your message has been successfully sent
Course Advisor
Don't Know Where To Start?
Ask A Course Advisor
Ask Us!
Copy the link below and paste it into an email, forum, or Facebook to share this with your friends.
copy
Make money when you share our links
Become an Ask.Video Affiliate!
The current affiliate rate is: 50%
Sign Up
Facebook
Twitter
Linkedin
Google+
Reddit
Pinterest
Classes Start Next Week!
Live 8-week Online Certification Classes for:
Logic Pro X
Learn More
Ableton Live
Learn More
Bitwig
Learn More