Data
Formulas
Charts
Uses
Formatting
100

A Dimension or an Expression.

What is data?

100
Draw the button used to find the sum.
What is teacher checked.
100
What button do I click on to create a chart?
What is the chart button.
100
What layout or design might be chosen in Excel to keep a record of products a business might have?
What is an inventory.
100
To selct more than one cell at a time, what must you do?
What is click the mouse and drag over the cells needed.
200

The location of the majority of our data.

What is a datamart?

200
What must be at the front of a formula?
What is an equal sign.
200
What must I do to create a chart based on information you have input into your spreadsheet?
What is select the information needed, selct charts, selelct the type of chart and click ok.
200
What design or template might a teacher use to help keep track of how students score on assignments?
What is a gradebook.
200
To add a grid line only around the cells you would like to have selected, what would you do?
What is select the cells needed, click the arrow next to the gridline button and then select the outline button.
300

Used to restrict the amount of data by a user.

What is a filter?

300
What 2 ways could you use a formula to add cell A2, B2,C2, and D2?
What is select those cells and plug in the sum formula or sum key or click on cell E2 and write =A2+B2+C2+D2
300
What should be done to change the titles/labels in a chart?
What is double click on the information you would like to change and then type.
300
Name 3 ways that Excel could be used other than the obvious.
What is receipts, calendar, shopping list, etc.
300
What steps would I follow to make my page landscape?
What is Page layout, Orientation, and the Landscape.
400

Key metrics that tell the story of crucial areas of interest on a report.

What are Key Performance Indicators?

400
How would I write the formula for 6% sales tax of $325.00?
What is =6%*325.00 or 0.06*325.00
400
Where would you go to change the look of your chart so that the title and labels might be in a different place?
What is go to chart layout and choose the design that fits your chart's needs.
400
I am a mom who is making a Shopping list for the grocery store. Tell me my most efficient way to use Excel to help with with items I need to purchase, how many of those items, and the cost of each item plus the total spent. Don't leave out any details.
What is explanation judged by teacher.
400
What is the fastest way to make everything center alligned and then bold only items in row 1?
What is select the corner select all button, go to Home and click the center align. Select the 1 and click B for bold.
500

Bar charts, lines charts, histograms, Pie charts to name a few.

What are chart types?

500
How would you figure out the average of cell A1 - A5?
What is select those cells and then click Average or write Average=A1:A5
500
Tell what you would need to do to format the details of your chart and then name atleast 4 details that can customize your chart.
What is double click on the chart or go to formatting. Change, color, size, gradient, texture, pattern, ect.
500
I am a business owner who would like to keep track of my products, how much they cost, how many I have, and how many I sell. I would also like to know my cost ffrom the manufacturer vs. my profit. How could I simply keep track of this using Excel?
What is explanation judged by teacher.
500
How do I make the formula I used in A5 also apply to B5, C5, and D5?
What is put your cursor on the corner of A5 until you see a plus sign, hold your mouse down and drag it down through D5.
M
e
n
u