Solution to Practice Questions On Excel Functions & Formulas
A Consumer Demographic and Purchasing Behavior Dataset was used to test our understanding of functions and Formulas in Excel. Questions such as How many married men have cars and bicycles in North America, 11. Between car owners and bike owners, who covers the highest distance in Pacific region, Which region boasts the highest number of cars owned by individuals over the age of 70?, In North America, what mode of transportation do single individuals primarily utilize: cars or bicycles? etc were some of the questions used to test our skills in formula formulation.
This lecture provides a solution to all the questions used.
The solution can be found here:
bit.ly/FunctionsAndFormulaSol...
Пікірлер: 27
Thank you sir.
Good day sir.. some of us particularly myself adhere strictly to the principle of the course as you stated during the classes by conducting the data cleansing before proceeding.. you may consider to give us our marks if our answers are correct after the cleansing sir😊 for adhering to the principles.
However, thank you sir, we are making progress.
Thanks sir.
Thank you very much sir.
Thank you sir
Thank you sir ❤
Thank you
We always learn new ways of solving things from you sir. Thanks
@oluwatobiakande-ut6ho
Ай бұрын
Glad to hear that
I am sure I got the highest score
❤
😂funny thing is i was using pivot table, thanks sir
30/50😢
@othukeprecious3693
Ай бұрын
THE MOST IMPORTANT THING IS THAT YOU ATTEMPTED THE QUESTIONS AND HERE IS THE CORRECTION FOR BETTER UNDERSTANDING.
Thank you sir What about some of us that haven't received our results in our mailbox?
nice. give excel file in the description vidwo
Sir, the last questions you looked for married individual instead of Single individual.
@oluwatobiakande-ut6ho
Ай бұрын
Really ?
Thanks for this but I have some few observations to share. In this video, you said we were supposed to just proceed with the analysis without first of all cleaning the dataset (which we know entails like removing of duplicated rows, etc.) Permit me object to that. The dataset had alot of duplicated rows (ie duplicated all the way from the id column to other colums in the data) and going ahead to analyse the dataset like that would definitely result to falsified results and moreso there wasn't a strict instruction asking us to by pass the data cleaning step which is critical phase in data analytics. What's your take on this? Looking forward to your reply. Thanks
@faithmatthew7741
Ай бұрын
He actually asked us not to clean the data
Morning sir, I think the distance covered should be =SUMIF and not COUNTIFS . its looking at total distance covered
@oluwatobiakande-ut6ho
Ай бұрын
We were interested in the total number of individuals that covered the highest distance not the total distance covered
Waiting to see my scores😂
@atinsolaabdulbaasit745
Ай бұрын
Check your mail
Thank you sir
thank you sir