With steps and formulas that needs tobe use please

Grader-Instructions. Excel 2022 Project Exp22_Excel_Ch03_Cumulative_Patient Project Description: You work as a nurse in a health clinic. You record each patient's systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they have hypertension, caused by high blood pressure. You prepared a spreadsheet that can be used as a template to track a patient's blood pressure and heart rate. You are ready to create charts that you can use when discussing a patient's blood pressure. Stone th Parfinm. og of the rencal axie. Nesr, you wil onoue a line dem depiting die lear tate soing for de inma. 4 Thit churt will halp the futime ver tecudu iver lime. More the line chart so atart in cell tl in the Charts sheet. 7 Yise docale ie atfen the sine of der live ther. Eer s. o hoph and 5n wabh. shint lenelist. Apply Ligh oralint - Nocent I gradien fit oolor to the ploc ana ne fle liet eust beart ratei. Ade des labets in the dorve poitive is the line dhen. iaply itick, fen 1 fout eole ter the inke. fit poitun. Rerover de value data laber. the other alise mill mphaint it. Alpiy by bit ocading with the everiry of keart talks. Creac a Clutrtsd Colim - Lat ie Sovonlat Aais evenhe dant ining the Cemele C Zank. 20. Aler ereating the dar, you wilt apply a churt ayte. 3 Aeply Syk 4 ihin ayle to the combe dar Aaregary asis 24. Yoe decide to adl a bille ta cack iab to leseribe the dath teine plofed 2 . mtle Ileart Hanr. 25 Mone the kipad in the pesperien Edit te dita marce bo renowe the 4 loved dail weion. raip fier the lact fear uinke 28. Finally. you add sparklines bo the blow promer readirp and heat faies helos 3 . the repective colunne. ferm the netpe B3:D7. Apply Blue spurkine wobe and Suplay fe high poib for the squinet. Subent the fie us direrwit Totat Felats Ites Created On: 03/302022 1 Exp22.Exeel Chos Cumulative - Paticnit 1.0 Exp22_Excel_Ch03_Cumulative_Patient Project Description: You work as a nurse in a health clinic. You record each patient's systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they have hypertension, caused by high blood pressure. You prepared a spreadsheet that can be used as a template to track a patient's blood pressure and heart rate. You are ready to create charts that you can use when discussing a potient's blood pressure. Steps to Perform: 3 The chat nods a deicripeive, eloy-lo-read title. Change the chart title to Bliond Frxwsure Meadings in Aprill and bold the titic 4 You realiec the chant might be conier lo read as a har chart. Change dhe char bipe to Chasiered Bae. 5 You will increase the chart size to make it casier to tead on a dryplay scrocn. 2 Sen 4 height. 6. Yee want to nemove the addeival detes dieplayed ent the eaiegory asia Soloct the dases on the avis and display the Foruat Axis task pane, In the Axis Options canepory, select Teat asis to temiove the extra dines frum the chat. 7 You want to amange the dnes with the oldest due at the bop. Desplay the deses in reverse opder on the canefory axis so thit 41.10004 is ar the lop of the vertical axis. 8. Neet, yeu will create a line char depicting the hear tate teading for the mueth 4 This chars will holp the paticit mee trends over time. Create a line chart using the rages A3:A7 and D5:D7 on the Aprit woksed. Move the line chart to ifart in eell II in the Charta sheet. 9. You decide to adjust dee sire of the line chart. Ser 3.5- heigh anal 51 wiah. chan. 12. You will change the foet color for the axes so make the chart eweser io neat. I Apply Hack. Ted I font colse so the value asis and ia the catcequry asis an the line chart. 13 Now you want 10 apply a gradient fill colae wo the ploe area 10 aofen the image: 4 Apply Lighr Gradient-Aceent I gradicut fill color to the piat aers on the line Apply chat. 14 Data labels frenide exact detaile. In this caies, alding daia babels will provide exact heart rases. Add data labels in the above position en the line chart. 15. The April werkchos eontains a renge that ismenfies how mary times in the moeth the patieat lad sormal and high blood frespures. Yie detide of pie chan will help the puticnt vivalize the data betier. Create a2.D pie chart asing the ranges F3.14 and 113.414 in the April 10 Change the line chart title to Hirart Mates in Aprit and bedd the ticle: 2 chart. 12 Vou will shange the foot color for the anes wo male the chan waidr to mat. I 2 line chart. 13 Now you want 10 apply a pradient fill cuder to the phet unew we wetha the imagie. 4 Apply Lighi Gradleat - Mocent 1 gradezin fill color we the plot una oe the line chart. 14 Das labels provide euat details. In this canc, adlint da bects will provele 4 exact hear rates Add data labels in the atove position on the line dhurt. 15. The April werksest contains a range but idcutifis her mang time in the 5 meath the patient had nomal and lipt blood preases. Yee deedede a pie clurt will belp the patinet visealios the duat betant. Croile a 2-D pie chart using the ninges 1394 and 30 alt in the Apol wurksheer. Move the chat io start is cell A22 in the Clarts ahere. 16 Change the chart tale to Pereentuge of Sormil ma meb Bled Fiesare and 5 apply Black, Teat 1 font cobor to the enle. 17 Removing the legend can rodace eutaneoes elements in the uhut Maling date 5 labels koep descriptions within cach alioe. Fit position. Remove the Value dati labeh. 18 Changing the color of the ligh blood prosurs allee ind eyplodes an away fivm 5 the echer alice will emplavise it. by b\%. 19 The lat chart you wane to create is a combo chan we depict the Hbod prowane 5 readiags with ihe overlay of heat rate. Crent a Chatestal Celumt - Line co Secandary Atis sombe duat wing the nasee A2. DT is the Apnil worlshoc. Move de dlat is a dedent deet numet Cambe Clarh. 20. Afer creating the chan, you will arply a chart anke. 3 Apply style 4 clat nyle so the eunbo dat. 23 Apply Black, Teal I fome eolor and 11 gr fiom sere si be the valur ates and the 3 cabepery axis. 2 Add a primacy verical acis sitle Blied Prosere and a secentmy vertical avis Aile Hitart Bate. 25 Move the legend to the tep porinin. 26. You docide to romove one of the duts nerick. Edit the dvea source to remove the 412024 date arios. 27. Now yea are neady to add Alt Teat we the chan. Dieplay the combe chart and adI the Alt Ted Shews Ment proviare and loart rate for the lent four werki. 28. Finally, you add sarklines to the Hood proumencalings and krat peses bolow 9 the ropective colunns. Seleat nange B6 De on the April wurlutect Inser Colume Spuibises waing dats form the nings B3:D7. Q. Yeo and sa cusciomise the sparilince. Apply Bhe ypurkine color and Eightay the high peimes fire the spak lises. Sulunit the file as dirested. Total Paintu 10s Grader-Instructions. Excel 2022 Project Exp22_Excel_Ch03_Cumulative_Patient Project Description: You work as a nurse in a health clinic. You record each patient's systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they have hypertension, caused by high blood pressure. You prepared a spreadsheet that can be used as a template to track a patient's blood pressure and heart rate. You are ready to create charts that you can use when discussing a patient's blood pressure. Stone th Parfinm. og of the rencal axie. Nesr, you wil onoue a line dem depiting die lear tate soing for de inma. 4 Thit churt will halp the futime ver tecudu iver lime. More the line chart so atart in cell tl in the Charts sheet. 7 Yise docale ie atfen the sine of der live ther. Eer s. o hoph and 5n wabh. shint lenelist. Apply Ligh oralint - Nocent I gradien fit oolor to the ploc ana ne fle liet eust beart ratei. Ade des labets in the dorve poitive is the line dhen. iaply itick, fen 1 fout eole ter the inke. fit poitun. Rerover de value data laber. the other alise mill mphaint it. Alpiy by bit ocading with the everiry of keart talks. Creac a Clutrtsd Colim - Lat ie Sovonlat Aais evenhe dant ining the Cemele C Zank. 20. Aler ereating the dar, you wilt apply a churt ayte. 3 Aeply Syk 4 ihin ayle to the combe dar Aaregary asis 24. Yoe decide to adl a bille ta cack iab to leseribe the dath teine plofed 2 . mtle Ileart Hanr. 25 Mone the kipad in the pesperien Edit te dita marce bo renowe the 4 loved dail weion. raip fier the lact fear uinke 28. Finally. you add sparklines bo the blow promer readirp and heat faies helos 3 . the repective colunne. ferm the netpe B3:D7. Apply Blue spurkine wobe and Suplay fe high poib for the squinet. Subent the fie us direrwit Totat Felats Ites Created On: 03/302022 1 Exp22.Exeel Chos Cumulative - Paticnit 1.0 Exp22_Excel_Ch03_Cumulative_Patient Project Description: You work as a nurse in a health clinic. You record each patient's systolic and diastolic blood pressures each week. A number of patients have requested blood pressure data and charts. This information helps patients know if they have hypertension, caused by high blood pressure. You prepared a spreadsheet that can be used as a template to track a patient's blood pressure and heart rate. You are ready to create charts that you can use when discussing a potient's blood pressure. Steps to Perform: 3 The chat nods a deicripeive, eloy-lo-read title. Change the chart title to Bliond Frxwsure Meadings in Aprill and bold the titic 4 You realiec the chant might be conier lo read as a har chart. Change dhe char bipe to Chasiered Bae. 5 You will increase the chart size to make it casier to tead on a dryplay scrocn. 2 Sen 4 height. 6. Yee want to nemove the addeival detes dieplayed ent the eaiegory asia Soloct the dases on the avis and display the Foruat Axis task pane, In the Axis Options canepory, select Teat asis to temiove the extra dines frum the chat. 7 You want to amange the dnes with the oldest due at the bop. Desplay the deses in reverse opder on the canefory axis so thit 41.10004 is ar the lop of the vertical axis. 8. Neet, yeu will create a line char depicting the hear tate teading for the mueth 4 This chars will holp the paticit mee trends over time. Create a line chart using the rages A3:A7 and D5:D7 on the Aprit woksed. Move the line chart to ifart in eell II in the Charta sheet. 9. You decide to adjust dee sire of the line chart. Ser 3.5- heigh anal 51 wiah. chan. 12. You will change the foet color for the axes so make the chart eweser io neat. I Apply Hack. Ted I font colse so the value asis and ia the catcequry asis an the line chart. 13 Now you want 10 apply a gradient fill colae wo the ploe area 10 aofen the image: 4 Apply Lighr Gradient-Aceent I gradicut fill color to the piat aers on the line Apply chat. 14 Data labels frenide exact detaile. In this caies, alding daia babels will provide exact heart rases. Add data labels in the above position en the line chart. 15. The April werkchos eontains a renge that ismenfies how mary times in the moeth the patieat lad sormal and high blood frespures. Yie detide of pie chan will help the puticnt vivalize the data betier. Create a2.D pie chart asing the ranges F3.14 and 113.414 in the April 10 Change the line chart title to Hirart Mates in Aprit and bedd the ticle: 2 chart. 12 Vou will shange the foot color for the anes wo male the chan waidr to mat. I 2 line chart. 13 Now you want 10 apply a pradient fill cuder to the phet unew we wetha the imagie. 4 Apply Lighi Gradleat - Mocent 1 gradezin fill color we the plot una oe the line chart. 14 Das labels provide euat details. In this canc, adlint da bects will provele 4 exact hear rates Add data labels in the atove position on the line dhurt. 15. The April werksest contains a range but idcutifis her mang time in the 5 meath the patient had nomal and lipt blood preases. Yee deedede a pie clurt will belp the patinet visealios the duat betant. Croile a 2-D pie chart using the ninges 1394 and 30 alt in the Apol wurksheer. Move the chat io start is cell A22 in the Clarts ahere. 16 Change the chart tale to Pereentuge of Sormil ma meb Bled Fiesare and 5 apply Black, Teat 1 font cobor to the enle. 17 Removing the legend can rodace eutaneoes elements in the uhut Maling date 5 labels koep descriptions within cach alioe. Fit position. Remove the Value dati labeh. 18 Changing the color of the ligh blood prosurs allee ind eyplodes an away fivm 5 the echer alice will emplavise it. by b\%. 19 The lat chart you wane to create is a combo chan we depict the Hbod prowane 5 readiags with ihe overlay of heat rate. Crent a Chatestal Celumt - Line co Secandary Atis sombe duat wing the nasee A2. DT is the Apnil worlshoc. Move de dlat is a dedent deet numet Cambe Clarh. 20. Afer creating the chan, you will arply a chart anke. 3 Apply style 4 clat nyle so the eunbo dat. 23 Apply Black, Teal I fome eolor and 11 gr fiom sere si be the valur ates and the 3 cabepery axis. 2 Add a primacy verical acis sitle Blied Prosere and a secentmy vertical avis Aile Hitart Bate. 25 Move the legend to the tep porinin. 26. You docide to romove one of the duts nerick. Edit the dvea source to remove the 412024 date arios. 27. Now yea are neady to add Alt Teat we the chan. Dieplay the combe chart and adI the Alt Ted Shews Ment proviare and loart rate for the lent four werki. 28. Finally, you add sarklines to the Hood proumencalings and krat peses bolow 9 the ropective colunns. Seleat nange B6 De on the April wurlutect Inser Colume Spuibises waing dats form the nings B3:D7. Q. Yeo and sa cusciomise the sparilince. Apply Bhe ypurkine color and Eightay the high peimes fire the spak lises. Sulunit the file as dirested. Total Paintu 10s