ACCA Management Information Spread Sheet

Spreadsheet – Short Notes
1️⃣ Spreadsheet Basics

Spreadsheet ek software hai jisme data rows aur columns mein store hota hai aur formulas se
calculations hoti hain.

Important terms

Row → Horizontal line (1,2,3…)

Column → Vertical line (A,B,C…)

Cell → Row + Column ka box (A1, B2)

Worksheet → Cells ka page

Workbook → Multiple worksheets ka file

2️⃣ Basic Formulas

1. Addition

Copy code



=A1+B1

2. Subtraction

Copy code



=A1-B1

3. Multiplication

Copy code



=A1*B1

4. Division

Copy code



=A1/B1

Important Functions

,SUM

Copy code



=SUM(A1:A10)

AVERAGE

Copy code



=AVERAGE(A1:A10)

MAX

Copy code



=MAX(A1:A10)

MIN

Copy code



=MIN(A1:A10)

COUNT

Copy code



=COUNT(A1:A10)

3️⃣ Common Spreadsheet Errors

Error

Meaning

#DIV/0!

Number ko zero se divide kiya

#NAME?

Formula ka name galat

#VALUE!

Wrong data type

, #REF!

Invalid cell reference

#####

Column width choti hai

4️⃣ Spreadsheet Charts

Charts data ko graphical form mein dikhate hain.

Common Charts

1 Bar Chart

Data comparison

2 Line Chart

Trend show karta hai

3 Pie Chart

Percentage show karta hai

4 Column Chart

Category comparison

5️⃣ Spreadsheet Shortcuts (Important)

Shortcut

Function

F2

Cell edit

Ctrl + C

Copy

Ctrl + V

Paste

Ctrl + X

Cut

Ctrl + Z

Undo

Ctrl + S