In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Apply the Currency number format to cell B9. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argument.ĥ. In cell B9, enter a formula to calculate the average sales per month for the truck locations. Apply borders using the Thick Outside Borders option around cells A6:B7.Ĥ. Help calculate whether it is a good idea for the company to make the purchase.Ģ. Top’t Corn is considering a new truck purchase. Change the printing scale so all columns will print on a single page.ġ0. Change the margins to the preset narrow option.ģ. Change the orientation so the page is wider than it is tall.Ģ. Preview the worksheet again when you are finished to check your work.ġ. Hint: If you have one of the charts selected, deselect it before previewing the worksheet. Preview how the worksheet will look when printed, and then apply print settings to print the worksheet on a single page. If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned.ĩ. Display the chart data labels using the Outside End option.ĥ. Change the chart title to: August Sales by Popcorn TypeĤ. If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis.Ģ. Note: You must complete this step correctly in order to receive points for completing the next step.ġ. ![]() Insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location. Move the chart so it appears below the sales data.ħ. Note: You must complete this step correctly in order to receive points for completing the next step. Each piece of the pie should represent the Old Bay sales for a single location. Insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Apply the Total cell style to cells A7:E7.ĥ. Use AutoFill to copy the formula to cells C7:E7.Ĥ. Enter a SUM function in cell B7 to calculate the total of cells B4:B6.ģ. Calculate total sales for each of the truck locations.Ģ. Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.Ĥ. Apply the Heading 1 cell style to cell B2.ĩ. Merge and center the worksheet title across cells A1:E1.Ħ. Use the first color at the left in the first row of Theme colors.ĥ. Apply the White, Background 1 font color to cell A1. Use the first color at the right in the row of Standard colors.Ĥ. Verify you are on the MobileSales worksheet.Ģ. Change the project file name if directed to do so by your instructor, and save it.ġ. The file will be renamed automatically to include your name. Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it.Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |