Page 110 - TP_Modular_V2.1_Class7
P. 110
B. Fill in the blanks.
1. A set of values for the fields is called a .................................
2. Color Scales is a feature available in .................................
3. ................................ charts also known as XY scatter plot charts.
4. The ................................ statement is the simplest conditional statement.
5. Decision statements may give the results true or .................................
6. In Python, the non-zero value is interpreted as .................................
7. ................................ refers to process of stealing credit card numbers online.
8. ................................ are described as diary of events.
9. ................................ is a conversation that takes place in a friendly atmosphere.
C. Write ‘T’ for true and ‘F’ for false.
1. Before using the Subtotal command, data must be sorted in ascending or .....................
descending order.
2. You cannot sort more than one column at a time in a selected range of cells. .....................
3. Excel does not provide any tool to improve the appearance of a chart. .....................
4. AutoFill allows user to automatically fill a number or text series. .....................
5. The if statement executes a command if the provided condition evaluates
to true. .....................
6. The if...elif...else statement allows you to test multiple conditions. .....................
7. The deaf, mute and hard of hearing people can communicate with each other .....................
using sign language on video conference.
8. No one keeps a check on the comments of participants on newsgroup. .....................
Section B
A. Short answer type questions.
1. What is the use of the conditional formatting?
2. Define data series.
3. What is chart area?
4. Write the syntax for the if…elif…else statement.
5. What is Phreaking?
B. Long answer type questions.
1. What is the difference between sorting data and filtering data?
2. What is the difference between column chart and bar chart?
3. Write a python program to convert centimeters to inches. (Hint: 1 inch = 2.54 cms)
4. Discuss different types of communication techniques.
5. Define the types of cyber crimes.
108 Modular (Ver. 2.1)-VII

