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

  • @jideolalere2754
    @jideolalere2754Ай бұрын

    Thank you sir.

  • @MusttyBrown
    @MusttyBrownАй бұрын

    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.

  • @MusttyBrown
    @MusttyBrownАй бұрын

    However, thank you sir, we are making progress.

  • @umarbalarabe1007
    @umarbalarabe1007Ай бұрын

    Thanks sir.

  • @IsahIsyaku-lr6yr
    @IsahIsyaku-lr6yrАй бұрын

    Thank you very much sir.

  • @aminuwambai7879
    @aminuwambai7879Ай бұрын

    Thank you sir

  • @abubakarhamza9853
    @abubakarhamza9853Ай бұрын

    Thank you sir ❤

  • @FineCollections1
    @FineCollections1Ай бұрын

    Thank you

  • @blinkwinkenterprises8056
    @blinkwinkenterprises8056Ай бұрын

    We always learn new ways of solving things from you sir. Thanks

  • @oluwatobiakande-ut6ho

    @oluwatobiakande-ut6ho

    Ай бұрын

    Glad to hear that

  • @akamike2101
    @akamike2101Ай бұрын

    I am sure I got the highest score

  • @othukeprecious3693
    @othukeprecious3693Ай бұрын

  • @abdullahimurtala5760
    @abdullahimurtala5760Ай бұрын

    😂funny thing is i was using pivot table, thanks sir

  • @IbraheemAderemi
    @IbraheemAderemiАй бұрын

    30/50😢

  • @othukeprecious3693

    @othukeprecious3693

    Ай бұрын

    THE MOST IMPORTANT THING IS THAT YOU ATTEMPTED THE QUESTIONS AND HERE IS THE CORRECTION FOR BETTER UNDERSTANDING.

  • @HouseofKiteni
    @HouseofKiteniАй бұрын

    Thank you sir What about some of us that haven't received our results in our mailbox?

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20Ай бұрын

    nice. give excel file in the description vidwo

  • @oluwatosinoguntuga9459
    @oluwatosinoguntuga9459Ай бұрын

    Sir, the last questions you looked for married individual instead of Single individual.

  • @oluwatobiakande-ut6ho

    @oluwatobiakande-ut6ho

    Ай бұрын

    Really ?

  • @basilchinedu382
    @basilchinedu382Ай бұрын

    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

    @faithmatthew7741

    Ай бұрын

    He actually asked us not to clean the data

  • @emmanuelnandang5214
    @emmanuelnandang5214Ай бұрын

    Morning sir, I think the distance covered should be =SUMIF and not COUNTIFS . its looking at total distance covered

  • @oluwatobiakande-ut6ho

    @oluwatobiakande-ut6ho

    Ай бұрын

    We were interested in the total number of individuals that covered the highest distance not the total distance covered

  • @ritadavies3812
    @ritadavies3812Ай бұрын

    Waiting to see my scores😂

  • @atinsolaabdulbaasit745

    @atinsolaabdulbaasit745

    Ай бұрын

    Check your mail

  • @iugtv3610
    @iugtv3610Ай бұрын

    Thank you sir

  • @SolomonMoradeyo
    @SolomonMoradeyoАй бұрын

    thank you sir