Class 12 IP: Python Pandas 50 MCQs Online Practice Test (Instant Result)

Class XII - Informatics Practices (065)

Python Pandas – I & II | 50 Important MCQs Test

📋 Total Questions: 50 🎯 Full Marks: 50 ⏱️ CBSE Board Prep

1. Which of the following is the correct way to import Pandas?

A. import pandas as pd B. import pd as pandas C. include pandas D. import panda

2. Which Pandas data structure is one-dimensional and labelled?

A. DataFrame B. Series C. Array D. Tuple

3. Which Pandas data structure is two-dimensional?

A. Series B. List C. DataFrame D. Dictionary

4. Which function is used to create a Series?

A. pd.series() B. pd.Series() C. pd.createSeries() D. pd.SeriesData()

5. Which function is used to create a DataFrame?

A. pd.Frame() B. pd.dataframe() C. pd.DataFrame() D. pd.createFrame()

6. By default, how many rows are displayed by head()?

A. 3 B. 5 C. 7 D. 10

7. Which function displays the last five rows of a DataFrame by default?

A. start() B. last() C. tail() D. bottom()

8. Which function is used to read a CSV file in Pandas?

A. pd.open_csv() B. pd.read_csv() C. pd.get_csv() D. pd.csv_read()

9. Which method is used to save a DataFrame as a CSV file?

A. save_csv() B. write_csv() C. to_csv() D. export_csv()

10. In a Series, labels associated with values are called:

A. Columns B. Indexes C. Fields D. Headers

11. What does df.shape return?

A. Only number of rows B. Only number of columns C. Rows and columns as a tuple D. Data types

12. What does df.columns return?

A. Row labels B. Column labels C. Data values D. Data types

13. What does df.index return?

A. Column names B. Row labels/index C. Number of rows D. Data types

14. Which attribute displays the data types of columns?

A. df.type B. df.dtype C. df.dtypes D. df.datatype

15. Which argument is commonly used in drop() to specify a column?

A. axis=0 B. axis=1 C. column=1 D. col=True

16. Which value commonly represents a missing value in Pandas?

A. NULL B. 0 C. NaN D. EMPTY

17. Which of the following creates a Series with values 10, 20 and 30?

A. pd.Series([10,20,30]) B. pd.series(10,20,30) C. pd.Series(10,20,30) D. pd.create([10,20,30])

18. What is the default index of pd.Series([10,20,30])?

A. 1,2,3 B. 0,1,2 C. 10,20,30 D. a,b,c

19. What is the output of s[1] if s = pd.Series([10,20,30])?

A. 10 B. 20 C. 30 D. Error

20. Which expression selects elements from position 1 up to but not including 4?

A. s[1:4] B. s[1,4] C. s[0:4] D. s[1::4]

21. Which statement creates a Series from a dictionary?

A. pd.Series({'A':10,'B':20}) B. pd.Series(A=10,B=20) C. pd.DictionarySeries({'A':10}) D. pd.SeriesDict({'A':10})

22. When a scalar is used to create a Series, what is required?

A. A CSV file B. An index C. A DataFrame D. A column name

23. Which statement is correct for scalar Series creation?

A. pd.Series(5, index=['A','B']) B. pd.Series([5], index='A') C. pd.Series.scalar(5) D. pd.scalarSeries(5)

24. Which operator can be used for element-wise addition of two compatible Series?

A. + B. // C. ** D. <>

25. Which method returns the maximum value of a Series?

A. largest() B. max() C. maximum() D. top()

26. Which method returns the minimum value of a Series?

A. min() B. minimum() C. smallest() D. bottom()

27. Which method returns the sum of values in a Series?

A. total() B. add() C. sum() D. plus()

28. Which statement creates a DataFrame from a dictionary of lists?

A. pd.DataFrame({'Name':['A','B'],'Marks':[80,90]}) B. pd.DataFrame(['Name','Marks'], values=[[1,2]]) C. pd.DataFrame.from_list({'Name':'A'}) D. pd.DataFrame(list_dict)

29. Which attribute returns the underlying data of a DataFrame as a 2D numpy ndarray?

A. df.data B. df.values C. df.ndarray D. df.array

30. How do you access a specific column 'Name' in a DataFrame 'df'?

A. df.Name or df['Name'] B. df(Name) C. df.get_col('Name') D. df{Name}

31. Which method is used to rename row or column labels in a DataFrame?

A. change_labels() B. modify() C. rename() D. update_labels()

32. How can you add a new column 'Age' to an existing DataFrame 'df'?

A. df.add_column('Age', [18, 19]) B. df['Age'] = [18, 19] C. df.insert('Age') D. df.append('Age')

33. Which method is used to delete rows or columns from a DataFrame?

A. remove() B. delete() C. drop() D. clear()

34. What parameter makes modifications permanent in place when using drop() or fillna()?

A. permanent=True B. inplace=True C. commit=True D. save=True

35. Which indexer is label-based for selection in Pandas?

A. iloc B. loc C. index D. label

36. Which indexer is integer-position based for selection in Pandas?

A. loc B. iloc C. position D. int_loc

37. Which function checks for null/missing values in a DataFrame and returns a boolean DataFrame?

A. isnull() or isna() B. check_null() C. hasna() D. find_missing()

38. Which function is used to fill missing values with a specific scalar value?

A. replace_na() B. fillna() C. set_na() D. insert_na()

39. Which method removes rows containing any missing values?

A. df.drop_na() B. df.dropna() C. df.clearna() D. df.removena()

40. What does df.T represent?

A. Total rows B. Transpose (rows become columns and vice versa) C. Tail of DataFrame D. Top values

41. Which function provides descriptive statistics like mean, count, min, max, and std for numerical columns?

A. summary() B. describe() C. statistics() D. info_stats()

42. Which method gives a concise summary of a DataFrame including data types and non-null counts?

A. df.info() B. df.summary() C. df.details() D. df.stat()

43. What is the return type of `df['Col1'].mean()`?

A. Series B. DataFrame C. Scalar (float/int value) D. List

44. Which parameter in `read_csv()` specifies the column to use as the row label index?

A. row_col B. index_col C. set_index D. label_index

45. How do you sort a DataFrame 'df' by column 'Score' in descending order?

A. df.sort_values(by='Score', ascending=False) B. df.sort('Score', desc=True) C. df.sort_index(by='Score', reverse=True) D. df.order('Score', descending=True)

46. What does `s.ndim` return for a Pandas Series `s`?

A. 0 B. 1 C. 2 D. Number of elements

47. What does `df.ndim` return for a Pandas DataFrame `df`?

A. 1 B. 2 C. Number of columns D. Total cells

48. Which attribute returns the total number of elements (rows × columns) in a DataFrame?

A. df.count B. df.size C. df.length D. df.total_elements

49. What happens when two Series with non-matching indexes are added together using `+`?

A. Python raises a ValueError B. Matching index labels are added, and non-matching indexes result in NaN C. Non-matching indexes are ignored completely D. Indexes are automatically reindexed sequentially from 0

50. Which method can be used to rename columns or indices using a mapping dictionary?

A. df.map() B. df.reindex() C. df.rename(columns={'old':'new'}) D. df.change_names()

Class 10 Computer Application Question Paper 2026-27 with Answer Key

SAMPLE QUESTION PAPER  (2026–27)

Class-X | Computer Application

⏱️ TIME: 02:00 HOURS                                                                             📝 MAX MARKS: 50

📌 General Instructions

• The question paper contains 5 sections labeled A through E.
• Compulsory Questions: All questions are mandatory, though internal choices are provided.
• Section A: 12 MCQs (1 mark each = 12 Marks).
• Section B: 7 Short Answer questions (2 marks each = 14 Marks).
• Section C: 4 Long Answer-I questions (3 marks each = 12 Marks).
• Section D: 1 Long Answer-II question (4 marks = 4 Marks).
• Section E: 2 Case-based questions (4 marks each = 8 Marks).

SECTION - A (Objective / MCQs) 12 × 1 = 12 Marks

1. What does WWW stand for?

a) World Wide Web

b) World Web Wide

c) Web World Wide

d) Wide World Web

💡 Show Answer

Answer: a) World Wide Web

2. Which of the following is used to identify a website on the Internet?

a) URL

b) CPU

c) RAM

d) ROM

💡 Show Answer

Answer: a) URL

3. Which protocol is commonly used for accessing web pages?

a) HTTP

b) FTP

c) SMTP

d) POP

💡 Show Answer

Answer: a) HTTP

4. Which Internet service is mainly used for sending and receiving electronic messages?

a) E-mail

b) FTP

c) WWW

d) Video conferencing

💡 Show Answer

Answer: a) E-mail

5. Which attribute specifies the path/location of an image in HTML?

a) href

b) alt

c) src

d) link

💡 Show Answer

Answer: c) src

6. Which HTML tag is used to create a hyperlink?

a) <a>

b) <link>

c) <href>

d) <url>

💡 Show Answer

Answer: a) <a>

7. Which attribute is used with the <a> tag to specify the destination of a link?

a) src

b) href

c) target

d) alt

💡 Show Answer

Answer: b) href

8. Which HTML tag is used to create a table row?

a) <td>

b) <th>

c) <tr>

d) <table>

💡 Show Answer

Answer: c) <tr>

9. Which tag is used to create a table heading/cell heading?

a) <td>

b) <th>

c) <tr>

d) <caption>

💡 Show Answer

Answer: b) <th>

10. Which Internet service allows users to transfer files from one computer to another?

a) E-mail

b) FTP

c) Chat

d) Search engine

💡 Show Answer

Answer: b) FTP

11. Assertion (A): The <a> tag is used to create a hyperlink in an HTML document.
Reason (R): The href attribute specifies the destination URL of the hyperlink.

a) Both A and R are true, and R is the correct explanation of A.

b) Both A and R are true, but R is not the correct explanation of A.

c) A is true, but R is false.

d) A is false, but R is true.

💡 Show Answer

Answer: a) Both A and R are true, and R is the correct explanation of A.

12. Assertion (A): The <img> tag is used to insert an image into an HTML webpage.
Reason (R): The src attribute specifies the location or path of the image.

a) Both A and R are true, and R is the correct explanation of A.

b) Both A and R are true, but R is not the correct explanation of A.

c) A is true, but R is false.

d) A is false, but R is true.

💡 Show Answer

Answer: a) Both A and R are true, and R is the correct explanation of A.

SECTION - B (Short Answer Questions) 7 × 2 = 14 Marks

13. Explain the difference between SMTP and POP protocols.

💡 Show Answer

Answer: SMTP (Simple Mail Transfer Protocol) is used for sending outgoing emails from a client to a server. POP (Post Office Protocol) is used for retrieving incoming emails from a server to a local device.

14. What is a web browser? Give two examples of web browsers.

💡 Show Answer

Answer: A web browser is software used to access and view web pages on the Internet.
Examples: Google Chrome, Mozilla Firefox.

15. What is a URL? Write its full form and explain its purpose.

💡 Show Answer

Answer: Full form: Uniform Resource Locator.
Purpose: It serves as the unique web address of a specific resource (webpage, file, image) on the Internet.

16. Explain E-mail with an example? Mention any two advantages of an E-mail.

💡 Show Answer

Answer: E-mail is a method of exchanging digital messages over the Internet (e.g., student@example.com).
Advantages:
1. Fast and instant delivery.
2. Cost-effective and paperless.

17. A webpage contains text that takes the user to another website when clicked. What is this feature called? Explain its use.

💡 Show Answer

Answer: It is called a Hyperlink.
Use: It allows users to jump instantly from one webpage or document to another.

18. Write the purpose of the following attribute: a) cellpadding b) cellspacing

💡 Show Answer

Answer:
a) cellpadding: Space between cell content and its border.
b) cellspacing: Space between individual adjacent table cells.

19. Differentiate between rowspan and colspan attributes with examples.

💡 Show Answer

Answer:
• rowspan: Merges cells vertically across rows (e.g., <td rowspan="2">).
• colspan: Merges cells horizontally across columns (e.g., <td colspan="3">).

SECTION - C (Long Answer Questions - I) 4 × 3 = 12 Marks

20. Rohan wants to use the Internet for different purposes (sending teacher messages, online classes, transferring files, buying books). Identify the four Internet services.

💡 Show Answer

Answer:
1. E-mail: For sending messages.
2. Video Conferencing: For online classes.
3. FTP: For file transfers.
4. E-commerce: For online shopping.

21. Neha wants to display school logo (school.jpg) with alt text. Answer the questions:

a) Which tag? b) Which attribute? c) Write the HTML code.

💡 Show Answer

Answer:
a) Tag: <img>
b) Attribute: src
c) Code: <img src="school.jpg" alt="School Logo">

22. Aman wants to create website and email link for school@example.com. Answer the questions:

a) Which tag? b) Which attribute? c) Write HTML code for email link.

💡 Show Answer

Answer:
a) Tag: <a>
b) Attribute: href
c) Code: <a href="mailto:school@example.com">Send Email</a>

23. Functions of <table>, <tr>, <th>, <td> and code example for 3 students' marks.

💡 Show Answer

Answer:
• <table>: Creates table container.
• <tr>: Table Row | <th>: Header Cell | <td>: Data Cell.

<table border="1"><tr><th>Name</th><th>Marks</th></tr><tr><td>Amit</td><td>85</td></tr><tr><td>Priya</td><td>92</td></tr><tr><td>Rahul</td><td>78</td></tr></table>

SECTION - D (Long Answer Question - II) 1 × 4 = 4 Marks

24. Types of Lists in HTML OR Physical vs Logical Tags with examples.

💡 Show Answer

Answer (Types of Lists):
1. Unordered List: <ul>, <li>
2. Ordered List: <ol>, <li>
3. Description List: <dl>, <dt>, <dd>

Answer (Physical vs Logical):
• Physical: <b>, <i>, <u> (Visual styling)
• Logical: <strong>, <em> (Semantic importance)

SECTION - E (Case-Based Questions) 2 × 4 = 8 Marks

25. Case Study 1: List Tags

1. Unordered list tag? 2. Item tag? 3. Description term tag? 4. Description detail tag?

💡 Show Answer

Answers: 1. <ul> | 2. <li> | 3. <dt> | 4. <dd>

26. Case Study 2: Table Attributes

1. Space between cells? 2. Space inside cell? 3. Border purpose? 4. Bgcolor purpose?

💡 Show Answer

Answers:
1. cellspacing
2. cellpadding
3. Sets border thickness.
4. Sets table/cell background color.