Microsoft Excel is a special office package that is use to make a calculated sheet.
Extension= *.XLS.
Spreadsheet - it is special sheet in which we type our data into rows and columns.
Layout of MS Excel
Cell - is an inner part of row and column in which we type our data.
Formula Bar- it is a special bar that used to change a formula. It is also used to change a text. It is also called editing bar. Furthermore, it is two parts.
Name bar-shows the cell address.
Formula bar- it shows the cell value (data or formula).
Worksheet- it is a part of workbook. In which we type our data in row and column.
Number of row= 1-65536
Column- 1-256
Cut and copy a cell-when we cut or copy a cell in MS Excel, then a small dash line automatically moves around the cell.
Ctrl+x Cut
Ctrl+c copy
Ctrl+v paste
Change the width of row and column-we can change a width by drag a row and column from row and column heading.
Automatically insert a series-enter a number in a cell and select this cell and press Ctrl button and drag an item to desired number location.
Auto sum Σ- this is used to automatically find a sum of a selected cell.
Formula in Excel-we have to write = sign before writing formula.
Set border in your table-select the data than select your border style than okay.
Format-cell- border-okay.
Remove a border-select your table in without set a border. Click on border button in formatting toolbar and click on none option.
Insert a row and column- a row is always before, currently new. A new column is always inserted left side of the current row.
Delete a row and column-select the row or column, then click on options delete entire or desired.
Comment- to set a comment in desired cell.
Insert a sheet - click on insert worksheet or shift+f11
Page break-to insert the page break for printing.
Make a chart in Excel-the chart is the graphic that is based on a data. Select data then select desired chart then okay.
Conditional formatting - when you want to set a different style of formatting according to a particular condition.
Alignment- to change a direction of text.
Set a pattern-you want to set on background color of your cell than you can set pattern.
Autofit- automatically delete a blank space.
Hide- a selected row, hide and un-hide.
Formula in Excel-
Now- it is used to display a current system date and time.
Today- it is used to show current date.
Mini- it is used to show minimum value of range.
Max- it is used to show maximum value of range.
Power- to used for power formula. =power(5, 2) Answer is 25
Product- to multiply all the given number. =product (5,10) Answer is 50
SQRT- Square root formula.
=SQRT(16) Answer is 4
Sum-add all the number given.
Date-represent date.
Average- to find average from the select data.
If- to work a particular condition. If condition, true, false or pass and fail.
Goal seek-when you want to automatically change a value of formula cell.
Auditing-this option use to check a linking of formula cell with another cell.
Trace precedent- to show linking of formula cell to cell value.
Trace dependent- to show a linking normal to formula cell, if any.
Filtering a date- to search a particular record that match with a special condition.
Validation-when you want to set some limit of your input data, then you can use validation.
1
Comments