In-Class Excel - Day 6 - Worksheet

.xlsx

School

Northern Illinois University *

*We aren’t endorsed by this school

Course

394

Subject

Information Systems

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by DrGooseMaster987

Project 1 Questions 1 On the “Computer Sales” worksheet, change the data validation error message for cells C11:N22 to “ 2 3 To see Project Questions on each sheet, expand rows 1-4 On the “Computer Sales” worksheet, in cells O11:O22, create a conditional formatting rule that uses in Yellow, the midpoint in Light Green, and the maximum in Green. On the “PivotTable & PivotChart” worksheet, in the PivotTable, create a calculated field named “Cha from the December data.

“Please enter a number from 0 to 100,000” a 3-Color Scale format style to display the minimum ange” that displays the January sales data subracted

To see Project Questions on each sheet, expand rows 1-4 Computer Sales Category Store Location Jan Feb Ma Apr Desktop Downtown $ 22,896 $ 19,369 $ 18,765 $ 19,876 Desktop University $ 9,333 $ 11,345 $ 10,789 $ 9,876 Desktop MegaMall $ 21,987 $ 17,654 $ 16,789 $ 18,765 Laptop Downtown $ 21,112 $ 22,555 $ 30,123 $ 18,375 Laptop University $ 12,098 $ 13,238 $ 11,680 $ 10,852 Laptop MegaMall $ 20,864 $ 21,580 $ 15,987 $ 17,642 Notebook Downtown $ 3,015 $ 7,200 $ 8,525 $ 18,463 Notebook University $ 7,654 $ 9,876 $ 9,812 $ 15,876 Notebook MegaMall $ 4,567 $ 4,532 $ 6,543 $ 12,567 Tablet Downtown $ 25,432 $ 26,789 $ 27,890 $ 31,234 Tablet University $ 27,654 $ 20,976 $ 19,087 $ 27,654 Tablet MegaMall $ 24,567 $ 27,897 $ 28,765 $ 32,876 Jan Feb Ma Apr May June Jul Aug Sept Oct Nov Dec $- $5,000 $10,000 $15,000 $20,000 $25,000 $30,000 $35,000 $40,000 Downtown Sales Trend Desktop Laptop Notebook Tablet

May June Jul Aug Sept Oct Nov Dec $ 27,543 $ 28,765 $ 15,420 $ 20,989 $ 21,345 $ 17,650 $ 16,875 $ 25,080 $ 10,987 $ 10,766 $ 3,456 $ 5,432 $ 10,987 $ 11,098 $ 9,876 $ 10,988 $ 22,356 $ 25,987 $ 14,356 $ 20,987 $ 22,345 $ 16,789 $ 16,543 $ 22,345 $ 25,768 $ 26,123 $ 14,876 $ 22,987 $ 25,876 $ 16,789 $ 15,674 $ 27,098 $ 12,862 $ 11,567 $ 4,567 $ 6,543 $ 11,753 $ 13,678 $ 10,756 $ 12,631 $ 22,689 $ 24,765 $ 15,832 $ 19,753 $ 21,579 $ 15,982 $ 15,985 $ 26,518 $ 24,173 $ 27,345 $ 13,273 $ 21,345 $ 24,098 $ 18,039 $ 17,987 $ 28,756 $ 22,156 $ 24,311 $ 5,432 $ 7,654 $ 21,008 $ 18,654 $ 15,875 $ 12,543 $ 22,345 $ 21,567 $ 10,876 $ 12,567 $ 14,678 $ 16,784 $ 15,467 $ 21,786 $ 33,456 $ 35,213 $ 23,456 $ 33,456 $ 31,234 $ 23,098 $ 21,345 $ 37,890 $ 20,987 $ 25,778 $ 6,432 $ 4,321 $ 16,789 $ 12,654 $ 10,987 $ 13,876 $ 34,876 $ 37,654 $ 22,345 $ 34,567 $ 31,765 $ 21,345 $ 22,345 $ 33,098

Total $ 254,573 $ 114,933 $ 236,903 $ 267,356 $ 132,225 $ 239,176 $ 212,219 $ 170,851 $ 164,279 $ 350,493 $ 207,195 $ 352,100

To see Project Questions on each sheet, expand rows 1-4 Row Labels Sum of Jan Sum of Dec Desktop 54216 58413 Laptop 54074 66247 Notebook 15236 63085 Tablet 77653 84864 Grand Total 201179 272609 Desktop Laptop 0 50000 100000 150000 200000 250000 300000

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help