Online Mock Test IP Class 12 | Modal Test IP Class 12 for Practice

1. Smita want to create a presentation for her project work, but she does not have PowerPoint installed on her computer. What free software she can download to complete her project?

2. Which of the following substance make e-waste hazardous in nature?

3. It refers to the proper manner and behavior we need to exhibit while being online?

4. Statement1: copyright grants legal right to protect our creative work as a property.
Statement2: Freeware source code is usually hidden from user.

5.(i) ____________ is data trail you leave while surfing internet without knowing you are doing so
(ii)____________ usually granted for Inventions.

6. Consider the following statements regarding Net etiquette and select which statements are TRUE:
Statement1: we should not use copyrighted material without permission of creator.
Statement2: we should not blindly believe in everything that we come across on social media
Statement3:we should respond to all mails and comments whether they have relevance or not

7. Which of the following is not an example of e-waste?

8. OSI stands for

9. loc uses ______ to access Series values.

10. What will be output of given code?
Import pandas as pd
s = pd.Series(2, index = range(3,9,3))
Print(S)

11. Which among the following is not a library?

12. What will be output of given code?
Import pandas as pd
S = pd.Series([30,80,70,12], index = [50,60,70,80])
print(s[70]+s[80])

13. Write the output of the given command:
import pandas as pd
S=pd.Series([8,2,6,1])
Print(S.sort_values().head())

14. Value and Size of series is

15. Which of the statement is correct to display last element of a Series object ‘S’ of shape 8.

16. What will be output of given code?
Import pandas as pd
S = pd.Series([10,20,30,40,50], index = [4,3,2,1,0])
Print(S.iloc[1])

17. Df.fillna(method = ‘pad’) will

18. To display row labels from Dataframe df we can use

19.Billu has created a dataframe ‘sale’ with data as given below.
	ID	Name	Jan	Feb	Mar
Delhi	1	Ram kumar	45	78	89
Kolkata	2	Suraj singh	76	45	81
Mumbai	3	Jai Shankar	45	80	66

His Manager asked him to count total no of columns it consist. Which command he can write to find it?

20. In Q19, Billu has been again asked to find the total sale of all three months and add to new column ‘total’. He is unable to do so. Help him to select the correct command.

21. In Q19, Billu want to show sale of mar with names of all salesmans. What code he should write to get the values?

22. Which of the following can not be used to create a dataframe?

23. Statement 1: Boolean indexed elements can not be accessed with loc
Statement 2: To divide a dataframe in two subset best suitable indexing is Boolean indexing

24. To display total no of rows and columns which of the following can be used?

25. Chandu has created following datafame ‘party’
partyA partyB partyC
Shyam 78 87 56
Charan 67 54 51
Lalla 54 71 82
Karmu 66 80 93
Now he wants to rename all the indexes by 1, 2, 3 and 4. What code he should write?

26. While merging two dataframes df1 and df2, we want to raise error if duplicate row labels are found. What code you think is most appropriate from given choices?

27. Sumit want to create (i) line and (ii) horizontal bar chart. But he is not getting the method name to create them. Help him to choose correct methods among given choices.

28. Which of the following is correct syntax to display histogram using DATAFRAME ‘df’?

29. Consider the two statements given below:
Statement 1: python pandas also have their own plot() for visualization as plot() of matplotlib.pyplot .
Statement 2: we can not create chart using dataframe containing data stored in CSV file.

30. Bydefault, legend is located at _______ corner of plot.

31. Identify the chart type

32. To save a dataframe to a text or csv file we can use

33. Which among the following argument is used in read_csv() to avoid particular rows while reading

34. For given dataframe book

create csv file lib.csv with columns bname and price.

35. By default, read_csv() uses the value of first row as column header in dataframes. Which argument will you give to ensure that the top/first row’s data is used as data and not as column header?