To Do:Assessments 1, 2, 3, 4CMR 282 Module 13 textbook assignmentsActionsSubmit the following files:8-NationalLicenses.xlsx8-NationalLicenses-2.xlsx8-PreMfgTargets.xlsx8-HR2021Sales.xlsx8-HR2021Sales.docxCMR 282
Chapter 8 – Module 13
Assessment 1: Enter and Display Workbook Properties
1. Open NationalLicenses.
2. Save the workbook with the name 8-NationalLicenses.
3. Type the following text in the appropriate workbook property boxes:
Add an Author: Wendy Cheung
Title: MSO 365 License Chargeback
Subject: Journal Entry by Department
Categories: JE supporting document
Status: Posted
Comments: Audit worksheet for Office 365 site license with internal
chargebacks
4. Remove the existing author, Paradigm
5. Save and then close 8-NationalLicenses
Assessment 2: Protect an entire worksheet
1. Open 8-NationalLicenses
2. Save the workbook with the name 8-NationalLiecnses-2
3. Protect the worksheet using the password eL2-8
4. Add the password eL2-8 to open the workbook
5. Save and then close 8-NationalLiecnses-2
6. Open 8-NationalLiecnses-2 and test the password
7. Close 8-NationalLiecnses-2
8.
Assessment 3: Unlock Cells and Protect a Worksheet and Protect a Workbook
Structure
1.
2.
3.
4.
Open PreMfgTargets.xlsx.
Save the workbook with the name 8-PreMfgTargets
Select the range C4:F21 and unlock the cells.
Deselect the range and then protect the worksheet using the password eL2-8 to
unprotect.
5. Protect the workbook structure to prevent users from inserting, deleting, or
renaming sheets using the password eL2-8 to unprotect.
6. Save and then close 8-PreMfgTargets
Assessment 4: Prepare a Workbook for Distribution
1. Open HR2021 Sales.
2. Save the workbook with the name 8-HR2021 Sales.
3. Run the Accessibility Checker and correct any issues in the Errors section. Also
make any changes needed in response to the Hard-to-read Text Contrast
warning. Close the Accessibility Checker task pane.
4. Display the Info backstage area and show all the properties. Read the
information in the Author, Title, and Subject property text boxes. Open the
Advanced Properties dialog box and then read the information on the Statistics
and Custom tabs. Close the Properties dialog box. Click the Back button and
then click the Review tab.
5. Turn on the display of all notes and then read the notes that appear.
6. Change to Page Layout view and check for a header or footer in the workbook.
7. Use the Document Inspector to check the workbook for private data and hidden
information. Leave all the options selected at the Document Inspector dialog box.
8. Remove all the items that display with red exclamation marks and then close the
dialog box.
9. Click the Review tab, click the Show All Notes option to turn it off, and then
switch to Normal view.
10. Click the File tab and then click the Info option. Click the hyperlink to allow
information to be saved in the file. With the Info backstage area displayed and
showing all the properties, paste a screen image into a new Word document
using the Windows key + Shift + S with Paste or the Screenshot feature. Type
your name a few lines below the screen image. Save the file as 8-HR2021
Sales.docx
11. Run the Compatibility Checker to check for loss of functionality or fidelity in the
workbook if saved in an earlier Excel version. Save the Compatibility Report to a
new sheet.
12. Mark the workbook as final.
13. Save and Close 8-HR2021 Sales.
CMR 282
Chapter 8 – Module 13
Assessment 1: Enter and Display Workbook Properties
1. Open NationalLicenses.
2. Save the workbook with the name 8-NationalLicenses.
3. Type the following text in the appropriate workbook property boxes:
Add an Author: Wendy Cheung
Title: MSO 365 License Chargeback
Subject: Journal Entry by Department
Categories: JE supporting document
Status: Posted
Comments: Audit worksheet for Office 365 site license with internal
chargebacks
4. Remove the existing author, Paradigm
5. Save and then close 8-NationalLicenses
Assessment 2: Protect an entire worksheet
1. Open 8-NationalLicenses
2. Save the workbook with the name 8-NationalLiecnses-2
3. Protect the worksheet using the password eL2-8
4. Add the password eL2-8 to open the workbook
5. Save and then close 8-NationalLiecnses-2
6. Open 8-NationalLiecnses-2 and test the password
7. Close 8-NationalLiecnses-2
8.
Assessment 3: Unlock Cells and Protect a Worksheet and Protect a Workbook
Structure
1.
2.
3.
4.
Open PreMfgTargets.xlsx.
Save the workbook with the name 8-PreMfgTargets
Select the range C4:F21 and unlock the cells.
Deselect the range and then protect the worksheet using the password eL2-8 to
unprotect.
5. Protect the workbook structure to prevent users from inserting, deleting, or
renaming sheets using the password eL2-8 to unprotect.
6. Save and then close 8-PreMfgTargets
Assessment 4: Prepare a Workbook for Distribution
1. Open HR2021 Sales.
2. Save the workbook with the name 8-HR2021 Sales.
3. Run the Accessibility Checker and correct any issues in the Errors section. Also
make any changes needed in response to the Hard-to-read Text Contrast
warning. Close the Accessibility Checker task pane.
4. Display the Info backstage area and show all the properties. Read the
information in the Author, Title, and Subject property text boxes. Open the
Advanced Properties dialog box and then read the information on the Statistics
and Custom tabs. Close the Properties dialog box. Click the Back button and
then click the Review tab.
5. Turn on the display of all notes and then read the notes that appear.
6. Change to Page Layout view and check for a header or footer in the workbook.
7. Use the Document Inspector to check the workbook for private data and hidden
information. Leave all the options selected at the Document Inspector dialog box.
8. Remove all the items that display with red exclamation marks and then close the
dialog box.
9. Click the Review tab, click the Show All Notes option to turn it off, and then
switch to Normal view.
10. Click the File tab and then click the Info option. Click the hyperlink to allow
information to be saved in the file. With the Info backstage area displayed and
showing all the properties, paste a screen image into a new Word document
using the Windows key + Shift + S with Paste or the Screenshot feature. Type
your name a few lines below the screen image. Save the file as 8-HR2021
Sales.docx
11. Run the Compatibility Checker to check for loss of functionality or fidelity in the
workbook if saved in an earlier Excel version. Save the Compatibility Report to a
new sheet.
12. Mark the workbook as final.
13. Save and Close 8-HR2021 Sales.
National Online Marketing Inc.
Computing Services Department
Software License Chargebacks for Microsoft Office 365
Unit cost per license $
Department
Accounting
Executive Administration
Finance
Human Resources
Graphics Design
Electronic Production
Marketing
Web Programming
Planning and Development
President’s Office
Purchasing
TOTAL
229,99
Quantity
135
18
110
152
96
221
65
93
37
28
95
1.050
Proof Total
1,050 licenses x $229.99 = $ 241.489,50
Chargeback Dept Code Journal Entry
$
$
31.048,65
4.139,82
25.298,90
34.958,48
22.079,04
50.827,79
14.949,35
21.389,07
8.509,63
6.439,72
21.849,05
241.489,50
225
216
166
187
210
350
452
284
310
105
243
158352
158353
158354
158355
158356
158357
158358
158359
158360
158361
158362
Precision Design and Packaging
Bulk Container 2021 Manufacturing Units
(in thousands)
Model
Number
PD-1140
PD-2185
PD-1150
PD-1155
PD-3695
PD-3698
PD-3699
PD-4100
PD-4200
PD-4415
PD-5367
PD-6418
PD-7459
PD-8854
PD-9101
PD-9105
PD-9110
PD-9115
Description
Gaylord with lid
Premium Gaylord with lid
Gaylord bottom
Gaylord lid
Telescoping top and bottom
Telescoping bottom
Telescoping top
Additional lids for telescoping containers
“D” 4-piece container
“EO” container
“EH” container
“E” container
Economy R.S.C.
Premium R.S.C.
Corrugated pads 15 x 15
Corrugated pads 20 x 12
Corrugated pads 24 x 18
Corrugated pads 30 x 30
Total
East
West
North
2,531
2,251
5,234
5,234
10,253
8,532
7,541
4,352
3,475
3,251
2,534
6,523
6,325
5,214
15,241
16,325
12,453
8,653
125,922
3,251
3,157
5,584
5,584
12,458
8,863
8,651
3,487
4,278
4,577
3,014
6,988
6,942
5,748
18,241
19,652
15,874
8,846
145,195
4,215
4,185
6,145
6,145
11,254
9,145
8,842
2,214
5,513
5,914
4,437
7,214
6,845
6,145
16,854
22,418
17,698
9,154
154,337
South
3,845
3,214
4,832
4,832
14,853
7,745
7,652
4,832
4,862
5,142
5,684
6,348
6,512
6,327
17,458
20,463
18,496
7,763
150,860
Proof of Total
Total
13,842
12,807
21,795
21,795
48,818
34,285
32,686
14,885
18,128
18,884
15,669
27,073
26,624
23,434
67,794
78,858
64,521
34,416
576,314
576,314
Hillsdale Realtors
2021 Sales and Commissions
Month
Properties Sold
January
5
February
8
March
12
April
11
May
15
June
18
July
18
August
20
September
21
October
23
November
14
December
10
Total
175
Private and Confidential
Total Dollar Value
$
625,874.00
1,158,623.00
1,754,258.00
965,875.00
2,157,485.00
7,658,963.00
6,157,485.00
10,658,412.00
11,094,906.00
7,716,625.00
3,654,178.00
2,348,659.00
$ 55,951,343.00
Total Commissions Avg Percent
$
16,253.75
2.6%
35,967.48
3.1%
42,587.34
2.4%
28,911.42
3.0%
72,584.15
3.4%
274,158.23
3.6%
232,158.74
3.8%
410,258.15
3.8%
390,102.33
3.5%
270,081.88
3.5%
144,756.38
4.0%
88,124.65
3.8%
$
2,005,944.50
3.6%
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.