ACKNOWLEDGEMENT

I would like to express my special thanks of gratitude to my

teacher Mr. Manish Sir who gave me the golden opportunity to do
this wonderful project on the topic ‘Spreadsheet’. This project
helped me a lot in gaining adequate knowledge about the topic.
I am really thankful to all of my friends, co-partners and guide,
who have devoted their precious time in completing my project.
Secondly, I would also like to thank my parents who helped me a
lot in finishing this project.
I am making this project not only for marks but also to increase my
knowledge and intellect development.
Thanks again to all who helped me.
Name – Anwesha
Class – 10A
Roll No. – 08
 CERTIFICATE
NAME – ANWESHA
CLASS – 10 A
ROLL NO. – 08
This is certified to be the bonafide work of the student in
the computer laboratory during the academic year 2019-20.

Teacher incharge –
Principle signature –
 CONTENTS
S. No. Particulars Slide No.
1. MICROSOFT EXCEL 1
2. SPREADSHEET 2
3. AUTOSUM 3
4. FEATURES OF AUTOSUM 4
5. SUM 5
6. MAX 6
7. MIN 7
8. AVERAGE 8
9. COUNT NUMBERS 9
10. SORT 10
11. FILTER 11
 MICROSOFT EXCEL

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and IOS. It
features calculation, graphing tools, pivot tables and a macro programming language called Visual
Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially
since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
Excellent forms part of the Microsoft Office suite of Software.
FEATURES OF MS EXCEL
• Pivot Tables
• Conditional Formatting
• Paste Special
• Adds Multiple Rows
• Absolute References
• Filters
 SPREADSHEET
A Spreadsheet is a computer application for
organization, analysis and storage of data in tabular
form. Spreadsheets were developed as computerized
analogs of paper accounting worksheets. The program
operates on data entered in cells of a table. Each cell
may contain either numeric or text data, or the results of
formulas that automatically calculate and display a value
based on the contents of other cells. A spreadsheet may
also refer to one such electronic document.
02
 AUTOSUM
Autosum is a Microsoft Excel other spreadsheet program
function that adds together a range of cells and displays
the total in the cell below the selected range. It is used
for adding the values given in cells automatically without
writing the formula to perform the operation. Autosum
option is available in Editing group under the Home tab.
Autosum automatically selects the values around the
cells either horizontally or vertically. It helps to carry out
the task at a great speed. When you want to total a
particular row or column you use this function. Autosum
helps to total up various rows and columns in the
spreadsheet.
FEATURES OF AUTOSUM
 SUM

Microsoft Excel defines SUM as a formula that “Adds all the numbers in a
range of cells”. This definition clearly points that Sum function has a job
to add numbers and the arguments can be supplied using combinations of
both no.s and range of cells.
Steps to apply SUM feature do the following:
• Open a spreadsheet and enter the data.
• Go to cell C15. While the cell C15 is selected,
click on the Autosum option available under
Editing Group in the Home tab.
• The values in the cells from C5 to C10 will be
automatically selected as shown in (Fig.).
• Press the Enter key to complete entry.
05
05
 MAX
The MAX function determines the largest value from the
range specified. The MAX function ignores empty cells,
the logical values TRUE and FALSE, and text values.
Steps to apply MAX feature do the following:
• Open a new spreadsheet and enter the data.
• Go to cell B9. Enter =MAX(B2:B8) in cell B9.
• The values in the cells from B2 to B8 will be
automatically selected as shown in (Fig.).
• Press the Enter Key to complete entry.

06
 MIN
The MIN Excel function returns the smallest numeric value
in a range of values. The MIN function ignores empty cells,
the logical values TRUE and FALSE, and text values.
Steps to apply MIN feature do the following:
• Open a new spreadsheet and enter the data.
• Go to cell F5. Enter =MIN(C5:C11) in cell F5.
• The values in the cells from C5 to C11 will be
automatically selected as shown in (Fig.).
• Press the Enter key to complete entry.

07
 AVERAGE
The Excel AVERAGE function returns the average of
values provided. AVERAGE can handle up to 255
individual arguments, which can include number, cell
references, ranges, arrays, and constants.
Steps to apply AVERAGE feature do the following:
• Open a new spreadsheet and enter the data.
• Go to cell G5.
• Enter =AVERAGE(LARGE(B5:F5,{1, 2,3}))
• in cell G5.
• The values in the cells from B5 to F5 will be
automatically selected as shown in (Fig.).
• Press the Enter key to complete entry.
 COUNT NUMBERS
The COUNT function counts the number of cells that contain
numbers, and count numbers within the list of arguments. Use
the COUNT function to get the number of entries in a no. field
that is in a range or array of numbers.
Steps to apply COUNT feature do the following:
• Open a new spreadsheet and enter the data.
• Go to cell A7. Enter =COUNT(A1:A5)in the cell A7.
• The values in the cells from A1 to A5 will be
automatically selected as shown in (Fig.).
• Press Enter the Key to complete entry.
09
 SORT
The Excel SORT function sorts the contents of a range
or array. Values can be sorted by one or more
columns. SORT returns a dynamic array of results.
Steps to apply for SORT feature do the following:
• Select the cell range G2:H6.
• Select the Data tab on the Ribbon, then
click the Sort command.
• The Sort dialog box will appear.
• Choose the column Orders.
• Decide the sorting order.
 FILTER

Filters can be applied in different ways to improve the performance of your worksheet. You can filter text, dates, and numbers. You can even use more than one filter to further narrow your results.
Steps to apply FILTER feature do the following:
• Begin with a worksheet that identifies each
column using a header row.
• Select the Data tab, then locate the Sort &
Filter group.
• Click the Filter command.
• Drop-down arrows will appear in the header
of each column.
• Click the drop-down arrow for the Type column.
• The Filter menu appears.
• Click Ok.
11
 U😄
YO
NK
H A
T