Posts

Showing posts from November, 2022
By Uma Bakshi -
Image
 Data Driven Decision Making B.Com Business Analytics Sem I Questions (6-10) : Python   Q6. Write a program to assign three values to the variables a, b and c            and perform the operations addition, multiplication, ((a+b)+c),          ( a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).           #Write a program to assign three values to the variables a, b and c     and perform the operations addition, multiplication, ((a+b)+c),   (a-(b+c)), (a*(b+c)), (a + (b*c)), (a*(b-c)).    a =  int ( input ( 'Enter a number of your choice' ))           b=  int ( input ( 'Enter a number of your choice' ))      c=...
Post a Comment
Read more
By Uma Bakshi -
Image
  Data Analytics Modelling Lab Notes (2022-23)(Q26-Q30) B.Com ( Business Analytics) Sem III V. Table for questions 26 to 30:           26.From the above table, remove the invalid phone number   which                are not in the proper format of having 10 digits, no characters                     and the phone numbers which are starting with 9/8/7/6           Step1: Copy the contents of phone number in a new sheet.           Step2: Copy the contents of phone number in another column.           Step3: Select the contents and go to conditional formatting.           Step4: In the drop down box , select Between.           Step5: In the dialogue box, fill it with 5999999...
Post a Comment
Read more
By Uma Bakshi -
Image
                                                                        Data Analytics Modelling Lab Notes (2022-23)(Q21-Q25) IV .  Table for Question No. 20-25           Q21:   From the above data in Excel, Concatenate the Headers.           Step1: Select the two rows in the header and copy the cells in a new               S heet ( in cells 2 nd and 3 rd rows)           Step2: Select Cell A6, right click and select paste special,           Step3: Select Transpose.           Step4: Select the cell C6, write the syntax           ...
Post a Comment
Read more
By Uma Bakshi -
Image
Data Analytics Modelling Lab Notes (2022-23)(Q16-Q20) B. Com ( Business Analytics) Sem III            III Table for Questions 16 to 20:                Q16:  Concatenate columns Street name and City.                Step1: Copy Street name and City columns in a new Sheet.                Step2: In C2 Cell write the syntax                               =PROPER(CONCATENATE (A2, “ , ”, B2))                Step3: Select C2 and drag down.                Step4: All the cells get concatenated.           Q17: Insert "C-" in the left side of the customer Id in customer name       ...
Post a Comment
Read more
By Uma Bakshi -
Image
  Data Analytics Modelling Lab Notes (2022-23)(Q11-Q15) B.Com ( Business Analytics) Sem III          I.  Table for 11-15 Questions           Q11: Remove blank Rows:           Step1: Select the table.           Step2: Click on Data Tab.           Step3: Click on Filter (Symbol)           Step4: Click on the Down Arrow next to Employee ID           Step5: Deselect all except the Blanks           Step6: Blank Rows will be displayed.           Step7: Select them and delete them           Step8: Click again on the down arrow of EmpID and select all.           Step9: Blank rows are removed.           Q12: Highlight...
Post a Comment
Read more