BnbMS-EXCEL
ICT Class-7 Chapter-
4
Ms-Excel -
• Ms – excel is a spreadsheet program that is used to
record & analyze numerical data.
• Ms – excel comes in handy when we want to record,
analyze & store such numeric data.
• The point where a column & a row meet is called a cell.
• The address of a cell is given by the letter representing
the column & the number representing a row.
Opening of workbook in Ms-Excel –
• There are different methods of opening work book in
Ms-excel –
1. Click on the file tab.
2. Click new option.
3. Click on the blank document.
★ To quickly create a new blank work book (keyboard
shortcut)-
CTRL+N.
Opening of New Workbook
Opening of a new workbook on an
existing workbook –
1. Click on the file tab.
2. Click on new option.
3. Under templates, click new from existing.
4. In the new from existing workbook dialog box, browse
to the drive, folder, or internet location that contains
the workbook that you want to open.
5. Click on the workbook, & then click on create new
Ms-Excel –
👍Advantages – 👎Disadvantages –
• Excel has the ability to • The amount of time it
organize large amount. takes to enter the data
• It is easy to enter and can be inefficient.
format the data. • It can lead to boredom
• It has the ability to create which leads to potentially
the graphical costly inattentiveness.
representation of your • Entering the data into
data. excel manually can take a
very long time.
The cell, row and column –
• A cell is the insertion between a row & a column on a
spreadsheet that starts with cell A1.
• The cell address, cell name, or cell pointer “D8” (column D, row
8)
is the selected cell & the location of what is being modified.
• Ms-excel is in tabular format consisting of rows & columns.
• Row runs horizontally while column runs vertically.
• Each row is identified by row number, which runs vertically at
the left side of the sheet.
• Each column is identified by column header, which runs
horizontally at the top of the sheet.
The cell address –
A cell is the insertion between a row & a column on a
spreadsheet that starts with cell A1.
• The cell address, cell name, or cell pointer “D8”
(column D, row 8) is the selected cell & the location of
what is being modified.
Worksheet –
• An excel worksheet is a single spreadsheet that
contains cells organized by rows & columns.
• A worksheet begins with row number one & column A.
• Each cell can contain a number, text or formula .
A cell can also reference another cell in the same
worksheet, the same workbook or a different workbook.
Insertion of new worksheet –
• Three new blank sheets always open when you start
Ms-excel.
• Steps to insertion of new worksheet –
1. Right click the sheet name & select insert option.
2. Now you’ll see the insert dialog with select worksheet
option as
selected from the general tab. Click the OK button.
4. Now your blank sheet is ready you can type text.
Steps image –
Steps to renaming of sheet –
1. Double click the sheet tab or right-click the sheet tab
& then click rename on its shortcut menu. The current
name on the sheet tab appears selected.
2. Replace the current name on the sheet tab by typing
the new sheet name.
3. Press enter.
Steps to deleting a sheet –
1. Right click the sheet name and select the delete
option.
2. Press the delete button.
• Now your worksheet will get deleted.
Steps image –
• Sheet will get deleted if it is empty, otherwise you’ll see a
confirmation message.
Steps to Moving or copying of a
sheet –
• Select home > format > move or copy sheet. Or, you
can also right-click a selected sheet tab,& then click
move or copy. In the move or copy dialog box, click the
workbook to which you want to move or copy the
selected sheets.
Steps image –
Entering data to the cell –
• In Ms-excel, there are 1048576*16384 cells. Ms-excel
cell can have text, numeric value or formulas. An Ms-
excel cell can have maximum of 32000 characters.
• For inserting data in Ms-excel, just activate the cell type
text or number & press enter or navigation keys.
In s e rtin g fo rm u la –
• For inserting formula in Ms-excel go to the formula bar,
enter the formula & then press enter or navigation key.
★ The shortcut key to create a blank sheet – Shift+F11.
Formatting cells –
• When we format cells in excel, we change the
appearance of a number without changing the number
itself. We can apply a number format (0.8,$0.80,80%,
etc.) or other formatting (alignment, font, border, etc.)1.
Enter the value 0.8 into cell B2.
Adding font styles, design, and colour to the text
& cell –
• Setting Font- You can assigns any of the fonts this is
installed for your printer to cells in a worksheet.
• Setting font from home – You can set the font of the
selected text from Home >> Font group >> select the
font.
Text decoration –
• Bold - It makes the text in bold by choosing Home >>
font group >> click B or press ctrl + B.
• Italic – It makes the text italic by choosing Home >>
font group >> click I or press ctrl + I.
• Underline – It makes the text as underlined by choosing
Home >> font group >> click U or press ctrl + .
• Double underline – It makes the text highlighted as
double underlined by choose Home >> font group >>
click arrow near U >> select double underline.
Setting colours –
• Changing background colour – By default the
background colour of the cell is white in Ms-excel. You
can change it as per your need from Home tab >> font
group >> background colour.
• Changing foreground colour – By default, the foreground
or text colour is black in Ms-excel. You can change it as
per your need from Home tab >> font group >>
foreground colour.
• Also you can change the foreground colour by selecting
the cell Right click >> format cells >> font tab >>
colour.
Deletion of data from cells –
To delete the actual cell selection rather than just clear
the cell contents, follow these steps -
1. Select the cells, rows, or columns you want to delete.
2. Click the drop-down button attached to the delete
button in the cells group of the home tab.
3. Click delete cells on the drop-down menu.
Insertion of pictures -
1. Open your spreadsheet in Excel 2010.
2. Select the cell into which you want to paste the
picture.
3. Click the insert tab at the top of the window.
4. Click the picture button in the illustrations selection of
the ribbon at the top of the window.
5. Browse to the picture that you want to add your
spreadsheet, select it, then click the insert button.
6. (Optional) – Manually resize the cell so that the
picture is contained within it. You can do this by
clicking the right border of the column letter at the top
of the spreadsheet, then dragging it so that the cell is
wide enough for the image. You can then repeat this
with the row number.
Steps to Use of function –
1. Open an existing excel workbook. If you want, you can
use this example.
2. Create a function that contains more than one argument.
3. Use auto sum to insert a function.
4. Insert a function from the functions library.
5. Use the insert function command to search & explore
functions.
• SUM
• AVERAGE
• AUTOSUM
• COUNT.
Creating of chart –
• A chart is a tool you can use in excel to communicate
data graphically.
Steps to create a chart –
1. Select the source data for which you want create the
chart.
2. Click on insert tab.
3. Select the required chart type.
THANK
YOU