I would create a _______ chart if I wanted to show proportions or percentages.
What is a Pie Chart?
100
What symbol must be included at the beginning of every formula?
What is the Equal sign?
100
If you have dollar amounts on your spreadsheet, they should be formatted to ____ decimal places.
What is 2?
100
Use this key to select alternating columns in a spreadsheet.
What is the Ctrl Key?
200
When typing in a cell, the text also appears in the _____ bar.
What is Formula Bar?
200
I would use a ______ chart if I wanted to look at trends over time.
What is a Line Chart?
200
If I wanted to add up more than two (2) cells together (i.e. B1, B2, B3, and B4), what formula should I use?
What is =Sum(B1:B4)?
200
Every chart should contain a __________.
What is a Title?
200
This is an alternate button that you can use to add more than any two (2) numbers together?
What is AutoSum button?
300
Which cell would be 6 to the right and 5 down?
What is Cell F5?
300
If you had more than one (1) line on a Line Chart, what would need to be included?
What is a Legend?
300
If I wanted to calculate the sales tax added to a purchase of $130 (sales tax is 13%), what would be the formula?
What is =130 * 0.13?
300
$$ on a spreadsheet should appear in the ______ row and ______ row only.
What is 1st row and Total row?
300
If you want to copy a formula to multiple cells, you would use the _____ _________.
What is the Fill Handle?
400
When you have multiple sheets in Excel, this is also known as a ____________.
What is a Workbook?
400
I would use a ______ or ______ chart if I wanted to compare different values.
What is a Bar or a Column Chart?
400
The formula to calculate the average of 5 student marks contained in Cells C3, C4, C5, C6, and C7 would be ______.
What is =Average(C3:C7)?
400
Row headings in the A column should be ______ aligned.
What is Left?
400
An ____________ ______ __________ consists of a $ surrounded by the Row # and/or the Column letter.
What is an Absolute Cell Reference?
500
If I was in cell R7 and moved 4 to the left, 3 down, and then 6 to the right, what cell would I be in?
What is Cell T10?
500
If you select data for your chart and realize that the data on the horizontal axis should be on the vertical axis and vice versa, what button can you press to fix the issue?
What is the "Switch Row/Column Data" button?
500
Scenario: Total Sales for Guelph Toyota is contained in F5; Total Sales for Toyota Canada is contained in F13. The "Percentage of Total Sales for Guelph Toyota" would be calculated by using the following formula:
What is =F5/F13?
500
These three items should be included in the footer of every spreadsheet.
What is Your Name, Course, and Current Date?
500
These are the shortcut keys used to show formulas on a spreadsheet?