CBSE Class 6 Computer Science Question Paper Set 09 with Solutions

Answer: (a) Formula. A formula combines values, cell references and operators to calculate a result.

Teacher's Note:
1. A formula in Excel always starts with an equal to (=) sign.
2. Do not confuse it with a function, which is a ready-made formula.

Answer: (b) letter. A range name cannot begin with a number, so it starts with a letter.

Teacher's Note:
1. Range names also cannot contain spaces or look like a cell address such as A1.
2. A name like 1Marks is wrong, while Marks1 is correct.

Answer: (b) Pie. A pie chart shows each part as a slice of a circle.

Teacher's Note:
1. Pie charts show how parts make up a whole.
2. Bar charts use rectangles and scatter charts use dots.

Answer: (a) lowercase. Keywords such as if, while and for are written in lowercase, while True, False and None start with a capital letter.

Teacher's Note:
1. Python is case sensitive, so While is not the same as while.
2. Remember the three exceptions True, False and None.

Answer: (a) operands. In 5 + 3, the numbers 5 and 3 are operands and + is the operator.

Teacher's Note:
1. Operator does the work and operand receives the work.
2. Write one small example such as 5 + 3 to remember this.

Answer: (c) Datatypes. A data type tells Python what kind of value (such as integer, float or string) is stored and how it is kept in memory.

Teacher's Note:
1. A variable is only the name of a memory location, while the data type is the kind of value stored.
2. Common data types are int, float and str.

Answer: False. Python is case sensitive, so Name and name are two different identifiers.

Teacher's Note:
1. Case sensitive means capital and small letters are treated as different.
2. A common error is typing Print instead of print.

Answer: True. Operators such as +, −, × (*) and ÷ (/) tell the computer which calculation to do.

Teacher's Note:
1. Operators are symbols that show the action to be done.
2. The values they work on are called operands.

Answer: True. A sparkline is a tiny chart that fits inside a single cell and shows a trend in a row or column of data.

Teacher's Note:
1. Sparklines are drawn inside one cell, unlike normal charts that float over the sheet.
2. They are useful to see a trend quickly.

Answer: False. A function is the readymade operation; a formula is written by the user.

Teacher's Note:
1. A readymade formula is called a function, such as SUM.
2. Formula is made by you, function is made by Excel.

Answer: True. Gridlines are the horizontal and vertical lines in the plot area that help to read the values.

Teacher's Note:
1. Gridlines make it easy to read the value of a bar or point.
2. They can be switched on or off from the chart elements.

Answer: True. The Formula Bar shows the content or formula of the active (selected) cell.

Teacher's Note:
1. The cell shows the result while the Formula Bar shows the formula.
2. You can also edit a formula in the Formula Bar.

Answer: True. IDLE is the editor that comes with Python in which we write and run programs.

Teacher's Note:
1. IDLE stands for Integrated Development and Learning Environment.
2. It has a shell window for single lines and a script window for full programs.

Answer: F5. In the IDLE script window, F5 runs the program (same as Run > Run Module).

Teacher's Note:
1. Save the program first, as IDLE asks to save before running.
2. F5 is faster than using the menu.

Answer: cell. We can type directly in the active cell.

Teacher's Note:
1. The typed data appears in both the cell and the Formula Bar.
2. Press Enter to confirm the entry.

Answer: Formula Bar. We can select the cell and type in the Formula Bar above the sheet.

Teacher's Note:
1. Both methods give the same result in the cell.
2. The Formula Bar is also handy for editing long entries.

Answer: formula. Anything starting with = is treated as a formula and calculated.

Teacher's Note:
1. Forgetting the = sign makes Excel treat the entry as plain text.
2. For example, =A1+B1 adds two cells.

Answer: Parentheses (brackets). The part inside the brackets is calculated first.

Teacher's Note:
1. Brackets work as in mathematics: =(2+3)*4 gives 20 but =2+3*4 gives 14.
2. Use them whenever you want an operation done first.

Answer: elements. Chart elements include the title, axes, gridlines, legend and data series.

Teacher's Note:
1. Each chart element can be added, removed or formatted.
2. Learn the names: title, axes, legend, gridlines.

Answer: Chart Title. It describes what the chart shows.

Teacher's Note:
1. Give the chart a clear title so readers know what it is about.
2. Axis titles are different, as they label the axes.

Answer: 1. Formula: an expression written by the user using values, cell references and operators, starting with =, e.g. =A1+B1+C1.
2. Function: a readymade, predefined formula in Excel that performs a calculation, e.g. =SUM(A1:C1).
3. A formula is made by the user, while a function is supplied by Excel and is shorter to use.

Teacher's Note:
1. Give one example of each to score full marks.
2. Remember: a function is a ready-made formula.

Answer: 1. Tokens: the smallest individual units of a Python program, such as keywords, identifiers, literals, operators and punctuation.
2. Operators: symbols such as +, −, *, / that perform an operation on operands. Operators are one kind of token.
3. So every operator is a token, but not every token is an operator.

Teacher's Note:
1. Tokens is the bigger group and operators belong inside it.
2. Mention that keywords and variables are also tokens.

Answer: 1. SUM 2. AVERAGE 3. MAX 4. MIN (COUNT is also correct).

Teacher's Note:
1. Functions are written in capital letters, followed by brackets.
2. Learn what each one does, for example MAX gives the largest value.

Answer: Excel calculates a formula in a fixed order (BODMAS):
1. Operations inside parentheses ( ) first.
2. Then multiplication (*) and division (/), from left to right.
3. Then addition (+) and subtraction (−), from left to right.
Example: =2+3*4 gives 14, but =(2+3)*4 gives 20.

Teacher's Note:
1. Use an example to show the order clearly.
2. Operators of the same level are worked from left to right.

Answer: Structure of a function:
1. A function begins with the equal sign (=).
2. Then comes the function name, e.g. SUM.
3. Then the arguments (values, cell references or a range) are written inside parentheses and separated by commas.
Structure: =FUNCTION_NAME(argument1, argument2, ...). Example: =SUM(A1:A5).
OR
Chart: a graphical (picture) representation of the data in a worksheet.
Advantages: 1. Data is easier to understand. 2. Comparisons and trends are seen quickly. 3. It makes the report attractive. 4. It updates when the data changes.

Teacher's Note:
1. Always write the example with the structure.
2. In the chart option, give a definition plus at least three advantages.