Scribd
Upload
6 views3 pages

Excel Notes

The document provides instructions on various Excel functions and features, including creating series, extracting data with flash fill, applying comments, and using conditional formatting. It also explains rounding functions, integer functions, and statistical functions like sum, average, max, min, large, and small, along with their syntax. Each function is described with its purpose and how to implement it in Excel.

Uploaded by

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

Excel Notes

The document provides instructions on various Excel functions and features, including creating series, extracting data with flash fill, applying comments, and using conditional formatting. It also explains rounding functions, integer functions, and statistical functions like sum, average, max, min, large, and small, along with their syntax. Each function is described with its purpose and how to implement it in Excel.

Uploaded by

kushwahaprince4624
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Chapter 5.

How to create series from 1 To N number>first of all type 1 and select it>go to fill>series>click
on column> enter the stop value>ok.

How to create weekday series>type starting date>select it>go to fill>series>click on


column>click on date>weekday>type the stop date>ok.

How to extract data by flash fill>Type the first name>go to fill>flash fill (or press ctrl+E)

(same as last name)

How to apply /Per Unit in suffix>select the column>click on number tab>click on custom>type
#"/Per Unit"

How to define name range>select the range>farmulas>define name>type the name>ok.

How to apply comment>click on the cell on which you want to apply comment>review>new
comment>or press shift+f2

How to highlight the date of sunday>select the date columns>click on conditional


formatting>click on new rule>

=weekday(select the first cell of the date and press f4 three time)>click on format>fill>select any
color>ok>ok.

Chapter 5.5

1-Round>round function is use to round the value as per required number of digits after
decimal places. it will increase 1 in left side if the number is 5 or more else not increase.

syntax: =round(select the columsn range,2)

2-Roundup>round function is use to round the value as per required number of digits after
decimal places. it will increase 1 in left side either number is less than 5.

syntax: =roundup(select the columsn range,2)


3-Rounddown>round function is use to round the value as per required number of digits after
decimal places. it will never increase the value.

syntax: =rounddown(select the columns range,2)

Integer>Integer function is use to fetch the value before decimal

places. after decimal places integer ignore the value.

Syntax: =int(select the cell) inter.

Mround>mround function is use to multiple of value from any number.

Syntax: =mround(select the cell,5)

Rank>rank function is use to find the position (ranking) of given database.

Syntax: =rank(select first cell of the columns except heading,select the entire columns
then press f4 one time,0)

sum>sum function is use to find the sum of column or array.

syntax: =sum(select the range)

Average>average function is use to find the average of any column or array.

syntax: =average(select the range)

max>max function is use to find the maximum value from any columns or range.

syntax: =max(select the range)

min>min function is use to find the minimum value from any columns or range.

syntax: =min(select the range)


Large>large function is use to find the highest value according to condition from any columns or
range.

syntax: =large(select the column range,conditions)

Small>small function is use to find the smalles value according to

conditions from any column or range.

syntax: =small(select the range,condition)

You might also like