New Perspectives Excel 2019 | Module 1: SAM Critical Thinking Project 1c #newperspectives #module1
If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
[ Ссылка ]
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
1. "As the office administrator, you use Excel to maintain personnel data and summarize cash flow. You are finalizing the Personnel and Cash Flow worksheets for the current week.
The Personnel worksheet needs cleaning up. Start by moving the two cells of title information one column to the left. Resize the column to best fit the newly included information."
Cut and paste a range of values.
Change the column width.
2. Change the width of the column containing salaries to match the width of the column containing commissions.
Change the column width.
3. The salary and commission columns need to be completed. Enter the data shown in Table 1 in the appropriate cells.
Enter values in a range.
4. The emails need to be filled in as well. Start by entering albert.luna@cengage.com in the corresponding cell. Fill the remaining emails using Flash Fill.
Enter text in a cell.
Use Flash Fill.
5. The column containing emails could use a bit more space at the sides. Change the width to 36.00.
Change the column width.
6. The employee information table also needs show the total salary and total commission. Start by entering the word Total under the final employee name.
Enter text in a cell.
7. Use a function to calculate the total salaries in the appropriate cell. Use the same function to calculate the total commissions.
Create a formula using a function.
Copy a formula into a cell.
8. To finish up the worksheet, it should also show the total number of employees, as well as the average commission. Start by entering Number of Employees in the top left shaded cell below the employee information table, and Average Commission in the bottom left shaded cell.
Enter text in a cell.
Enter text in a cell.
9. Use a function to count the number of employees in the top right space to complete the worksheet.
Create a formula using a function.
10. The Cash Flow worksheet also needs to be completed. Begin by changing its orientation to Landscape.
Change the orientation of a worksheet.
11. Add Cash Flow: before the date to mirror the title information on the Personnel worksheet.
Update a value in a cell.
12. The font for the table headers and the note should be larger. Increase the font size of each to 12 points.
Change the font size.
Change the font size.
13. To better display the content, decrease the height of row 3 to 8.00.
Change the row height.
14. Determine the profit generated from auto insurance policies by subtracting auto expenses from auto sales. Use a similar formula to show the profit for home and life insurance policies.
Create a formula without a function.
Copy a formula into a range.
15. After determining the total profits generated by each store, you are now interested in calculating the total sales, expenses, and profits across all types of insurance sold. Use a function to calculate the totals for these categories across all three types of insurance.
Create a formula using a function.
16. Since you just edited the worksheet, cell A9 is no longer accurate. Remove the text.
Clear cell contents.
17. Wrap the text of the remaining note to display multiple lines in a single cell.
Wrap text in a cell.
18. Change the Zoom level of the Cash Flow worksheet to 130%.
Zoom a worksheet.
19. After reviewing the Personnel and Cash Flow worksheets, you typically generate some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting, and if necessary, move the new worksheet after the Cash Flow worksheet.
Add a new worksheet.
Move a worksheet.
new perspectives excel 2019 | module 1: end of module project 2,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 7: end of module project 1,new perspectives excel 2019 | module 10: sam project 1b,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 module 2 end of module project 1,new perspectives excel 2019
![](https://i.ytimg.com/vi/V--RjZ-V8lw/maxresdefault.jpg)