Spreadsheet
Another name for a Spreadsheet in Excel would be?
Workbook
Draw the button used to find the sum.
What is teacher checked.
What button do I click on to create a chart?
Chart Button
What layout or design might be chosen in Excel to keep a record of products a business might have?
Inventory.
To selct more than one cell at a time, what must you do?
Click the mouse and drag over the cells needed.
The cell you are currently using is called?
Active cell.
What must be at the front of a formula?
Equal sign
What must I do to create a chart based on information you have input into your spreadsheet?
Select the information needed, select charts, select the type of chart, and click ok.
What design or template might a teacher use to help keep track of how students score on assignments?
Gradebook.
To add a grid line only around the cells you would like to have selected, what would you do?
Select the cells needed, click the arrow next to the gridline button, and then select the outline button.
When writing in a cell, the verbage also appears in the?
formula bar.
What 2 ways could you use a formula to add cells A2, B2, C2, and D2?
Select those cells and plug in the sum formula or sum key or click on cell E2 and write =A2+B2+C2+D2
What should be done to change the titles/labels in a chart?
Double click on the information you would like to change and then type.
Name 3 ways that Excel could be used other than the obvious.
Receipts, calendar, shopping list, etc.
What steps would I follow to make my page landscape?
Page layout, Orientation, and the Landscape.
What cell would be 6 to the right and 5 down?
Cell F5
How would I write the formula for a 6% sales tax of $325.00?
=6%*325.00 or 0.06*325.00
Where would you go to change the look of your chart so that the title and labels might be in a different place?
Go to chart layout and choose the design that fits your chart's needs.
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.
Explanation judged by teacher.
What is the fastest way to make everything center-alligned and then bold only items in row 1?
Select the corner select all button, go to Home, and click the center align. Select the 1 and click B for bold.
If I were in cell R7 and moved 4 to the left, 3 down, and then 6 to the right, what cell would I be in?
Cell T10
How would you figure out the average of cells A1 - A5?
Select those cells and then click Average or write Average=A1:A5
Tell what you would need to do to format the details of your chart and then name at least 4 details that can customize your chart.
Double click on the chart or go to formatting. Change, color, size, gradient, texture, pattern, etc.
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?
Explanation judged by teacher.
How do I make the formula I used in A5 also apply to B5, C5, and D5?
Put your cursor on the corner of A5 until you see a plus sign, hold your mouse down and drag it down through D5.