PSEB Punjab Board Class 9 Computer Science Textbook Solution Chapter 4 MS Excel Part – II Exercise Questions and Answers
Q1) Multiple Choice Questions :-
(1) By default, each new workbook in MS Excel 2010 contains ……… number of worksheets.
(a) 5
(b) 2
(c) 255
(d) 3
Ans: (d) 3
(2) Which objects can be added in a worksheet?
(a) Cells
(b) Charts
(c) Rows
(d) All of these
Ans: (d) All of these.
(3) Which are the valid types of Charts in MS Excel.
(a) Bar, Column, Pie, Line
(b) Area, Doughnut, Scatter
(c) Surface, Radar, Bar
(d) All of these
Ans: d) All of these.
(4) Which function is used to find minimum number from the given range.
(a) AVERAGE
(b) MIN
(c) MAX
(d) RANK
Ans: (b) MIN
(5) ………… is a powerful tool of MS Excel used to have graphical representation of our data in MS Excel.
(a) Data Validation
(b) Conditional Formatting
(c) Charts
(d) None of these
Ans: (c) Charts
Q2) Write True or False :-
(1) New cell, row or columns, can be added by using Cut and + keys from keyboard.
Ans: True
(2) SUM and MIN are examples of Chart Types in MS Excel.
Ans: False
(3) Cell Borders, change cell width or height, Merge cells, Align Texts, Change Orientation of text, Wrap Text etc. are examples of cell styles.
Ans: True
(4) Conditional Formatting is a tool in MS Excel that allows applying formats to a cell or range of cells depending on the value.
Ans: True
(5) Formatting option effectively represents the information from facts of data.
Ans: True
Q3) Short Answer type Questions :-
(1) What do you mean by Formatting?
Ans :- Formatting means to make changes to the worksheet data in the form of changing font, its size, color and shading etc, after which the worksheet gets a professional and attractive look.
(2) What type of formatting can be used as Cell styles?
Ans :- Cell Border, Changing of Cell width, Changing of cell height, Merging cells, Aligning text, Changing orientation of text, wrap texts, change number formats etc are the formatting which can be used as Cell types.
(3) What do you mean by Merging Cells?
Ans :- Grouping of two or more cells together in a single cell is to be termed as Merging
and the cells belonging to the columns or rows of a table can be merged/ grouped together as per the requirement. The data in different/various cells can be converted into
one cell by merging cells.
4) Define alignments and its types.
Ans :- Alignment means changing the position of the text within the selected cell. Basically there are 3 types of alignment such as Left, Center, Right. By clicking on Right align will help you to place you selected text a the right side of the cell/document, Center means the selected text will be moved to the middle of the cell/document and left align will move to the left side. By default in Excel the text data is aligned to the left and number to the right.
5) What are charts?
Ans :- Excel provides the facility of chart that is used for showing the data into the pictorial form. One can select any of the chart from the various types of charts and its sub types available in Excel and represent the data in the pictorial form. With the help of
charts its much easier to compare, analyze, evaluate the worksheet and take a quick
decision. After inserting charts in your worksheet, your worksheet will look much descent and attractive. Once you make a click on Insert tab, different types of charts will be available like column line, pie, bar, scatter etc.
Q4) Long Answer type Questions :-
1) What is Conditional Formatting? Explain its different options.
Ans :- As the name suggests, Conditional Formatting is a tool in MS Excel, which helps
the user in applying the different forms of formats to the selected cells or a range which
totally depends only if that value meets the defined/required condition. By making use of
this tool, we can highlight the specific cells with different formats in order to show the
valued facts. For ex:- While preparing the result, if incase it is required /or if the condition is applied such as the highlight the students marks who had scored more than 80% marks, then you ,may see that certain cells of the students who had scored marks more than 80% is highlighted with some colors or formats.
❖ Highlight Cell Rules :- In this option you may highlight the data of selected cells in the specific row or columns by applying a different types of formatting if that cell matches the defined criteria or condition. It includes the formatting options as Greater than, Less than, Between, Equal to, Text that contains, A date occurring, Duplicate values etc.
❖ Top/Bottom Rules :- This option is used for highlighting the data of the selected cells of the rows or columns by applying the specified conditions. If the data of the cell meets the specified condition then it will be highlighted. This option provides us different formatting options such as Top 10 items, Top 10%, Bottom 10 items, Bottom 10%, Above average and Below average.
❖ Data Bars :- This option is used for highlighting the cells of the selected specified columns or rows different forms of bars or by the gradient fills. The data in the selected cells of the rows and columns are highlighted with the data bars and the gradient fill.
❖ Color Scales :- This option is used for highlighting the data in the cells of the specified columns or rows by applying different form of color scales.
❖ Icon Sets :- In this option we may highlight the data of the cells of the specific
rows or columns by inserting different types of icons as formatting. The icons
includes Directional arrows, Shapes, Indicators, Ratings etc.
2) What are Charts? Give the name of any five charts
Ans :- Excel provides the facility of chart that is used for showing the data into the pictorial form. One can select any of the chart from the various types of charts and its sub types available in Excel and represent the data in the pictorial form. With the help of charts its much easier to compare, analyse, evaluate the worksheet and take a quick
decision. After inserting charts in your worksheet, your worksheet will look much descent and attractive. Once you make a click on Insert tab, different types of charts will
be available like column line, pie, bar, are scatter etc.
Usefulness of Charts in Excel
(i) By making use of chart in Excel, it is much easier for one to understand.
(ii) Important data and information can be presented in an attractive, beautifully way.
There are different types of charts which are :-
a) Column Chart :- The data in this type of chart is been changed after a period of
some time and helps in comparing in various items. In column chart, the categories are been arranged in horizontal axis and values with the vertical axis.
b) Bar Chart :- This chart is displayed in the table or column form. In this chart, it is also shown that after some period of time, the data is changed or is been compared with some of the specific individual items.
c) Line Chart :- In this type of chart, there is continuous flow of data is shown over a
time and is setted against the common scale and are therefore ideal for showing
trends in data equal intervals. In this chart, the category data is shown on the
horizontal axis where as all the value data is to be shown on the vertical axis.
d) Area Chart :- In this type of chart magnitude of change over time is shown. It also
shows the relationship of parts to a whole by displaying the sum of a plotted value.
e) Pie Chart :- This chart type is round/circle in shape which is being divided into
pieces of slices. The type of chart that shows the contribution of each value to a
total value (represented by overall pie). In one data series in this chart type the size
of things are been compared. In the pie chart, the data points is displayed as the
percentage of the whole pie.
3) Explain any three objects which can be added in MS Excel worksheet.
Ans :- Following are the three objects that you add in MS Excel worksheet
a) Inserting Cells :- Cell is the basic unit of the Excel worksheet. Cells are made up of
by intersecting the rows and columns. Cells in the worksheet are used for entering
data/information. We can apply different formatting to the cells depending upon
the specified criteria/condition. Active cell can be recognized as the border of that
particular/active cell is highlighted with a dark black colour which may look
different from rest of cells in the worksheet. If you want/need of adding any extra
cells into the worksheet, then you can easily add it.
The steps for adding extra cells in the worksheet are as followed :-
- Click anywhere in the worksheet where you want to add the cell.
- Go to the Insert tab —– Select the option as Insert Cell from the Home tab
ribbon. - Make a click on the required option and press the OK button.
b) Inserting Charts :- Excel provides the facility of chart that is used for showing the
data into the pictorial form. One can select any of the chart from the various types
of charts and its sub types available in Excel and represent the data in the pictorial
form. With the help of charts its much easier to compare, analyze, evaluate the
worksheet and take a quick decision. After inserting charts in your worksheet, your
worksheet will look much descent and attractive. Once you make a click on Insert
tab, different types of charts will be available like column line, pie, bar, are ,scatter
etc.
The steps for inserting charts in the worksheet are as followed :-
- We need to select the range of cells (of data) that is required for inserting
chart. - Go to the Insert tab and make a click on any of the chart of your choice requirement under the Charts group.
- You may notice that the chart is appearing in the worksheet that is currently active.
c) Inserting Rows and Columns :- Worksheet is made up rows and columns. There
are 16384 columns and 10,48,576 rows total in a single worksheet. The columns
are labelled alphabetically from A to XFD and rows from 1 to 10,48,576.
If incase you wish to add an extra row/column in your worksheet, then you need
to follow this steps :-
- Click on the cell and make it selected, where you wish to insert a new
column or row in a worksheet. - Now go to the Home tab ——– select the option as Insert sheet
rows/Insert sheet columns (as per your need) ———- you may notice that
the new column/row will be inserted automatically at the place of the
selected cells.
Dear Student, I appreciate your efforts and hard work that you all had put in. Thank you for being concerned with us and I wish you for your continued success.
For more update, follow this page ⇒ PSEB Notes and Solutions