Concept Map Assignment
Order ID | 4211189692 |
Subject | Nursing |
Topic | Concept Map Assignment |
Type | Essay |
Writer level | College |
Style | APA |
Sources / references | 2 |
Language | English(U.S.) |
Description / paper instructions
Attached you will find the instruction paper for this assignment. Please be careful with the citation. I recently had a problem with some of the order that I placed here and I am currently being charged of plagiarism because the writers copy and paste information for web sites, That can not happen again because I am in 6 month probation. So pay attention to that. I selected 2 pages because of the word count, but everything must be done in one page. If you have any question, please contact me, and I will reply asap. Thank you for working in my assignment.
WEEK # 7 – EXERCISES CHAPTER # 10 Exercise Ch10-5: Level 3- Daily List. One of Kiola’s colleagues in HR uses an Excel worksheet to keep track of daily information regarding appointments and visitors expected at the company’s campus. Each morning this information is printed and distributed to each of the receptionists and administrative assistants. The receptionists are given one version and the administrative assistants another.
Kiola’s colleague would like your help in creating a macro to print out the worksheet in the two required formats. To make it easy for anyone to produce the appointment and visitor lists, HR would like the capability of launching the macro from a shortcut key sequence, a macro button on a custom ribbon tab, and a custom button directly on the worksheet.
the macro-enabled workbook 10-5-DailyList-Monday-YourName.xlsx. If the DEVELOPER tab is not already visible, add it to the ribbon.
TROUBLESHOOTING: In order to complete this step, the macro settings on your computer must be enabled. If you receive a Security Warning saying macros have been disabled or the file can’t be saved as a macro-enabled workbook, open the Trust Center to check the macro security settings. If you don’t have access to the Trust Center, contact your instructor or computer support person for assistance.
Enter a description for the macro. Perform the following steps while recording the macro: For the first printout, specify:
For the second printout and to reset the worksheet, make the following modifications:
(Hint: You must enter a new shortcut key because Ctrl+Shift+F has already been assigned to the first macro you recorded.)
Add the command buttons to Hide Columns and to Unhide Columns in this ribbon group.
1 WEEK # 7 – EXERCISES CHAPTER # 10
(Hint: Search for the commands Hide Columns and Unhide Columns from the All Commands list.)
WEEK # 7 – EXERCISES CHAPTER # 10
Exercise Ch10-6: Level 3- Projected Sales and Commissions for CKG Auto.
You are working in CKG Auto’s Sales Department as an analyst. The sales manager, Leroy Mason, wants to automate the worksheet he uses to calculate monthly sales commissions so that others can use it. CKG Auto pays each salesperson a base salary plus a commission.
This commission value has changed so this value for all new entries should be 7% of the sales amount. Leroy asks for your help in ensuring users enter valid data and do not change or delete the sales data the workbook already contains. He also wants to include a chart comparing the total sales of each salesperson without revealing their names.
Complete the following:
the macro-enabled workbook 10-6-July-Sales-YourName.xlsx.
(Hint: Use a PivotTable or the Remove Duplicates button in the Data Tools group on the DATA tab to remove the duplicate names quickly.)
Apply the Use Relative References option to make sure that when recording your macro, the insertion point is relative to the active cell.
(Hint: The Use Relative References button in the Code group on the DEVELOPER tab toggles this feature on and off. Be sure the button is highlighted in green to indicate that the feature is on before you begin recording the macro.)
WEEK # 7 – EXERCISES CHAPTER # 10
move the active cell down one row to the first empty cell. Type = Sales_Rep_Name. Move to the next column where the user will enter the sales date, and then type Sales_Date. Repeat this procedure to enter the sales amount and commission using their corresponding range names.
4 |
|
||||||||||||||||||||||||||||||||
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDERCLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernowAlso, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow |
||||||||||||||||||||||||||||||||
|