super-alan-3-us-blog

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=In-this-Excel-project%2C-you-will-create-a-new-worksheet-that-compares-annual-sales-by-region

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_1G_Regional_Sales

Excel_1G_Regional_Sales

Project Description:

In this Excel project, you will create a new worksheet that compares annual sales by region.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=You-are-the-IT-Tech-Support-Manager-at-a-university.-Your-tech-support-staff-log-each-call-to-document-dates%2C-computer-numbers%2C-descriptions-of-the-issues%2C-and-other-details

Lab Prep 5

Project Description:

You are the IT Tech Support Manager at a university. Your tech support staff log each call to document dates, computer numbers, descriptions of the issues, and other details. You downloaded a report into a spreadsheet and noticed some data should be formatted better. In addition to formatting data, you are interested in one technical support staff’s records for solving a particular problem. You will use advanced database filtering and database functions to analyze the data. Furthermore, you want to be able to enter a computer number and find the description using lookup functions.

[super-alan-3-us-blog]

Excel_1B_Plyo_Products

Project Description:

Create a workbook to calculate the retail value of an inventory of plyometric training products.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_1B_Plyo_Products

Excel_1B_Plyo_Products

Project Description:

Create a workbook to calculate the retail value of an inventory of plyometric training products.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=In-this-project%2C-you-will-format-numbers-and-create-formulas-using-absolute-cell-references.-You-will-insert-statistical-functions.-You-will-also-create-and-format-charts

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_02_SA_Debt_HW

Excel_02_SA_Debt_HW

Project Description:

In this project, you will format numbers and create formulas using absolute cell references. You will insert statistical functions. You will also create and format charts, and add WordArt to a worksheet.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=You-and-a-business-partner-opened-a-fitness-gym-three-years-ago.-Your-partner-oversees-managing-the-operations-of-the-gym%2C-ensuring-the-right-equipment-is-on-hand

Exp19_Excel_Ch03_Cap_Gym

Project Description:

You and a business partner opened a fitness gym three years ago. Your partner oversees managing the operations of the gym, ensuring the right equipment is on hand, maintenance is conducted, and the appropriate classes are being offered with the right trainers and staff. You oversee managing the business aspects, such as marketing, finance, and general personnel issues. The business is nearing the end of its third year. You have put together the financials, and now you want to show the data more visually because you know it will make more sense to your business partner that way. You want to create charts and insert sparklines that show the trends to discuss with your partner.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Create-an-Excel-worksheet-that-displays-the-second-quarter-sales-of-cardio-equipment-for-the-current-year%2C-and-include-a-chart-to-visually-represent-the-data

Excel_1A_Quarterly_Sales

Project Description:

Create an Excel worksheet that displays the second quarter sales of cardio equipment for the current year, and include a chart to visually represent the data.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_1A_Quarterly_Sales

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=In-the-following-activities-you-will-edit-a-worksheet-for-Holeman-Hill%2C-President%2C-detailing-the-current-inventory-of-trees-at-the-Pasadena-nursery

Excel_2A_Tree_Inventory

Project Description:

In the following activities you will edit a worksheet for Holeman Hill, President, detailing the current inventory of trees at the Pasadena nursery.

Steps to Perform:

Step

Instructions

Points Possible

1

Open the Excel workbook Student_Excel_2A_Tree_Inventory.xlsx downloaded with this project. Then, in your textbook, turn to Project 2A and complete all of the steps in Activities 2.01-2.20.

02

Complete Activity 2.01

10

3

Complete Activity 2.02

5

4

Complete Activity 2.03

6

5

Complete Activity 2.04

5

6

Complete Activity 2.05

5

7

Complete Activity 2.06

3

8

Complete Activity 2.07 Note, if necessary, after rotating the text, reapply the formatting from steps 2 and 3 of the activity.

9

9

Complete Activity 2.08

5

10

Complete Activity 2.09

5

11

Complete Activity 2.10

5

12

Complete Activity 2.11

10

13

Complete Activities 2.12 & 2.13

5

14

Complete Activity 2.14

4

15

Complete Activity 2.15

10

16

Complete Activity 2.16

4

17

Complete Activity 2.17 - 2.19 NOTE: If the Slice theme is not available, on the Layout tab, in the Themes group, click Themes. On the Page Layout tab, in the Themes group, click Themes,  and then click Browse for Themes. Browse to the files you downloaded with this project. Click Slice.thmx, then click Open.

4

18

Complete Activity 2.20

5

19

Save and close the file, and then submit for grading.

0Total Points

100

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_2A_Tree_Inventory

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=In-the-following-project%2C-you-will-edit-a-worksheet-detailing-the-current-inventory-of-Marisol-Desserts-and-Spices-Austin-facility

Excel_2E_Dessert_Inventory

Project Description:

In the following project, you will edit a worksheet detailing the current inventory of Marisol Desserts and Spices Austin facility.

Steps to Perform:

Step

Instructions

Points Possible

1

Open the Excel workbook Student_Excel_2E_Desserts_Inventory_AS.xlsx downloaded with this project.

02

To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Item Name in column D. Be sure that Item # and Item Name display as the column headings, and then delete column B.

1

3

By using the Cut and Paste commands, cut column D—Category—and paste it to column H, and then delete the empty column D. Apply AutoFit to columns A:G.

0.2

4

In cell B4, insert a function to calculate the Total Items in Stock by summing the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.

0.5

5

In the appropriate cells in the range B5:B8, insert functions to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format to each result.

1

6

Move the range A4:B8 to the range D4:E8, apply the 20% - Accent4 cell style to the range, and then select columns D:E and AutoFit.

0.4

7

In cell C6, type Statistics and then select the range C4:C8. From the Format Cells dialog box, merge the selected cells, and change the text Orientation to 25 Degrees.

0.6

8

Format cell C6 with Bold and change the Font Size to 14 pt. Apply Middle Align and Align Right.

1

9

In the Category column, Replace All occurrences of Pastries with Danish.

0.2

10

In cell B10, use the COUNTIF function to count the number of Cake dessert types in the Category column.

0.5

11

In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50 the Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the formula down through cell H42.

0.7

12

Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic, a font color using in the eighth column, the first color, and the Fill color set to No Color.

0.6

13

Apply conditional formatting to the Quantity in Stock column by applying a Gradient Fill Blue Data Bar.

0.6

14

Format the range A13:H42 as a Table with headers, and apply the style White, Table Style Light 18. If the style is not available, choose a similar style. Sort the table from A to Z by Item Name, and then filter on the Category column to display only the Cake types.

0.8

15

Display a Total Row in the table, and then in cell A43, Sum the Quantity in Stock for the Cake items. Type this same result in cell B11. Click in the table, and then on the Design tab, remove the total row from the table. Clear the Category filter.

0.8

16

Merge & Center cell A1 across columns A:H and apply the Title cell style. Merge & Center cell A2 across columns A:H, and apply the Heading 1 cell style. Change the theme to Ion, and then select and AutoFit all the columns. If the Ion theme is not available, click Browse for Themes and navigate to the files you downloaded with this project. Click Ion_Theme.thmx and then click Open.

0.7

17

Set the orientation to Landscape. From the Page Setup dialog box, center the worksheet Horizontally, and set row 13 to repeat at the top of each page.

0.2

18

Insert a custom footer in the left section with the file name and scale the worksheet so that the Width fits to 1 page.

0.2

19

Save and close the file, and then submit for grading.

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=Excel_2E_Desserts_Inventory_AS

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=NP_EX_5_Tibetan-%28solution%29

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=NP_EX_3_claims-%28solution%29

[super-alan-3-us-blog]

http://www.thestudentsoffortune.com/products.php?product=NP_EX_2%252d1-%28solution%29