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 2A table containing descriptions of different types of charts is given below. Names of some charts are given below within the bracket. Fill them in front of their respective descriptions and complete the assignment.[Stock, Area, Bar, Pie, Line, and Radar]NameDescription It displays data in the form of long rectangular rods also called bars. This chart displays data in the form of a circle. It emphasizes the magnitude i.e., the volume of change over time. It is designed specifically for plotting data values related to stocks and shares. It is in the form of lines and is used to illustrate trends in data at equal intervals. It is a type of chart that resembles a spider net.

Accepted Answer

NameDescriptionBarIt displays data in the form of long rectangular rods also called bars.PieThis chart displays data in the form of a circle.AreaIt emphasizes the magnitude i.e., the volume of change over time.StockIt is designed specifically for plotting data values related-to stocks and shares.LineIt is in the form of lines and is used to illustrate trends in data at equal intervals.RadarIt is a type of chart that resembles a spider net.

Question 3

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 4

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 5

Question 1What is the default format for expressing numbers in Excel?GeneralPercent-1234User-defined

Accepted Answer

GeneralReason — General is the default format for expressing numbers in Excel.

Question 6

Question 2Which tab is used to set the horizontal and vertical alignment for data in cells?NumberFontAlignmentBackground

Accepted Answer

AlignmentReason — Alignment tab is used to set the horizontal and vertical alignment for data in cells.

Question 7

Question 3Which feature in Excel is used to rotate text through a specified angle?Text OrientationText AlignmentText IndentText Formatting

Accepted Answer

Text OrientationReason — Text Orientation	feature in Excel is used to rotate text through a specified angle.

Question 8

Question 4Which term is used to define a graphical representation of data in a worksheet?TextTableCellsChart

Accepted Answer

ChartReason — Chart is used to define a graphical representation of data in a worksheet.

Question 9

Question 5What type of chart is used to emphasize the magnitude of change over time?PieAreaBarScatter

Accepted Answer

AreaReason — Area chart is used to emphasize the magnitude of change over time.

Question 10

Question 6............... chart is designed specifically for plotting data values related to stocks and shares.PieAreaBarStock

Accepted Answer

StockReason — Stock chart is designed specifically for plotting data values related to stocks and shares.

Question 11

Question 7In which group of the Home tab is the Format option available?ClipboardCellsFontNumber

Accepted Answer

CellsReason — The Format option is available in the Cells group of the Home tab.

Question 12

Question 8Name the type of chart which displays data in the form of a circle.PieAreaBarScatter

Accepted Answer

PieReason — Pie chart displays data in the form of a circle.

Question 13

Question 9What is the name for the horizontal axis of a chart?Y-axisLegendValue axisCategory axis

Accepted Answer

Category axisReason — The horizontal axis of a chart is called Category axis.

Question 14

Question 10Which component in Excel helps in depicting colors, patterns or symbols assigned to data series?FontLegendData RangeChart Area

Accepted Answer

LegendReason — Legend component helps in depicting colors, patterns or symbols assigned to data series.

Question 15

Question 11Which type of chart is used for representing huge amount of data?PieLineBarScatter

Accepted Answer

LineReason — Line chart is used for representing huge amount of data.

Question 16

Question 12What is the other name for XY chart?PieAreaBarScatter

Accepted Answer

ScatterReason — Scatter is the other name for XY chart.

Question 17

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.

Question 18

Question 14Name the item that forms the heading of a chart.LegendSubtitleValue axisChart Title

Accepted Answer

Chart TitleReason — Chart Title forms the heading of a chart.

Question 19

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.

Question 20

Question 16Name the type of chart which does not have grid lines.LineBarPieColumn

Accepted Answer

PieReason — Pie chart does not have grid lines.

Microsoft Excel 2010 - II

Application Based Questions

Multiple Choice Questions

State True or False

Theory Questions