# Excel Case Problems

Anonymous

### Question Description

Week 1 Assignments

Perform the following Case Problems for Excel Chapters 1. Submit your final solution workbooks under Wk1 Assignments

Excel Case Problems• Complete and solve these case problems:

o Case Problem Level 1: Filename: Computer Purchase.xlsx (See pp. 72-74)

o Case Problem Level 2: Filename: Job Analysis.xlsx (See pp. 74-75)

o Case Problem Level 3: Filename: CKG Sales.xlsx (See pp. 75-76)

Textbook: (2016). Succeeding in business with microsoft excel 2013: a problem solving approach

Authors: Gross, D., Akaiwa, F., & Nordquist, K. Publisher: Stanford, CT: Cengage Learning. ISBN: 978-1-28-509914-9

8 hours ago

FYI

Excel Chapter 1 - Applying Fundamental Excel Skills and Tools in Problem Solving

Everyone will know that they have mastered the material in the Excel textbook for Chapter 1 as they navigate through each level and are able to:

Level 1

• Define common Excel error messages
• Correct basic formatting problems in a worksheet
• Correct errors in formulas
• Understand precision vs. display of cell values
• Level 2

• Work with multiple worksheets
• Calculate total, average, minimum, and maximum values with functions
• Understand how functions work: syntax, arguments, and algorithms
• Use the AutoSum feature to perform calculations quickly
• Calculate the number of values using both COUNT and COUNTA
• Level 3

• Organize a workbook
• Understand relative, absolute, and mixed cell referencing
• Write formulas with different types of cell references
• Copy formulas with different types of cell references
• Name a cell or cell range
• ### Unformatted Attachment Preview

Purchase answer to see full attachment

pallveechem123
School: Boston College

Please find attached the complete work. Kindly update in case of any confusion

Computer Price Comparison
Laptops
features

Dell Laptop

Sony Laptop Lenovo Laptop

Processor and
processor speed
RAM
HARD Drive
Display
DVD Features

SonVAIO
Dell Latitude E65
BZ56
Intel Core 2
Intel Core 2 Duo
Duo
Processor,
Processor,
2.53GHz
2.53GHz
3 GB
2 GB
250 GB
250 GB
15"
15.4"
DVD r/w
DVD r/w

Battery
Camera and
accessories

Long life battery
video camera
and video card

builit in
camera

video card

Windows 7
Proffessional

Windows 7
Proffessional

Model Name

Windows Version

Connectivity

Wifi/Bluetoo
Wifi/Bluetooth/
th/

Lenovo Think Centre W5

Intel Core 2 Duo Processor,
2.53GHz
2 GB
150 GB
15.4"
DVD recordable device
-

3 year warranty
incl. Shipping
\$
1,749.00
-

Warranty
Basic Rate
Processor
RAM
HARD Drive
Windows 8 Pro
Camera Built in
Bluetooth Collection
Long Life Battery
DVD Recordable DeviceVideo Card
Full 3 year warranty Carrying Case
\$
Shipping
Total

1 year
warranty
1 year warranty incl. Shipping
\$ 1,449.00 \$
1,104.00
\$
130.00
\$
59.99 \$
60.00
\$
69.00 \$
29.00
\$
30.00
\$ 149.00 \$
70.00
\$
115.00
\$ 249.99 \$
195.00
79.95 \$
65.00
46.00 -

1828.95

2022.98

1798.00

Discounts offered
Rebate

18%
Discount on
Rebate of \$150
everything
per machine
but shipping No Discount
150
355.8564 -

Cost of one compute...

flag Report DMCA
Review

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
I did not know how to approach this question, Studypool helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors