Select Page

Instructions 1. Required: Open and use this template for this week’s Excel assig

by | Nov 24, 2021 | Nursing | 0 comments

GET HELP WITH YOUR ESSAY

If you need assistance with writing your essay, our professional Essay Writing Service is here to help!

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW

Instructions
1. Required: Open and use this template for this week’s Excel assignment: Excel Assignment TemplateLinks to an external site..
2. Apply the following steps in formatting to each specified sheet in the Excel template.
3. You can print the list below and use it as a check-off list if you think it might help.
Sheet 1 (This sheet will be blank when you open the template.)
Rename Sheet 1 to ‘Data.’
Title columns A-C: Name, Date, and Amount.
In column A, list the last names of 8 fictional patients.
In column B, enter a random date for each patient.
In column C, enter a random amount of medication for each patient.
Alphabetize the patient’s last names in A-Z sort order.
Insert a new column between columns A and B. This does not have to be populated with data, but it can be used for patient first names.
Insert a new row within the middle of your list. This does not have to be populated with data, but it can be.
Apply center alignment on all cells with data in them.
Change the Font in all cells that contain data – do not use Times New Roman or Calibri.
Use the Border tool to create a definition around a cell within your sheet.
Choose a Fill color for your column and row titles.
Autofit the width and height of all cells with data in them, so all data is clearly visible.
Meds sheet
Remove the formatting from cell D5 on the Meds sheet so that cell D5 appears like the other cells in the sheet.
Use the SUM function to find the sum of the numbers in column D.
Use the AVG function to find the average of the numbers in column D.
Place the third formula (e.g., MAX, MIN, COUNT) in a non-adjacent cell.
https://galen.screencasthost.com/watch/crj0qnVj8XF (Links to an external site.)
BMI sheet
Enter random weight amounts in cells B7:B11. The colon means all, all cells from B7 through B11. Every row.
Enter random height amounts in cells C7:C11. The colon means all, all cells from C7 through C11. Every row.
Copy and paste the BMI formula into cells D7:D11. You can use an Excel drag-and-drop feature to copy and paste the BMI formula; see A Faster Way to Use the Fill Handle (Links to an external site.) video for assistance.
Once the formula is copied, highlight cells B2:D11 and create a comparison chart.
BP sheet
Insert an Excel chart (graph) of your choice using the blood pressure data provided on this sheet.
Apply at least three customization formats to your chart. List the three customizations you implemented in a cell near the chart.
Sheet 5
Delete Sheet 5.
Saving Your Work
Save as excel_practice_lastname.xlsx (e.g., “excel_practice_smith.xlsx”).
Your submission this week will be an Excel workbook (.xls, .xltx, or .xlsx).
https://galen.screencasthost.com/watch/crj0qnVj8XF
https://edu.gcfglobal.org/en/excel-tips/a-faster-way-to-use-the-fill-handle/1/

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW

Writers for any paper

We have 500+ professional essay writers on our team. These are experts who work in colleges and universities .Eliteacademicessays.com is one of the most versatile essay writing services in the industry. You’ll get an MA or PhD essay writer from the subject area you choose. You can order a paper on any topic from us!

High Quality

We stand behind the quality of our services every time, no matter the subject or difficulty.

 

24/7 Support

We’re always there for you, working nonstop to help you in your hour of academic need.

Timely Delivery

Time is the most important thing these days and we understand that you turned to us to save yours.

 

Original Content

Every word you read in the paper we’ve written is original, every thought is unique.

 

Free Revision

Not only do we write quality academic works, we also offer absolutely free revisions so that you can correct anything you need.

100% Anonymous

We’re always there for you, working nonstop to help you in your hour of academic need.

Easy As 1…2…3…

1. Place Order/Submit Instructions
Submit the instructions in the order form. Add the number of the pages, the deadline, and attach any additional files.

2.Make Payments
Securely complete the payment process.

3. Writer Upload Solution for Quality Check

We will assign your work a writer, sit back and relax. The Quality Control department will check and verify completion to set standards.

4. Download Paper and Enjoy
Now download the uploaded solution and enjoy your life.

Confidentiality

We encrypt everything. It’s all confidential.

Secure Payment

Sleep tight: each transaction is encrypted and 100% secure.

Ready to get started?

%d bloggers like this: