Excel_Introductory_Capstone2_Annual_Report | Excel Introductory Annual Report | @PearsonSolution

#Excel_Introductory_Capstone2_Annual_Report #Capstone2_Annual_Report #Annual_Report #Introductory_Capstone2 #Excel_Intro_Cap2_Annual_Report.xlsx #Annual_Report.xlsx #Intro_Cap2_Annual_Report #Exp19_Excel #Excel_Introductory_Capstone2_Annual_Report #Capstone2_Annual_Report #Introductory_Capstone2_Annual_Report #Capstone2
#Excel_2019_Project #Excel_Introductory_Capstone2_Capstone2 #Exp19_Excel #Excel_Introductory_Capstone2_Capstone2
#Excel_Intro_Cap2_Capstone2.xlsx
Contact
WhatsApp 1: +923137183201
WhatsApp 2: +923458962216
Email:: : pearsonsolutions653@gmail.com
Direct WhatsApp link
Link : https://wa.me/923137183201

#Excel_Introductory_Capstone2_Annual_Report #Capstone2_Annual_Report #Annual_Report #Introductory_Capstone2 #Excel_Intro_Cap2_Annual_Report.xlsx #Annual_Report.xlsx #Intro_Cap2_Annual_Report #Exp19_Excel #Excel_Introductory_Capstone2_Annual_Report #Capstone2_Annual_Report #Introductory_Capstone2_Annual_Report #Capstone2
#Excel_2019_Project #Excel_Introductory_Capstone2_Capstone2 #Exp19_Excel

Excel_Introductory_Capstone2_Annual_Report

Project Description:
In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

Steps to Perform:
Step Instructions Points Possible
1 Open the Excel file named Student_Excel_Intro_Cap2_Annual_Report.xlsx downloaded with this project. 0
2 On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9.
@PearsonSolution
@PearsonSolution
@PearsonSolution
3 Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Texas Total is of Total Sales, and then apply Percent Style.
insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Add Markers and then in the first row, apply the first Sparkline style. 4
5 Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Apply chart Style 6. As the chart title, type Quarterly Net Sales by State 10
Insert a 3-D Pie chart, and then move the chart to a New sheet. Name the sheet Net Sales Chart.
Remove the Legend from the chart, and then add Data Labels that display only the Category Name and Percentage positioned in the Center.
8 Select the entire pie and display the Format Data Series pane. From the 3-D Format gallery, modify the 3-D options by changing the Top bevel and Bottom bevel to the first bevel option in the first row. Set all of the Width and Height boxes to 256 and then change the Material to the fourth Standard type—Metal. 2
10 On the Portland Inventory worksheet, in cell B5, enter a function that will display the average retail price.
in cell G14, enter an IF function to determine the items to be ordered.
@PearsonSolution
@PearsonSolution
@PearsonSolution
insert a COUNTIF function
14 Add Gradient Fill Blue Data Bars to the range A14:A19. Add conditional formatting to the range G14:G19 so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item # from Smallest to Largest. 3
In cell B4, enter a formula that references cell B4 in the Portland Inventory sheet so that the Portland Total Items in Stock displays in cell B4.
construct formulas to calculate Totals by Quarter in the range B10:E10 and the Annual Totals in the range F5:F10.
@PearsonSolution
@PearsonSolution
@PearsonSolution
19 Using the data in the nonadjacent ranges A4:E4 and A10:E10, insert a Line with Markers chart.
20 Apply chart Style 3. Change the chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the Minimum is 6000000. 4
21 Use Format Painter to copy the formatting from cell A2 to A20. In cell B23, enter a formula that references the value in cell F10. 2
22 Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2021 after the Forecasted increase in cell B21 is applied.
By using Flash Fill and deleting columns as necessary, place the last names in column A and the first names in column B. Widen both columns to 100 pixels, and then merge and center the title Sales Reps across the two columns. Apply the Heading 1 cell style to the title. 4
24 With any sheet except the chart sheet active, group the worksheets. Change the Orientation to Landscape, center the worksheets Horizontally,
#Exp19_Excel_App_Cap_Comp_Tech_Store
#Exp19_Excel_Ch06_CapAssessment_Delta_Paint
#Exp22_Word_Ch01_HOE_Job
#Exp22_Word_Ch04_CumulativeAssessment_Retirement
#exp19_word_ch04_cap_college
#Exp19_Excel_AppCapstone_CompAssessment_Manufacturing
#Excel_2E_Dessert_Inventory
#Exp19_Access_App_CapAssessment_Student_Loans_1.0

Видео Excel_Introductory_Capstone2_Annual_Report | Excel Introductory Annual Report | @PearsonSolution канала Pearson Solutions