Question 1

Question 1A chart displaying the subject wise attendance of four students and its source data have been given to you. Answer the following questions based on them:(i) Identify the Type of chart.(ii) What is the title of the chart?(iii) List the cell references of the three cell ranges used to produce this chart.(iv) Suggest a suitable label for both category axis and value axis.

Accepted Answer

(i) The given chart is a type of stacked bar chart.(ii) The title of the chart is 'Student Attendance Record'.(iii) The cell references of the three cell ranges used to produce this chart are:B2 : B5C2 : C5D2 : D5(iv) A suitable label for Category Axis can be 'Student Name'.A suitable label for Value Axis can be 'Number of Days'.

Question 2

Question 3A 3D line chart on Employee Payroll System is given below. Apply the following formatting effects to the chart:(i) Change the Chart Title to 'Employee Salary and Bonus'.(ii) Change the title of X axis to 'Names' and Y axis to 'Amount'.(iii) Change the Font of Chart Title to 'Tahoma', Font size as 16, Font style as Bold and Font color as blue.(iv) Change the scale for Y axis and display the values between 100 to 8500.

Accepted Answer

(i) We can follow the given steps to change the chart title:Step 1 — Double-click on the chart title.Step 2 — A textbox appears around the title.Step 3 — Delete the previous title and type 'Employee Salary and Bonus' in the text box.Step 4 — Click outside the chart area and the Chart Title will be changed.(ii) We can follow the given steps to change the title of X axis:Step 1 — Double-click on the title of X axis.Step 2 — A textbox appears around the title.Step 3 — Delete the previous title and type 'Names' in the text box.Step 4 — Click outside the chart area and the title of X axis will be changed.Similarly, the title of Y-axis can be changed by clicking on the title of Y axis and replacing the previous title with 'Amount' in the text box.(iii) We can follow the given steps to format the Chart Title:Step 1 — Click on the chart title and select it.Step 2 — Go to the 'Home' tab on the Excel ribbon.Step 3 — Use the Font options to change the font to 'Tahoma', size to 16, style to Bold, and color to blue.(iv) We can follow the given steps to change the scale for Y axis and display the values between 100 to 8500:Step 1 — Click on the chart to select it.Step 2 — Point the mouse at Y-axis. Right-click on it and select the Format Axis option from the Shortcut menu.Step 3 — The Format Axis dialog box will open. The Axis Options tab is selected by default. Click on the Fixed radio button for Minimum field and enter 100 in the text box.Step 4 — Similarly, enter 8500 in the text box of the Maximum field. Click on Close button. The scale on the chart changes accordingly.

Question 3

Question 4An Area chart depicting the trends in Bills over different months is shown along with its source data. Apply the formatting effects given below to the Area chart then print this chart along with the worksheet data.(i) Apply a border to the Chart area and also apply a background color of your choice.(ii) Using the Gradient Fill option, set the background for the Plot area as 'Moss'.(iii) Apply a border to the Legend and position it at the bottom of the chart.

Accepted Answer

(i) We can follow the given steps to apply a border to the chart area:Step 1 — Right-click on the Plot area and select the Format Plot Area option. The Format Plot Area dialog box appears.Step 2 — Select 'Border Styles', 'Border Color', 'Shadow', etc.Step 3 — By default, the Fill tab is selected. Select the Solid fill option in the right pane.Step 4 — Click on the Color button and select the desired colour from the drop­ down menu.Step 5 — Click on Close button.We can follow the given steps to apply a background color of our choice:Step 1 — Click on the chart to select it.Step 2 — Right-click and choose "Format Chart Area."Step 3 — In the Format Chart Area pane, choose 'Fill & Line.'Step 4 — Click on 'Fill' and choose the background color.(ii) We can follow the given steps to set the background for the Plot area as 'Moss':Step 1 — Click on the plot area of the chart.Step 2 — Right-click and choose "Format Plot Area."Step 3 — In the Format Plot Area pane, go to the Fill options.Step 4 — Choose 'Gradient Fill' and set the gradient colors, selecting 'Moss' as one of the colors.(iii) We can follow the given steps to apply a border to the Legend and position it at the bottom of the chart:Step 1 — Click on the legend to select it.Step 2 — Right-click and choose "Format Legend."Step 3 — In the Format Legend pane, go to the Border Color option and choose a border color. Adjust the Border Styles and Weight as needed.Step 4 — To position the legend at the bottom, right-click and choose 'Legend Options'.Step 5 — Click on Bottom in the Position option.

Question 4

Question 13When a chart is placed inside a worksheet along with its source data, it is called ................ .Chart WallEmbedded ChartChart SheetChart Area

Accepted Answer

Embedded ChartReason — When a chart is placed inside a worksheet along with its source data, it is called Embedded Chart.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, Chart, Placed, Inside, Worksheet, Source. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q14: Question 14 Page Preview is used to check the overall content and formatting of a worksheet.
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 5

Question 15The first Pie chart was seen in William Playfair's book of 'Statistical Breviary' in ............... .1908180218051801

Accepted Answer

1801Reason — The first Pie chart was seen in William Playfair's book of 'Statistical Breviary' in 1801.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, First, Pie, Chart, Seen, William. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q14: Question 14 Page Preview is used to check the overall content and formatting of a worksheet.
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 6

Question 14Page Preview is used to check the overall content and formatting of a worksheet.

Accepted Answer

TrueReason — Page Preview is used to check the overall content and formatting of a worksheet.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, Page, Preview, Check, Overall, Content. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q15: Question 15 The first Pie chart was seen in William Playfair&#x27;s book of &#x27;Statistical Breviary&#x27; in...
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 7

Question 16There are only two types of charts in Excel.

Accepted Answer

FalseReason — There are eleven types of charts commonly used in Excel.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, There, Charts, Excel, Microsoft Excel 2010 - II, Computer Applications. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q14: Question 14 Page Preview is used to check the overall content and formatting of a worksheet.
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 8

Question 17MS Excel does not have option to preview the worksheet before sending it to print.

Accepted Answer

FalseReason — Ctrl + F2 key combination can be used to show the print preview of the worksheet.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, Excel, Option, Preview, Worksheet, Sending. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q14: Question 14 Page Preview is used to check the overall content and formatting of a worksheet.
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 9

Question 18A Pie chart compares pieces of data using horizontal stacks.

Accepted Answer

FalseReason — A pie chart displays data in the form of a circle that is divided into a series of segments. It shows the proportional size of individual items that makes up a data series to the sum of items.

Question 10

Question 19Chart represents only pictorial information.

Accepted Answer

FalseReason — A chart is a graphical representation of data in a worksheet. It helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparison and see growth, relationship among the values and trends in data.

Question 11

Question 20The Doughnut chart displays data in the form of bars.

Accepted Answer

FalseReason — The Doughnut chart displays data as sections of a circle. It can have more than one data series, which attempts to add another dimension to the Pie chart.

Source: This question is from Microsoft Excel 2010 - II, Computer Applications &mdash; Class 9, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Microsoft Excel 2010 - II: Question, Doughnut, Chart, Displays, Data, Form. These are fundamental topics in Computer Applications that students are expected to master as part of the CBSE Class 9 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Applications papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Microsoft Excel 2010 - IIQ1: Question 1 A chart displaying the subject wise attendance of four students and its source data have...
Q10: Question 10 What is Pie chart? Describe its features.
Q11: Question 11 Explain the process of printing a complete workbook.
Q12: Question 12 Describe the text formatting features of MS Excel and how are these useful.
Q14: Question 14 Page Preview is used to check the overall content and formatting of a worksheet.
Practice more questions from Microsoft Excel 2010 - II &mdash; Computer Applications, Class 9 CBSE

Question 12

Question 2Which formatting effects can you apply using the Home tab? Explain a few.

Accepted Answer

Home tab provides us access to many groups which can be used to apply various formatting effects. Some of the formatting effects are as follows:Formatting Numbers — Numbers in Excel can be presented in different formats. By default, numbers are expressed in General format. The other formats for numbers are number, currency, accounting, date, time, percentage, fraction etc.Change Font — MS Excel offers Font option in the Font group to change the font of text.Change Font Size — MS Excel offers Size option in the Font group to change the font size of text.Font Style — MS Excel offers three font styles — Bold, Italics and Underline to emphasize the text.Cell Alignment — We can change the cell alignment in both ways i.e horizontally as well as vertically from the Alignment group of the Home tab.Text Alignment — It is used to align the text vertically and horizontally. Vertical alignment has the options — top, middle and bottom. Horizontal alignment has the options — left, center and right.

Question 13

Question 5Name the option which is used to see the output before printing. How is it used in Excel?

Accepted Answer

Print Preview option is used to see the output before printing.To view the print preview of the spreadsheet, we follow the steps given below:Step 1 — Click on the File tab and select the Print option.Step 2 — A preview of worksheet automatically appears on the right side of the 'Print' pane.Step 3 — If the worksheet contains more than one page, then click on the Next Page or Previous Page arrow buttons present at the bottom of the Preview window.Step 4 — To exit Print Preview, simply press the Esc key

Question 14

Question 6What is a Scatter chart?

Accepted Answer

Scatter chart either shows the relationships in several data series or plots two groups of numbers as one series of XY co-ordinates. This chart shows uneven intervals or cluster of data and is commonly used for displaying scientific data.X axis is usually assigned to an independent variable, the variable whose value is controlled or set by the experimenter. The Y variable then becomes the dependant variable. Its each value depends upon the corresponding value of variable X.

Question 15

Question 7Define Embedded Chart.

Accepted Answer

Excel offers the features to create an Embedded chart in a worksheet. It is displayed along with source data and other information present in a worksheet. An embedded chart is saved with the corresponding worksheet when a workbook is saved.

Question 16

Question 8What is the difference between Radar chart and Stock chart?

Accepted Answer

Radar chartStock chartRadar chart looks similar to a spider net. It displays data values plotted as points which are connected by lines to form a grid.Stock chart is a type of column graph, which has been designed specifically for plotting data values related to stocks and shares or fluctuation of daily or annual temperature.It is useful for comparing data that is not time dependent, but shows different circumstances such as variables in a scientific experiment or direction.The data required for these charts consists of specific data series like opening price, closing price, and high and low prices.The poles of the Radar chart are equivalent to the Y-axis of other charts.In this type of chart, the X-axis represents a time series.

Question 17

Question 9Explain the different components of a chart.

Accepted Answer

The different components of a chart are as follows:Chart Area — Chart area includes all the area and objects in the chart.Category Axis — Category axis or X-axis is the	horizontal axis of a chart.Value Axis — Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.Data Series — Data series are the bars, slices or other elements that show the data values. If there are multiple data series in the chart, each will have a different colour or style.Category Name — Category names are the labels, which are displayed on the X and Y­ axis.Plot Area — Plot area is a window within the Chart area. It contains the actual chart itself and includes plotted data, data series, category, and value axis.Legend — It depicts the colours, patterns, or symbols assigned to the data series. It helps to differentiate the data.Chart Title — It describes the aim and contents of the chart.Gridlines — These can either be horizontal or vertical lines depending on the selected chart type. They extend across the plot area of the chart. Gridlines make it easier to read and understand the values.

Question 18

Question 10What is Pie chart? Describe its features.

Accepted Answer

Pie chart displays data in the form of a circle that is divided into a series of segments.The features of a Pie chart are as follows:It shows the proportional size of individual items that makes up a data series to the sum of items.It always shows only one data series and is useful when we want to emphasize on a significant element.This chart works best with smaller number of values.

Question 19

Question 11Explain the process of printing a complete workbook.

Accepted Answer

We follow the given steps to print a complete workbook:Step 1 — Click the File tab and select Print to access the Print pane.Step 2 — Select the option Print Entire Workbook from the print range drop-down menu in the Settings section.Step 3 — Change the page orientation either Portrait or Landscape from the Orientation drop-down list.Step 4 — Choose the printer from the Printer drop-down list.Step 5 — Enter the number of copies in the Copies spin box.Step 6 — After selecting all the required options, click on the Print button.The entire workbook will be printed.

Question 20

Question 12Describe the text formatting features of MS Excel and how are these useful.

Accepted Answer

MS Excel offers various formatting features to improve the appearance of text. You can change the text alignment, font, color, size, style, etc. through the formatting effects available in MS Excel. The text formatting features are as follows:Font Styles and Sizes — Excel allows users to customize text with various font styles and sizes, facilitating emphasis on specific information.Bold, Italics, and Underline — Users can apply these formatting options to highlight or differentiate data, making it visually appealing and easier to read.Text Alignment — Excel provides options for aligning text within cells, such as left, right, center, or justified, improving the overall presentation of data.Cell Merging and Wrapping — Merging cells creates custom layouts, while text wrapping ensures that lengthy text fits within a cell, preventing overflow and maintaining a tidy appearance.Text Orientation — This feature is used to rotate the text through a specified angle. Tilting text at an angle can enhance the visibility of data labels and can contribute to the overall aesthetics of the spreadsheet.

Microsoft Excel 2010 - II

Application Based Questions

Multiple Choice Questions

State True or False

Theory Questions