Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Unit 2: Application Software — MS-Excel

Lesson 16 of 34 in the free Fundamentals of IT & Computers notes on Siksha Sarovar, written by Rohit Jangra.

Unit II — Application Software: MS-Excel

Microsoft Excel is a spreadsheet application used for organising, calculating, analysing, and visualising data. It is part of the Microsoft Office Suite and is essential for finance, accounting, data analysis, and scientific work.

---

Basic Concepts

TermDescription
WorkbookAn Excel file (.xlsx); contains one or more worksheets
Worksheet (Sheet)A single tab/page; a grid of rows and columns
CellIntersection of a row and column (e.g., A1, B3)
RowHorizontal line; numbered 1, 2, 3…
ColumnVertical line; labelled A, B, C…
RangeA group of cells (e.g., A1:C5)
FormulaAn expression starting with = that performs calculation
FunctionBuilt-in formula (e.g., SUM, AVERAGE, IF)

---

Entering Data Types

  • Numbers — Used in calculations; right-aligned by default.
  • Text (Labels) — Descriptive headings; left-aligned.
  • Dates/Times — Stored as serial numbers; formatted for display.
  • Formulas — Begin with =; e.g., =A1+B1, =SUM(A1:A10).

---

Common Functions

FunctionSyntaxDescription
SUM=SUM(A1:A10)Adds all values in range
AVERAGE=AVERAGE(A1:A10)Calculates mean
MAX / MIN=MAX(A1:A10)Largest / smallest value
COUNT=COUNT(A1:A10)Counts numeric cells
IF=IF(A1>50,"Pass","Fail")Conditional logic
VLOOKUP=VLOOKUP(val, range, col)Vertical lookup
CONCATENATE=CONCATENATE(A1,B1)Joins text strings

---

Charts and Graphs

Excel can create visual representations of data:

  • Bar/Column Chart — Compare values across categories.
  • Pie Chart — Show proportions of a whole.
  • Line Chart — Show trends over time.
  • Scatter Plot — Show correlation between two variables.

---

Cell Referencing

TypeExampleBehaviour
RelativeA1Adjusts when formula is copied
Absolute$A$1Stays fixed when copied
Mixed$A1 or A$1Row or column fixed

---

Common Shortcuts

ShortcutAction
Ctrl + ;Insert current date
Ctrl + Shift + :Insert current time
F2Edit cell
Ctrl + DFill Down
Alt + EnterNew line within cell
Key Takeaway: MS-Excel is built around cells, formulas, and functions. The key distinction is between relative ($-free) and absolute ($-prefixed) cell references when copying formulas. Common functions (SUM, IF, VLOOKUP) and chart types are frequent exam topics.