Append both sets of students year 11 and 12 and then finally rename this table as student.
Combine course and student data and then filter female students on 3 or more credit courses
Read More
You can use “folder” connection option in Power Query to easily consolidate data from all files in a folder.
In the third example, we will take all the project files in the example dataset and combine data to one table.
Read More
let’s use Power Query to scrape web data from List of Indian States page on Wikipedia.
On that page, there is a historical census data table (depicted below) and we will connect to it from Power Query. Once we have the data, we will unpivot it to tabular format for easy analysis.
Data for this example - WikipediaPlease use the URL - https://en.wikipedia.org/wiki/List_of_states_in_India_by_past_population for this example.
In the first Power Query example, we will look at data for one thousand staff and clean it up. The data is in an Excel file. We will load it to Power Query and perform below clean-up activities. After data is clean, we will publish the dataset to Excel for analysis.
Q. What is DBMS? (3)
Q. What is the use of Vlookup function and write its syntax? (5)
Q. What is HTML? (3)
Q. Why we use CSS in web designing? (2)
Q. What is the main purpose of user account in computer?(3)
Q. How can you switch between open programs in window? (2)
Q. How can you apply double lookup value in vlookup function? (3)
Q. How can you extract zip in window? (2)
Q. What is the use of relationship in access? (2)
Q. What do you mean by .ppt?(2)
Q. What is transition in presentation?(2)
Q. How can you select any layer object in photoshop? (2)
Q. What is the main purpose to introduce TDS by government? (3)
Q. What certificates will provide by the deductor to the deductee? (4)
Q. What is the procedure of TDS registration?(2)
Q. Fill in the blanks:- (20)
a. Full form of gst is _____________.
b. _______ is the key to use task manager in window
c. ______shortcut is used to minimize all open files in window.
d. CTRL+K is used for _________.
e. _______ is casual taxable person in gst.
f. Full form of LED is _______________
g. _______ returns to be filled annually in gst.
h. __________ is called heart of computer.
i. div tag is used to ____________.
j. ________ the syntax to link css file with html.
Read More
Do the following entries:-
1. Cash received from ajay Rs 5000.
2. Goods purchase from Tiwari store Rs 15000.
3.Goods sold to Ekta Enterprise Rs 10000
4. Cheque(SBI) received from Ekta
Enterprise Rs 8000.
5. Cash paid to Tiwari Store Rs 10000.
6. Rent received by cash Rs 6000.
7. Interest paid by cash Rs 2000.
8. Cash deposit in SBI Rs 10000.
9. Cash withdraw from SBI Rs 5000.
10. Commission received by cheque(sbi) Rs 1000.
Read More