if an independent project with conventional This is a topic that many people are looking for. star-trek-voyager.net is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, star-trek-voyager.net would like to introduce to you Excel 2019 Chap 7 Independent Project 7-6. Following along are instructions in the video below:
“Drake nyeah okay lil cc what a beat hm nyeah yeah verse 1 drake ni ni mean where the f ck should i really even start ni got h s. I m keeping in the dark. I got my n ggas cross. The street living large nthinking back to the fact that they de d.
Thought my raps wasn t facts til. They sat nwith the bars. I got two phones one need a charge nyeah they twins i could tell they a apart. I got big packs coming on the way ni got big stacks coming out the safe.
I got lil max. With me. He the wave nit s a big gap between us in the game in the next life. I m tryna stay paid nwhen.
I die put my money in the grave chorus drake nwhen. I die put my money in the grave. I really gotta put a couple n ggas in they nplace really just lapped every n gga in the race ni really might tat face nlil cc. Let it slap with the ba.
I used to save h s. With a mask and a cape nnow. I m like ain t about to die with no money i done gave nit verse. 2.
Drake ni was on top when that sh t. Meant a lot still on top like i m scared of the drop nstill on top and these n. Ggas wanna. Swap.
N. Ggas. Wanna swap like it s slauson or watts. Ni.
Don t wanna change cause. I m good where i m at nmob ties on em always good where i m at word to junior jazzy baby j ntell em when i die put my money in the grave lyrics verse 3. Rick ross ncouple figures killers call and collect collect she f ck a n. Gga.
Then she on to the next n. Next really living large. She in awe. With a mack nwhen you n.
Ggas thinking small in the mall. With a rat rat nroll with us. If you really wanna get it get it ngo get a half a million in the sprinter sprinter. Phone.
Ringing b. Tch. Es. Know a big tipper n.
Tipper. I got. The hookup. And there s really no limit n limit.
De d. Broke is in you n ggas dna dna nrickey smiley s in decatur with the ye lil n. Gga just another state case nbury. My motherf cking chase bank time to bounce bounce ngotta count on my allowance gotta count on my allowance nyou n.
Ggas snitches. So i gotta reroute it do or die na n. Gga dripping like i got a zillion dollars got the trap jumping like zion when i rebound nthen. I m out then i m out and i ll never talk about it about it nthe homies quiet but we all smoke the loudest loudest nrich n ggas and i m really being modest cause the way i do my deals never treated nlike a artist want house house you could dm.
My accountant nmy per diem six figures and i m counting nine figures was the goal till. I hit it nthese n ggas ai. N t living so bury mine. With me.
Nross got it maybach music chorus drake nwhen. I die put my money in the grave. I really gotta put a couple n ggas in they nplace really just lapped every n gga in the race ni really might tat face nlil cc. Let it slap with the ba.
I used to save h s. With a mask and a cape nnow. I m like to edit that formula that we just created to multiply the results by the number of minutes so up here in our formula bar. We re going to just put our cursor at the end of the formula and use the multiplication operator.
And we re going to multiply it times d three and then hit enter okay and you notice. It has three decimal points just like we formatted. It and then we re going to copy that formula to e4 through a 33. So we ll just fill that all the way down to e 33.
And you ll notice that oops mistake here. What was the mistake when a okay mistake. We made was i missed making this range here an absolute reference. So we need to make sure that that s an absolute reference.
So we use the f4 key to make that an absolute reference now we can hit enter and now we want to copy that formula all the way down and the only thing that should have na are the rows 24 through. 33. Which don t have the c and d. Columns filled in so.
That completes step number eight for step. Now. Number nine. We re going to assign percent data validation for c 3.
Through c 33. So if we re going to select that range of cells and we re going to go up to the day to town here in the data tools section. We re going to use the data validation so select data validation from that list and we re going to allow a list and we want to use the list of activity names on the data sheet as the list. So when our source box here.
We re gonna go over to the data sheet and we re going to select the activity names here as the list and we re not going to use an input message or an error alert that s silly click ok. And now you notice that every one of these if we want to enter something we have to choose from that list activities. Ok now we re going to select the calorie tracking sheet. Which we are already on and we re going to delete the data in cells a3.
Through d. 23. So a3 through d. 23.
You delete the data. We can go to the home tab well all we have to do is right click and clear contents okay and then we re going to select cells b3 through b 33. So b3 would be 33. Which is this range of cells here.
And we re going to set data validation to use date. So we re going to go up here to the data tab again and go to the data tool section. And choose data validation and this time. We re going to allow a date and we want a date that is less than or equal to so less than or equal to on the data.
This pulldown here less than equal to excuse me and the end date is equal to today. So we re going to use the today function. So we ll put equal and then today and open a closed parenthesis and that just puts. Today s date.
And we want to have a stop error alert. So we re going to click on the error alert. And the stop bear alert with the title of check date. So check.
Date. And the error. Message is date must be today or in the past and include the period. And then click ok.
And that includes step number 11 for step number 12. We re going to select cells a3 through d. 33. And we re going to remove the locked cell property.
So to do that we re going to go up here to eat we re going to right click on those cells. And you choose the format cells option and then select the protection tab. It may come up with the number or alignment. So we want to be on the protection tab and we re going to uncheck the locked.
Because remember all of the cells in a workbook or worksheet are all locked by default and you have to unlock them in order to be able to enter data into it when you lock the worksheet so we re going to just click ok. There and then it says to select cell a3 to position the insertion point. And then it says to display the developer tab on the ribbon and click. The data sheet work.
The data worksheet tab. So click on the developer tab and click. The data. Worksheet tab.
And then it says to draw a combo box control over cell f8 and open its format control dialog box. So we re going to go over here to the controls section on the developer tab and we re going to select a combo box in the from the form controls that s the second one in a first groan and we re going to draw it over the f8 cell like that and and then we re going to open its format control and the way to do that is to just right click on the combo box right up do it twice. And then you ll get this option. Format control to open that up and and then we re going to click on the control tab on the format control and we re going to select cells g8 through g 11.
For the input range. So position your cursor on the input range input box and select cells g8 through g. 11. Which are this range of cells here okay and then type f8 in the cell link box.
So f8. So it s going to put the result of that drop box in cell. 8. And i ll show you how that works here in just a minute and so we just click ok.
And then deselect the control so click on any cell outside of the controls. So you can see that those circles go away on the control. And then select the second okay now we ve selected second from the control. And it says.
The linked cell is under the control and hidden from view and i ll show you what they mean by that so if we click on this you move the cell. Nice guy figure out how to do this okay. If you right right click on the control. And then you can move the cursor.
So you can actually select the control and move it and you ll see that because i chose second there it has a two if i chose from the pulldown list. Let s say choose from i choose third and you see that f 8. Has a 3 in it if i choose 4th it has a 4. But we were told to choose 2nd so let s right click on that and move it back up you to cover it cover.
What s in the f8. So we know behind that because we have chosen second there s a number two there. That s kind of important to know and understand for the subsequent steps now for step number 16. We re gonna select the hospital seminars worksheet and we re going to select d4 and this has the center cross selection alignment applied.
So it s actually centered across cells d and e um. So i think it s dna. But you ll find out understand so now we re going to select self. D4.
And we re going to use the concat and index to display the result from the combo box concatenating. The index results with the word quarter. So first of all i want to show you we ll just do the index function so we go up here to the formulas and we select index so i can look up and we re going to choose that first list and for the array. We re going to use g8 through g 11.
On the data sheet. So we need to go to the data sheet make sure your cursor is on the array selection. There go to the data sheet and we re going to do g8 through g. 11.
And and then we re going to use f8 on the datasheet the datasheet selects f. 8. Which is kind of hard to do because our combo box is over it okay. But there s just enough room of mine.
We could just alternatively just type data. Exclamation point f8 and then click ok and you ll notice. It says second because this is aligned across all of these boxes it puts it in the middle. So now we can quickly use the concatenate function or the concoction.
So we can go up here and insert the cat function. So we ll insert the concoction here on the formula bar. I m going to just edit our function. So right after the equals sign so it can cat and an open parenthesis in our first argument.
You can see here it shows. The syntax first argument is text 1 and for text. 1. We re going to use that function result for the index function.
So we re just going to leave that there and then after the index function the close parenthesis. There put a comma and notice that in our it shows that they had moved on to the second argument. Which is text to okay for text. 2.
We re going to put a quote and on a space and quarter. Because we just want to append that word quarter now with it led by a space after the result of whatever quarter. We selected on the data sheet and then we re going to close the parentheses. You know it doesn t say to put make this g 8.
Through g. 11. An absolute reference so we re not going to worry about that so if i hit enter you can see now it says second quarter. So if we select d4 and go up here and select the bold and italic.
Which is the final step in step number 17. Bold italic and we want it to be 16 points okay. So that completes step number 17 step number 18. We re just going to prove that that works so we re going to select the data worksheet job and we re going here to our combo box.
And we re going to select third and then when we go back to the hospital seminars worksheet now in d4. It says third quarter and so that worked so that s working correctly so now we re going to select cell. D4 which is selected and cells d6 through g10 on the hospital seminars sheet so and in an unlock remove the locked property. So let s just do that on the i don t think we can do it on the hospital.
Seminar sheet. I hold the control key down. Yeah. It says.
T4 d. 6. Through g. 10.
On the hospitals. Ok seminars. So deep. For and then hold the control key down.
And select g d. 6. Through g10 like that and right click and choose format cells and uncheck the lock box so now we re unlocking cells d4 and d6 through g10 okay and now we re going to delete the contents of d6 through g10 and select cell. D6.
So d6 through g10 right here just select that range of cells right click and clear the contents and then select cell. D6 and that completes step number 20 for step number 21. If we right click on the this image. Here and edit the alternative text.
We can go over here and select that alternative text box and we re going to type hamilton civic center logo. My god on both pictures in the workbook. So there s also on that same picture on the tracking. So select that and it alter alternate text.
And we put that in this box. As well. So hamilton civic center logo. Wait ya can just hit enter and and then select cell d6 on the hospital seminar sheet so hospital summer seminar select d6 and on the calorie tracking sheet select a three you and then protect the and then for step number 23.
We re going to protect the hospital. Seminar sheet. And the calorie tracking sheet. So we ve got the calorie tracking sheet.
So let s select. The hospital seminars sheet first and then if we go to the file and click on the info. We ll click on the info option there on the backstage menu. We re going to click on this protect workbook and select protect current sheet.
And we re not going to put in a password. So we just click ok and then we do the same thing for the calorie tracking sheet. So with the calorie tracking worksheet selected. We go to the file and on the backstage menu select info and select protect you can see the hospital seminars.
It already shows that it s protected so we ll do the protect current sheet. Again and we re not going to do a password for that either and now if we go to the file. And back side we can see both the calorie tracking and the hospital seminars worksheets are protected if you want to unprotect them we click on these unprotected buttons ok. That s step number 23.
Where step. 24. Then a save and close the workbook and then we re going to go back to the yeah oh i had an open work word document there and we re gonna upload the file that s going to be in the downloads folder it ll be the one that i just finished or just closed. Which is right here in obey.
And then say yes submit the file for somebody s gonna get a 93 percent same thing i got the first time so didn t like number 12. It said select cells a3 through d. 33. And remove the locked cell property and select cell a3.
Okay so let s try that i will download the submitted file and that s going to be on b eight three three d 33. Okay. Maybe i missed that so download. The submitted file you mabel editing and we ll go a3 through 33.
What step was that again one second let me just double check. Yeah. It was a three through d. 33.
And right click hmm you oh. I know what because that the worksheet protected. So we have to go back. Here.
And that is the calorie tracking so we re going to protect that first and then go back. Now. We can select a three through g 33. And right click and format cells and protection and this needs to be unchecked click okay and then select a 3 as the insertion point and then we should and we have to go back and protect it again so go to the backstage and select protect parents sheet and we re not going to use a password so now both of those are protected and now we should be able to save it and close it and then if i go back up here and click on this i can submit it again straight.
You submit oh now again i okay cool alright so that completes the excel 2019 in practice. So hopefully you caught that i missed doing that step. And you didn t have to go back and redo that but that completes that ” ..
Thank you for watching all the articles on the topic Excel 2019 Chap 7 Independent Project 7-6. All shares of star-trek-voyager.net are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.