Basics of MS Excel
Microsoft Excel is a versatile spreadsheet software developed by Microsoft, used
globally for organizing data and performing financial analysis. Its key features
include data entry, management, financial modeling, and charting. Excel is
extensively used in finance and accounting for budgeting, forecasting, and analysis
due to its robustness and flexibility. It supports various functions, formulas, and
shortcuts to enhance productivity and efficiency. Excel is a vital tool for
professionals in finance, accounting, and other fields requiring data organization and
analysis.
Microsoft Excel Definition
Excel definition: a software program created by Microsoft that uses spreadsheets to
organize numbers and data with formulas and functions. Excel analysis is ubiquitous
around the world and used by businesses of all sizes to perform financial analysis.
What is Excel used for?
Excel is typically used to organize data and perform financial analysis. It is used
across all business functions and at companies from small to large.
The main uses of Excel include:
Data entry
Data management
Accounting
Financial analysis
Charting and graphing
Programming
Time management
Task management
Financial modeling
Customer relationship management (CRM)
Almost anything that needs to be organized!
Data functions, formulas, and shortcuts
The Excel software program includes many functions, formulas, and shortcuts that
can be used to enhance its functionality.
We have defined the key functions and formulas below in our Excel guide:
Financial and accounting uses
Excel is used extensively in finance and accounting functions. In fact, many
organizations run their entire budgeting, forecasting, and accounting functions
entirely out of Excel spreadsheets.
While Excel is defined as a “data” management tool, the data that is most commonly
managed is financial. At CFI, we would define Excel as the ultimate financial
software. While there are other pieces of financial software that are tailored toward
performing specific tasks, the strongest point about Excel is its robustness and
openness. Excel models are as powerful as the analyst wishes them to be.
Accountants, investment bankers, analysts, and people in all types of financial career
paths rely on excel to perform their daily job functions..
Ms Excel: Ms Excel is a spreadsheet Program, an electronic document in which data is
arranged in the cloumn and rows of a grid and can be manipulated and used in calculations.
MS Excel user interface in laptop/computer:
MS Excel user interface in Mobile:
What is Cell in Excel ?: A basic unit of spreadsheet that is of rectangular area formed by the
intersection of a column and a row is called Cell.
Cell Address: A cell reference or cell address is a combination of a column letter and a row
number that identifies a cell on a worksheet (A workbook contains 3 worksheets by default).
For example, A1 refers to the cell at the intersection of column A and row 1.
Range:A group of cells is known as a cell range. Rather than a single cell address, you will
refer to a cell range using the cell addresses of the first and last .
Extension of MS Excel is xlsx.
MS Excel MCQs
1- Extension of Ms Excel is: xlsx
xlsx ✓
docx 2- Excel function allow to add
numbers in multiple cells (JOA test,
pptx
IBA Sukkur)
none
Average
Correct answer
Max
Sum 6- Each formula / function in MS Excel
Min
begins with ____ sign:
Correct answer =
Sum :
,
3- In MS Excel, inside a Workbook are
sheets, called: (18 nov 2018, IBA JEST)
Tab Correct answer
Worksheets =
Spreadsheets
Datasheets 7- ____ sign used in MS Excel to show
Correct answer the range in Cells
Spreadsheets ,
4- How many default worksheets are :✓
in MS Excel workbook ? (25 Nov 2018, None
IBA JEST)
Correct answer
2
5
8- In MS Excel we can find average
4 through following formula(e)
3 ✓ =average(a1:a4)
=sum(a1:a4)/4
5- If B3 is a cell address in MS Excel =sum(a1+a2:a3:a4)/4
then, then B is: (11 Nov 2018, IBA
All
JEST)
Correct answer
Column ✓
All
Row
Horizontal
9- Ms Excel is also called ____
Vertical
word processor
Correct answer
presentation software
Column
both above
spreadsheet ✓
Correct answer 11- Yasir wants to open a shop, to
spreadsheet maintain the record of loss and
benefits, what application he should
use in MS Office ?
10- MS Excel is used: MS Excel
for calculations Ms word
Businesses Ms powerpoint
Accounting Ms Access
All ✓ Correct answer
Correct answer MS Excel
All
