Document 121532

一一
、
﹁仁
一・
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'[email protected] 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.
︲
﹂
E
、
︵
︵
4
︶
一
︵
/
t
Excer″
Display formulas in your spreadsheet by using <CTRL>
﹂
︱
・ 日
Best BuYQ
。 。 。
3 4 5 6。 ■
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‖
‘ ︶ ﹂ ´ t 一 一 ´ 一 ´ 一 一 一 一 ^■ 一 r ´ 口 ″ ′ ^ イ ´ ア ^ r ″ r rマ
ι ・
/「
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
0
一
︲
Batman: Arkham Asylum Game of the Year
Cabe!a:s Big Game Hunter 2010
Drsney/P]xar Toy Story 3
Fight Night: Round 4
2
2
3
一
2
(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
己吻
4 5 6
一 一
2 2 2
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
︱ト ー
9
8
I
D
XBOX 360 G AMES ON Sノ ヽLE
Saleg Rep:
6
7
C
︺紗曖釘籟斜≪@
一
Z つ⊂ ﹁ 0 ” ↓”
じ6Q ミ
A