Scribd
Upload
5 views15 pages

Practical Rudra

The document outlines practical exercises for learning basic Excel functions, including data entry, formatting, and basic operations like deleting columns and sorting. It also covers formulas for common mathematical functions, text manipulation, and date/time functions, as well as financial analysis calculations. The exercises aim to familiarize users with Excel's capabilities for data management and analysis.

Uploaded by

rajawatmahendrasingh279
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views15 pages

Practical Rudra

The document outlines practical exercises for learning basic Excel functions, including data entry, formatting, and basic operations like deleting columns and sorting. It also covers formulas for common mathematical functions, text manipulation, and date/time functions, as well as financial analysis calculations. The exercises aim to familiarize users with Excel's capabilities for data management and analysis.

Uploaded by

rajawatmahendrasingh279
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Practical No.

1
(1)
Aim: Introduction to Excel basic
A) Entering and editing worksheet data
1. Enter the data

2. Go to the font tab  Select “bottom border” tab


Select to the font “All border” option

3. Deleting cell from data


Select the cell that you want to delete Right click  select
‘delete’

4. Style Cell
Select cell style  Choose any style
5. Format as table
Select table  Choose format as table

(2)
Aim: Performing basic operation
A) Deleting column from table

B) Insert Row
Select 1 cell from table  Go to the insert and select “insert row”
option

C) Sorting cell in table


Select any row, column or whole tab  Go to the editing tab 
select “Sort & filter” tab  select sort from Z to A
(3)
A) Entering and editing worksheet data
1. Enter the data

2. Go to the font tab  Select “bottom border” tab

Select to the font “All border” option

3. Deleting sell from data

Select the cell that you want to delete  Right click  select ‘delete’
4. Style Cell

Select cell style  Choose any style

5. Increase the Row height and column Width


Select the “row” and “Column”  Format  change the “row
height” and “Column width”

6. adjusting the data of formula


Select a cellRight clickformat cell

7. Justify the cell


Select a cell Alignment  select a “center text”

8. Justification of entire Column or Row

Select a Column or Row  Alignment  select a “center text”

9. Copy cell column or rows


Right click on cell copy the “row” or “column”  copy
10. Paste

Arithmetic Procedure .Microsoft Excel follows the rules of Arithmetic


Procedure when evaluating formulas
Practical 2
Working the formulas and functions

Aim: Using formulas for the common mathematical functions

A. Using the formulas


Formula = =B2*C2
B. Sum= Total of cost
Formula= =SUM(E2:E5)

C. Average= Average of Price


Formula= =AVERAGE(C2:C5)

D. Sum if /Sum ifs - Conditionals Sums


 Single condition: Total for items > 10
Formula= =SUMIF(C2:C5,">10",E2:E5)
:
 Multiple Condition

=sumifs(E2:E5,C2:)

E. Count, Count
 With count numeric
 Count items with quantity >10:
F. Round roundup and rounddown
 Within round total to 2
: =round(sum)
=roundup(sum)onlyC2,()enter
=SUMIFS(E2:E5,B2:B5,”>=5”C2:C5”<20”)

COUNT

=COUNT=B2:B5

COUNTIF (B2:B5,”<10”)

B.
Aim:- Using text function to manipulate text

[Link] function : =proper(A2)

2. Upper function

3. Lower function
4. Len function

5. Concatenate Function

6. Left function
7. Right function

8. Mid function

9. Find Function
C
Using Date and Time Function

1. Current Date

2. Current Date & Time

3. Extract date form Date of Joining

4. Using formulas for financial analysis


 Profit : =A2-B2
 Profit% : =(A5/A2)*100
 Simple Interest : =C2*D2*E2
 Total amount : =C2+C5
 Compound : =C2*(1+D2)^E2
 EMI : =PMT(D2/12,E2*12,C2)

5. Break even Analysis

You might also like