Scribd
Upload
65 views5 pages

Itfm 2

This document provides information about Microsoft Excel, including its uses and some basic functions. Excel is a spreadsheet program that allows users to organize and calculate data. It enables formatting, organizing, and calculating data in a spreadsheet. Some key uses of Excel include data entry and storage, collection and verification of business data, administrative and managerial duties, accounting and budgeting, data analysis, reporting and visualizations, and forecasting. The document also describes the steps to find a sum, apply conditional formatting, and filter data in Excel. It provides an example of an Excel sheet showing marks of students across various subjects, calculating totals, minimum and maximum marks, and using conditional formatting to show passing and failing students.

Uploaded by

nandini agrawal
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
65 views5 pages

Itfm 2

This document provides information about Microsoft Excel, including its uses and some basic functions. Excel is a spreadsheet program that allows users to organize and calculate data. It enables formatting, organizing, and calculating data in a spreadsheet. Some key uses of Excel include data entry and storage, collection and verification of business data, administrative and managerial duties, accounting and budgeting, data analysis, reporting and visualizations, and forecasting. The document also describes the steps to find a sum, apply conditional formatting, and filter data in Excel. It provides an example of an Excel sheet showing marks of students across various subjects, calculating totals, minimum and maximum marks, and using conditional formatting to show passing and failing students.

Uploaded by

nandini agrawal
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
You are on page 1/ 5

Question-1 Write short note on MS Excel, describing its uses.

Ans-: Excel is a spreadsheet program from Microsoft and


a component of its Office product group for business
applications. Microsoft Excel enables users to format,
organize and calculate data in a spreadsheet.

By organizing data using software like Excel, data


analysts and other users can make information easier to
view as data is added or changed. Excel contains a
large number of boxes called cells that are ordered in
rows and columns. Data is placed in these cells.  

Excel is a part of the Microsoft Office and Office 365


suites and is compatible with other applications in the
Office suite. The spreadsheet software is available for
Windows, macOS, Android and iOS platforms.

USES OF MS EXCEL

 
1. DATA ENTRY AND STORAGE
At its most basic level, Excel is an excellent tool for both data
entry and storage. In fact, an Excel file’s size is only limited
by your device’s computing power and memory
.
 
2. COLLECTION AND VERIFICATION OF
BUSINESS DATA
Businesses often employ multiple systems (i.e CRM,
inventory) each with its own database and logs. All of which
can be exported into Excel for easy access.
3. ADMINISTRATIVE AND MANAGERIAL
DUTIES
One aspect of managerial duties is creating and outlining
business processes. This aids in process optimization and is an
effective tool for organizing procedures and scenarios. The
use of excel offers tools that allow users to create flow charts,
which can include text, pictures, and animations.
 
4. ACCOUNTING AND BUDGETING
Excel even includes accounting and budgeting templates for
easy use. From there the software’s built-in calculating and
formula features are available to help you organize and
synthesize results.
 
5. DATA ANALYSIS
One of the best features to do this is called Pivot Tables. They
allow users to consolidate and focus on certain segments of
data from a large data set, creating concise snapshots that can
be used as an interactive summary report.
 
6. REPORTING + VISUALIZATIONS
Data from both raw data sets and Pivot tables can even be
used to create charts and graphs. Which can be used for
formal reports, presentations, or aid in one’s data analysis. As
they can provide another perspective on trends and
performance.

7. FORECASTING
While reporting and reviewing results is an important aspect
of any business, forecasting and being prepared for various
scenarios and changes is just as vital.
Question-2 Describe the steps followed for-:
FINDING SUM
CONDITIONAL FORMATTING
FILTERING DATA/NUMBERS

ANS-: Finding sum :


 Select a cell next to the numbers you want to sum,
 click AutoSum on the Home tab,
 press Enter, and you're done.
 When you click AutoSum, Excel automatically enters a
formula (that uses the SUM function) to sum the
numbers.

b. Conditional Formating:
 Select the range of cells, the table, or
 the whole sheet that you want to apply conditional
formatting to.
 On the Home tab, click Conditional Formatting.
 Click New Rule.
 Select a style, for example, 3-Color Scale,
 select the conditions that you want, and then
 click OK

(c) Filtering data/numbers: The steps are as follow

 Filter a range of data


 Select any cell within the range.
 Select Data > Filter.
 Select the column header arrow .
 Select Text Filters or Number Filters, and then select a
comparison, like Between.
 Enter the filter criteria and select OK.

Q3. Prepare an excel sheet showing marks of 9 subjects of 10


students. Calculate total, maximum and minimum marks and
grades obtained. Use conditional formatting/filtering to show
the pass/fail students.

FI MA ECO
PRO ST
S.N NA HR RKE P.M ORG. NO ITF TOT GRA STA
NAME .CO ATI MAX MIN
O NC M TIN GT BEH MIC M AL DE TUS
M CS
E G S

1 AKARTI 98 89 33 98 89 87 66 89 33 100 33 682 A PASS


2 JYOTSNA 87 68 12 87 68 98 67 68 12 100 33 567 B PASS
3 BADAL 2 54 40 21 54 65 11 54 11 100 33 312 E FAIL
4 RAHUL 98 34 60 98 34 45 45 34 60 100 33 508 B PASS
5 ROHIT 32 54 76 32 54 34 32 54 76 100 33 444 C PASS
6 ROHAN 22 23 56 22 23 56 13 23 56 100 33 294 E FAIL
7 AMAN 89 11 98 89 11 32 43 11 98 100 33 482 C PASS
8 RIYA 44 45 23 44 45 34 67 45 23 100 33 370 D PASS
9 AKASH 23 23 67 23 23 43 54 23 67 100 33 346 D PASS
10 NITIN 87 21 87 87 21 54 32 21 87 100 33 497 C PASS

SUBMITTED BY-: HITESH SINGH NAINWAL


ASSINGNMENT-2

SUBJECT - ITFM

You might also like