File Name

₹Quick
0.00 Access Toolbar

Tabs

Ribbon

Name box

Column Alphabets

Row Formula Bar

Numbers

Worksheet

Worksheet
Name

Click + to add new

Worksheet
 File Name
Excel Search

Formula Bar

Normal View

Page Layout
zoom in zoom out
Page break preview
Topic
Excel
Spreadsheet
Workbook
Extension Name
Extension Name
Extension Name

Extension Name

Extension Name
Name Box
Ribbon Bar
Total Number of rows(2007 Onward Version)
Total Number of columns (2007 Onward Version)
Total Number of rows(2007 Backward Version)
Total Number of column (2007 Backward Version)
First Cell
Last Cell
To go to the Last Row
To go to the Last Column
To go to First Column
To go to First Row
To select all the Data
To go to the First Cell
To insert new Worksheet

To move Between the sheets

Explanations
It is a Spreadsheet Application. Also Its is an Integeral Part of MS- Office
Any software that contains the data in the row and column is known as spreadsheet
Excel File is known as workbook
XLSX (2007 Version Onwards)
.XLS (2007 Version Backwards)
.XLSM(2007 Verion Onwards with Macro Enabled)
.XLSB(Excel Binary Workbook File) which work much faster, making them extremely useful for
large spreadsheets
CSV (Comma Seperated Value)Files are used as a way to communicate data between different
application.
It contains the current cell address. Intersection of row and column is known as Cell
CTRL + F1 to hide/ unhide Ribbon Bar
10,48,576
16384 (XFD)
65,536
256 (IV)
A1
XFD1048576
CTRL + DOWN Arrow key
CTRL + RIGHT Arrow Key
CTRL + LEFT Arrow Key
CTRL + UP Arrow Key
CTRL + A
CTRL + Home
Func + shift + F11

CTRL + Shift + PgUp (To go to the Next Sheet) / CTRL + Shift + PgDn (To go to the Previous Sheet)
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!

#VALUE!
#VALUE!
Employee Hours Wage Per Hour Weekly Salary
Luka Abrus 49 ₹ 10.00 ₹ 490.00 =(C4*D4)
Terry Adams 36 ₹ 13.00 ₹ 468.00 =(C5*D5)
David Ahs 43 ₹ 14.00 ₹ 602.00 =(C6*D6)
Kim Akers 35 ₹ 10.00 ₹ 350.00 =(C7*D7)
Ties Arts 38 ₹ 9.00 ₹ 342.00 =(C8*D8)
Kamil Amerih 38 ₹ 14.00 ₹ 532.00 =(C9*D9)
Amy Alberts 42 ₹ 11.00 ₹ 462.00 =(C10*D10)
Matt Berg 39 ₹ 9.00 ₹ 351.00 =(C11*D11)
Totals ₹ 3,597.00 =(E4+E5+E6+E7+E8+E9+E10+E11)

Average Salary ₹ 449.63 =(E12/8)

₹ 449.63
E6+E7+E8+E9+E10+E11)
 SUM PRODUCT

STUDENT NAME MARKS PRODUCTS QTY COST TOTAL

Deepa 85 P1 150 10 1500
Binil 96 P2 200 15 3000
suman 78 P3 250 20 5000
Shilpa 65 P4 300 25 7500
Sunil 89 P5 350 30 10500
SUM 413 27500
=SUM(B4:B8) =SUM(G4:G8)
27500

MAX COUNT COUNTA

STUDENT NAME MARKS STUDENT NAME MARKS STUDENT NAME

Deepa 85 Deepa 85 Deepa
Binil 96 Binil 96 Binil
suman 78 suman 78 suman
Shilpa 65 Shilpa 65 Shilpa
Sunil 89 Sunil 89 Sunil
MAX 96 count 5 COUNTA
=MAX(B16:B20) =COUNT(E16:E20) COUNT
COUNTIF

STUDENT NAME GENDER

Deepa F
Binil M
suman M
Shilpa F
Sunil M
No of Female 2 =COUNTIF(B27:B31,"F")
No of Male 3 =COUNTIF(B27:B31,"M")
cdevd

vf

cdgv
 AVERAGE MIN

STUDENT NAME MARKS STUDENT NAME MARKS

=PRODUCT(E4:F4) Deepa 85 Deepa 85
Binil 96 Binil 96
suman 78 suman 78
Shilpa 65 Shilpa 65
Sunil 89 Sunil 89
Average 82.6 MIN 65
=AVERAGE(J4:J8) =MIN(M4:M8)

COUNTA COUNTBLANK

MARKS STUDENT NAME MARKS

85 Deepa 85
GF Binil
78 suman 78
65 Shilpa 65
89 Sunil 89
5 COUNTBLANK 1
4 COUNT 4
=COUNTA(H16:H20) =COUNTBLANK(K16:K20)
=COUNT(H16:H20) =COUNT(K16:K20)

#N/A
#N/A
MIN(M4:M8)
 Students Marks Result
Anil Kumar Sharma 42 Fail =IF(C3>=60, "Pass","Fail")
Pyuish Saini 87 Pass =IF(C4>=60, "Pass","Fail")
Shivam Sharma 56 Fail =IF(C5>=60, "Pass","Fail")
Suraj Raina 75 Pass =IF(C6>=60, "Pass","Fail")
Abhinav Goswami 89 Pass =IF(C7>=60, "Pass","Fail")
Anubhav Peer 50 Fail =IF(C8>=60, "Pass","Fail")
Unmukat Sharma 48 Fail =IF(C9>=60, "Pass","Fail")
Dravid Manotra 57 Fail =IF(C10>=60, "Pass","Fail")
Gaurav Boughal 52 Fail =IF(C11>=60, "Pass","Fail")
Nadeem Farooq 47 Fail =IF(C12>=60, "Pass","Fail")
Sahil Sharma 71 Pass =IF(C13>=60, "Pass","Fail")
Nikhil Arora 75 Pass =IF(C14>=60, "Pass","Fail")
5 =COUNTIF(D3:D14,"pass")
7 =COUNTIF(D3:D14,"fail")

Employee Target Salary Actual Target (Sales)

Rajat Thapar 15000 ₹ 120,000 20000
Mohd Ishfaq Khan 25000 ₹ 140,000 30000
Vishav Jeet Singh 35000 ₹ 160,000 40000
Waseem Sajad Bhat 60000 ₹ 180,000 50000
Shubam Pandita 75000 ₹ 210,000 60000
 Simple If Condition -------> It check
"PASS" -----> If and only if the student has General Syntax is -------> =IF(logical_tes
achieved the score more than or equal to 60. means we put the condition and if the c
"FAIL" -------> If and only if the student has state what is to be printed if the conditio
achieved the score less than 60 > we state what

=IF(E19>C19,"yes","not") =IF(E19>=C19,D19*12%,"-")
Whether they have achieved the target or Not 12% Bonus / Commission
yes 14400 14400 Calculate commission
yes 16800 16800 employee has achieve
yes 19200 19200 is 12% of S
not - -
not - -
=IF(F19="yes",D19*12%,"-")
ndition -------> It checks whether the conditon stated inside the IF is True or False.
is -------> =IF(logical_test, value_if_true, value_if_false) , where "logical_test" ------> It
he condition and if the condition evaluates to be true , then in " value_if_true" ---> we
printed if the condition is TRUE and if the consition is false then in "value_if_false" -----
> we state what is to be printed if the condition is FALSE.

Calculate commission amount if and only if the

employee has achieved the target. Commission
is 12% of Salary amount.