-->
Home LAB ASSIGNMENT FREE SKILL DEVELOPMENT TRAINING'S

### Microsoft-Excel 2007 Study Material Day-Nine

Editing Group :

Auto-sum (Alt + +) :
Sum : Display the sum of the selected cells directly after the selected cells.
Syntax :
Sum(number 1,number 2,..... )
Example :
=SUM(3,2)
Average :Display the average of the selected cells. directly after the selected cell.
Syntax :
average(number 1,number 2,..... )
Example :
=AVERAGE(2,7)
Count Number : Display the using number of cells.
Syntax :
count(Value 1,Value 2,..... )
Example :
=COUNT(1,2,3,5,6,7,8)
Max : Display the largest number.
Syntax :
max(number1,number2)
Example :
=MAX(1,2,3,5,6,7,8)
Min : Display the Smallest number.
Syntax :
min(number1,number2)
Example :
=MIN(1,2,3,5,6,7,8)

Fill :
Continue a pattern into one or more adjacent cells.you can fill cell in any direction and into any range of adjacent cells.
Down : To fills the information from top to down.
Right : To fills the information from left to right side.
Up: To fills the information from down to up.
Left : To fills the information from right to left side.
Justify :  Justifying the selected cells into a single cell.
Series : To fill the series values in to the respective row or columns by specifying
Steps:

• Type the '1' and select the cell
• Click on Fill and select the Series
• Choose the Step-Value=1 to Stop Value=10
• Click on OK Button
Clear : Delete everything from the cell or selectively remove the formatting of the contents of the comments.
Clear All : Delete all the data from the list range.

• Select list range
• click on clear
• select clear all

Clear Formats : Clear all the formatting styles from the list range.leaving only the plain text.
Steps :

• Select list range
• Apply formatting styles,like Bold,Italic..etc
• Click on Clear
• Click on Clear formats

Clear Contents: Delete the selected list range.
Steps:

• Select list range
• click on clear
• click on clear contents

Clear Comments : Delete the selected comment
Steps :

• Select Cell
• Click on "Review Tab"
• Select New Comment
• Type any Comment
• Click on "Home Tab"
• Click on Clear

Sort & Filter :
Sort : It is used to arrange the records in as Ascending order or Descending or Alphabetical order.
Steps:
• Select list range
• select smallest to largest(A-Z)  (or)
• Select largest to smallest (Z-A)
Filter : It is used to filter the record from list range and display the output in same place.
Steps :
• Select list range
• select filter
• select course column
• select any record (or) To display all records "Select All" Option
Find ( Ctrl + F) : This option is used to find specified information.
Replace (Ctrl + H) : This option is used to replace the specified information in the place of specified information.
Goto (Ctrl + G) : Navigate to a specific place in the worksheet.
Formulas : Goto formulas