Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 1 of 56

Microsoft Excel 2010 - II — Question 1

Back to all questions
1
Question

Question 1

A 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:

A 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. Computer Applications Code 165 Kips Cyber Beans Solutions Class 9 CBSE.
A 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. Computer Applications Code 165 Kips Cyber Beans Solutions Class 9 CBSE.

(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.

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:

  1. B2 : B5
  2. C2 : C5
  3. D2 : D5

(iv) A suitable label for Category Axis can be 'Student Name'.

A suitable label for Value Axis can be 'Number of Days'.