一一、﹁仁一・ 15 Best BuviO 1. Format a row's f,! height in a est Buyo Co. is one of North America's specialty retailers of consumer lJelectronics, personal computers, entertainment software, and appliances. It is a company that understands the importance of learning and innovation. From personal shopping assistants and the Geek Squad to Magnolia Home spreadsheet. Theater, Test Drive, and the Small Business Center, there's a lot going on at Best Buyo. lt is a company committed to offering a broad selection of products at competitive prices. Online prices and selection generally match those in stores. The following activity illustrates how spreadsheets can be used to compute the discounted price and sales tax of Best Buy's@ Xbox 360 top selling games in 2010. ＼プ′ :NEW SK:LLI 1. Create a NEW spreadsheet. * Unless otherwise stoted, the font should be 10 point Ariol. 2. Type the data as shown. ln cell D4, type your name as the Sales Representative. 3. Format the width of column A to 65.0 and left align. 4. Bold cell 42 and change the font size to 14 point. 5. Bold rows 7 and 8. 6. Format the width of columns B - F to 10.0 and right align. 7. Bold cells C2 and C4 - D4 and left align. 8. Select rows L0 - 26 and change the row height to L8.0. 9. Compute the formulas for the first Xbox 360 game as follows (assume the sales tax is 6.75%): a. SALE PRICE=LIST PRICE-DISCOUNT b. SALES TAX=SALE PRICE*6.75% -> ln cell -> ln cell E10, D10, type =-r1-1-C13 type =D1A*5.75/c G. FINAL PRICE=SALE PRICE+SALES TAX -> ln cell F10, type =D1C..I1I イ 10. 11. ￨ Format cells 810 - F25 as numbers displaying 2 decimal places. Use the AutoFill feature to copy the formulas down for the remaining Xbox games. ￨‐ 12. 'to check for accuracy. ︲﹂Ｅ、︵︵４︶一︵／ｔ Excer″ Display formulas in your spreadsheet by using <CTRL> ﹂︱・日 Best BuYQ 。。。３４５６。 ■ 15 Carefully proofread your work for accuracy. Save the spreadsheet as BEST BUy. Analyze the changes made to the data in the spreadsheet. Set the Print Area to include all cells containing data in the spreadsheet. Print Preview and adjust the page setup so that the spreadsheet fits on one page. Set the Page Orientation to Landscape. Print a copy of the spreadsheet if required by your instructor. ｀ Excer‖ ‘ ︶﹂ ´ ｔ一一 ´ 一 ´ 一一一一＾■ 一ｒ ´ 口 ″ ′ ＾イ ´ ア＾ｒ ″ ｒｒマ ι ・ /「 1 2 3 4 5 L Activity 15 Student Name BEST BUY Grove-Ohb tttOre 292) 3720 Grove Road Columbus,OH 43212 __ B I _________― ― ― ―J ￨ ― ―― 1 XBOX 360 GAMES IPRICE ０一︲ Batman: Arkham Asylum Game of the Year Cabe!a:s Big Game Hunter 2010 Drsney/P]xar Toy Story 3 Fight Night: Round 4 ２２３一２ (1つ 7.00 49.99 18.00 39 99 4999 1999 3999 19.99 39.99 2999 2999 5999 2999 19.99 3999 201 Student's Na me ￨￨ SALES TAX FINAL PRICE 1650 1800 200 1650 200 1650 700 700 2050 7.00 2.00 16.50 29.99 7.00 5999 3999 20.50 1650 己吻４５６一一２２２ Source: http://www.bestbuy.com 1 2999 9/30′ F 一一一 Forza Motorsport 3 Ghostbusters: The Video Game Hasbro Family Game Night 3 James Cameron's Avatar: The Game Madden NFL 10 20 NCAA Basketball 10 21 Rock Band 2 Skate 2 Super Street Fighter lV The Beatles; Rock Band Trinsformers: War for Cybertron UFC Undisputed 2010 Edition I E 一一一 12 13 14 15 16 17 18 19 I SALE DISCOUNT PRiCE IL:ST ︱トー９ 8 I D XBOX 360 G AMES ON SノヽLE Saleg Rep: 6 7 C ︺紗曖釘籟斜≪＠一Ｚつ⊂ ﹁０ ” ↓” じ６Ｑミ A