IT Planet Class 6 Computer Chapter 5 Solution – Introduction To Ms – Excel
IT Planet Class 6 Solution: IT Planet Class 6 Computer Chapter 5 Introduction To Ms – Excel all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter Introduction To Ms – Excel Solution.
Q1) Tick the (√) the correct answer :-
a) A spreadsheet program that organizes data in rows and columns is called
Ans i) Excel
b) The collection of rows and columns is called
Ans ii) Worksheet
c) The intersection of row and column is called
Ans iii) Cell
d) Number of worksheets you can have in Excel file
Ans iii) 255
e) The number of rows in a single worksheet is
Ans ii) 1048576
f) The cell that has a dark border around it is called
Ans i) Active cell
g) Selected group of cells is called
Ans i) Range
h) It gives the cell reference using the combination of column and row headings
Ans i) Name Box
i) Shortcut key is use to save a workbook is
Ans i) Ctrl + S
Q2) Fill in the blanks :-
a) Microsoft Excel is a powerful spreadsheet program.
b) The data is organized in rows and columns in Excel.
c) An alternative method of selecting a cell in a worksheet is using the arrow keys on
keyboard .
d) To revert the changes, you can cancel them using the Undo feature.
e) When a column is inserted, it gets inserted to the left side of the highlighted column.
f) Selected group of cell is called Range
Q3) Answer the following :-
a) Solution:
Microsoft Excel is a electronic spreadsheet and a part of Microsoft Office Suite. This program was designed for performing different mathematical operations on a spreadsheet (the data is entered in tabular form (rows and columns) on a sheet. Microsoft Excel is also known as spreadsheet. Excel also has different built-in tools lie functions, formulas etc which helps to perform mathematical operation/calculations. You can even prepare various sheets on Excel like Salary sheet, Marksheet etc.
b) Solution:
The differentiate between moving and copying is as follows :-
i) Moving :- We can rearrange the data in the worksheet with the help of moving the data. In Excel worksheet, when you move the data, the data gets disappears from its original location and is placed anywhere in the worksheet. For this you may
make use of the Cut and Paste commands or press shortcut keys such as Ctrl + X
(Cut) and Ctrl + V (Paste).
ii) Copying :- Copying means without retying the data again in the worksheet, the
data can be repeated again in the worksheet. When you make us of copying data,
the original data remains at the same/original place and creates automatically
creates a duplicate copy of it in the worksheet. For this you may use of Copy (Ctrl +C) and Paste (Ctrl + V) commands together.
c) Solution:
i) Changes in Column Width :- The need for changing a column width is for
adjusting the data properly. This is helpful when the data in the cells of the columns to be displayed is too broad/long. 8.43 (measured in characters) is the by default width of the cell of a column
ii) Changes in the row height :- In Excel, you can also change the height of the rows along with the width of the columns in a worksheet. The by default of the cell row height is 15.00 (measured in points).
d) Define the following :-
i) Ribbon : Ribbons are the small icons (commands) that are always displayed under every tabs. Each tabs provides small short cut buttons which are used to perform some common/specific task.
ii) Worksheet :- It is the single page in excel where you can work on it. 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. There are 3 worksheets named as Sheet1, Sheet2, Sheet3 by default in Excel. You can rename and change the colour of the worksheet name.
iii) Active cell :- In Excel, active cell means the cell in a worksheet into which we are currently working/doing work on i.e means entering of data. 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.
iv) Scroll bars :- In a Excel, with the help of scrollbars, you can view the specific portion of the worksheet on the screen. Below at the righthand side of the worksheet window, there is a scroll bars, scroll arrows, or scroll boxes that helps the user to move the window around the different parts in the worksheet that is active.
v) Gridlines :- This are the horizontal and vertical lines which are used to indicate rows and columns in worksheet is to be termed as Gridlines. Gridlines displays the information about the single cell in the worksheet.
vi) Cell reference :- At the time of making use of formula the cell is bee referred, where the cell will be referred during calculation time. The cell will be referred (cell address) when the formula is been added. There are three types of cell referencing which are i) absolute cell referencing ii) Relative cell referencing and iii) Mixed cell referencing
Q4) Give answers in short.
a) Solution:
Excel provides you a worksheet 16384 columns and 1048576 rows. Columns are labelled starting from alphabet A to XFD and rows are labelled into numbers starting from 1 to 1048576.
b) Solution:
There are by default 3 worksheets in an Excel workbook.
c) Solution:
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.
d) Solution:
In the worksheet, you can enter and edit the formula in the formula bar. Formula
bar is at the top of the worksheet and right side of the name box which displays the formula that we had entered in a worksheet’s active cell.
e) Solution:
The file extension of an Excel workbook is .xlsx
f) Solution:
Undo means repeating of the last action. In simple words If in case you had typed a word in your cell or document and by mistakenly you have deleted it and you want it back again without wasting time in retyping, then you can click on Undo option available on the left side of title bar named as Undo typing or you can make a key combination of Ctrl+Z.