or browse by category
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!
Every table needs to have row and column headers. True or false?
What is "Concatenate"?
It's how you can move cells around in your spreadsheet.
Combining the values of two different cells together.
An easy way to add large groups of cells together.
You can paste a formula into a cell that already has data in it. True or false?
What indicates that there is a comment on a cell?
The cell turns yellow
A red triangle in the upper left corner of the cell
A green triangle in the upper left corner of the cell
A yellow triangle in the upper left corner of the cell
What does CSV stand for?
Comma Super Value
Cool Summer Van
Character Space Vehicle
Comma Separated Values
Where do you find "Resize Columns to Fit Data"?
In the Format menu
In the File menu
In the Table menu
In the Edit menu
What does a stepper do?
Causes a drop down menu to appear.
Allows you to tighten your glutes.
Highlights the cell you are selecting.
Allows you to move up and down in increments.
If your spreadsheet spans more than what you can view on the page, how can you keep viewing your header?
Edit the spreadsheet
Freeze Column Row
Freeze Header Row
Minimize your window
What can you access when you select the "Insert" dropdown?
All answers are correct
When you add an object to your spreadsheet, where does it land?
Behind the text but in front of the other objects.
On the topmost layer.
On the bottom layer.
Behind all the text.
Can you attach a line or curve to an individual cell?
You can change all of the stock information in your row simply by changing the stock in the first column. True or false?
When editing what kind of chart would "Wedges" show up in the window?
How can you keep the file size of your Numbers spreadsheet down?
By selecting "Use header names as labels in Preferences"
By selecting "Optimize movies and images for iOS in Preferences.
By selecting a smaller text size.
By selecting "Automatically detect lists" in Preferences.
Once you insert an image in your spreadsheet, you cannot edit it further. True or false?
How do you create a formula that uses data from two separate tables?
Select all the cells you want at the same time.
Select the data you want from each individual table when creating the formula.
Create individual formulas in each table then put them together.
You cannot use data from two different tables to create a formula.
When you make a custom format, can you save it?
What are some kind of rules can you apply when you are using Conditional Highlighting?
Numbers and Averages
Numbers, Dates, and Text
How can you take out the background of an image when it is in your spreadsheet?
By replacing the image
By using Edit Mask
By using Instant Alpha
You can't edit the image
If you want to go back to a previous version, how can you do that?
Go to "Edit" and "Undo" until you get back to what you want.
Click "File" and "Revert to".
Hit the backspace button.
Click "File" and "Duplicate".
You have answered
out of 20
to take this quiz.
If you do not have an account, please
Get Your Grade
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
Back to the Course
View My Grades
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
Thank you for your input!
Your message has been successfully sent
Don't Know Where To Start?
Ask A Course Advisor
Copy the link below and paste it into an email, forum, or Facebook to share this with your friends.
Make money when you share our links
Become a macProVideo.com Affiliate!
The current affiliate rate is: 50%
Classes Start Next Week!
Live 8-week Online Certification Classes for:
Logic Pro X