Name: __________ Test #1



Name: __________ Test Part 1 SDL - Spread sheets __/68Use the following words to fill in the blanks. Note: Extra words have been added to make it more challenging! calculators cells cubes dollar elementary equals forks formulas labels lapels lettering locks Names Numbers Neanderthals plus whatever words A spreadsheet is made up of thousands of boxes called ________. 2. Three types of input go in a cell:a) N__________________b) W ____________ or L____________c) F _______________3. Formulas always start with a(n) __________ sign__/64. Explain one way to make the program add the dollar sign, decimal and cents (currency) automatically: (Hint: Try clicking on a certain icon.) __/15. Write a simple formula to find the sum of the values in cells C12 and C13___________________. 6. Write a formula to find the difference between cell D10 and D9.___________________. Write a formula to find the product (multiply) cell A10, A11 and A12 together.___________________. Create a formula for taking the numbers in the cell E23 and divide it by cell E24. ___________________. Write a formula to take the value in B4, and take off 14% automatically: __________________. Hint: Remember 100% - 14% = 86 % (or 0.86)__/5 What is a template?__/2 What are templates good for? (How are they helpful?)__/2 Explain how to change the Margins of your spreadsheet. __/1 To multiply two numbers together, you use the ______ key ( / # ^ x * & ) . __/1To add a column of numbers together (B2 to B8) you could create the following formula =B2+B3+B4+B5+B6+B7+B8. But that’s the long, hard way. Explain how to add these cells together a faster way: (Hint: M or Σ )__/1AB1Semester MarksJo Schmidt2Math673Science754English785Phys. Ed.856Social Studies747HIT888Average MarksNotice this small spreadsheet Create a formula that finds Jo’s Average Mark for the Semester. _________________Hint: On-line users can copy this table from Word and paste it into Excel to create a quick spreadsheet. Then use the “average” function under AutoSum. And the average mark is ________ __/2List 3 things you learned about Spread sheets, in the last few weeks: ---__/3Part 2 Find the Excel file called “Test Part 2 line graph and pie chart” and open it up. Make three graphs. Using the information at the top, create a line graph of the temperatures in five different cities. Make sure you have a title and that the headings are showing (Celsius Degrees and Months of the year AND Winnipeg, Hawaii, Vancouver, etc.) Put in formulas so Excel finds the average temperatures of each of the five cities (at the bottom row). Save a copy of this file to your student \documents \ Spreadsheets folder. Next, create a pie chart with Mel’s day. Make sure you add the title “Mel’s Day” and make the graph include the percent of each pie piece. In the column to the right, put in more accurate numbers for YOU! How you spend YOUR average school day. Create a second pie chart for that column and add a title and the % amount of each pie piece. Save it and send the folder to me with this completed Word File Call it: Last Name First Name Spreadsheet testPart 3 Creating Your Own Spread Sheet! Jone’s Java Start your own restaurant! Find out how spreadsheets can help you manage it.1. Your order form should look exactly like the Jone’s Java Junction on the LAST page. Here are some hints to make it look identical: 2. At the top, use the name Jone’s Java and add a graphic that suites.To start off, make an empty Text box on the top of the page. Go up to Insert, Text Box, and click and drag it to the size you want. Then just start typing the information into the box. When you begin typing the title “Jone’s Java ” you may notice the font size is too small! So change it to a larger size. (I used Brush Script MT size 48, BOLD, and 28 for the address.) -1543057239000 Picture time: * Click Insert; Picture; Clip Art, then type in a good word to search for. (eg. Coffee, or cup, or food, etc.) (Words must be spelled correctly for this to work.) Once you’ve found a good picture, click on it. You will probably have to adjust the size to fit your space3. All headings are bold and centered.4. Use formulas for: - subtotal- PST & GST (8% of subtotal for PST and 5% for GST)* PST in MB is now 8%- Tip of 15%- Total Bill (add subtotal, PST, GST, and Tip)- The amount each person owes (Total Bill number of people)Hint: To get your subtotal and total: You can type out a formula like this:=sum(D14:D23) or you could use the auto sum command ( ∑ ). 5. Add all the necessary borders and shading in the headings row i) First highlight the cell or cells that you want a border around.Click on Page Layout Borders. Then choose the border you want (thick, thin, double line, etc.)ii) To make borders around the titles. Highlight the cells “item” to Total.After you click on Bold and the Centre box, go up to Format; Cells; Border; (The same directions as before)iii) To make the borders around the middle part: (Use the same steps!)iv) Do the same for Subtotal down to $403.91* Also highlight Subtotal down to “Each Person Owes” and change it to Right Alignment.v) Repeat instructions for Number of People down to $20.206. Headers and footers Insert; Header & Footer; Header: Test done by ___________ ______________ your nameMake it post the date in the centerFooter: Remember to tip your servers!7. Wait a minute! Does it fit on your page? (When you try to print it?)Sometimes it’s tricky to fit your spreadsheet all onto one page. Hint: * Make the Margins smaller. In Page Layout\ Margins\ choose narrow. Once you have completed your spreadsheet, save it (on your student number). Call it Jone’s Java.Follow the directions carefully to change the values or formulas. Note: In the questions below, make only one change at a time, and then record your answer. Next, make sure you use Ctrl – Z to undo the changes. This brings back your original values before beginning the next question. Quiz _____________________ * Note: Your Total Bill should be $400.78 If it’s not, double check your work before continuing. What is the new cost per person if the number of people was increased by three?__/1What would the total cost be if you give a 20% tip? (Instead of 15%) __/1The price of the “Soup of the day” is too low! Increase that cost by $2.00 ($2 more). What effect does this have on the total bill AND on the cost per personTotal bill: $___.___. Cost per person $ ___.___. __/2How would the cost change if the PST rose by 2.5%? (2.5% more)Total Bill $__________Cost PER person. $________________/2Your Spread sheet should look something like the one BELOW: 0190500019431000 Jone's Java1234 Roblin Avenue00 Jone's Java1234 Roblin Avenue02857500ItemCost/item# OrderedTotalCheese Toast $ 3.25 4 $ 13.00 Soup of the Day $ 1.90 20 $ 38.00 Garlic Toast $ 1.75 15 $ 26.25 Small Pizza $ 6.95 12 $ 83.40 Medium Pizza $ 9.99 4 $ 39.96 Lasagna $ 8.95 6Club Sandwich $ 7.50 3Diet Coke $ 1.99 8Sprite $ 1.99 7Chocolate Milk Shake $ 2.15 3 ?Subtotal $ 313.11 ?PST ?GST $ 15.66 ?Tip $ 46.97 ?Total Bill $ 400.78 ???Number of People20?Each Person Owes $ 20.04 Total Possible points __/ 201 Mark subtracted for each error or omission. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download