MS Excel — ADCA Notes

15 views 1 min read

Microsoft Excel

MS Excel is a spreadsheet application used for data storage, calculation, analysis, and chart creation.

Basic Concepts

Workbook: An Excel file (.xlsx)
Worksheet/Sheet: Individual tab within a workbook
Cell: Intersection of row and column (e.g., A1, B3)
Cell Address / Reference: Column letter + Row number
Range: Group of cells (e.g., A1:D10)

Data Entry & Types

Text (Labels) — left-aligned
Numbers (Values) — right-aligned
Dates & Times
Formulas — start with = sign

Important Formulas & Functions FunctionPurposeExample SUMAdd values=SUM(A1:A10) AVERAGEFind mean=AVERAGE(B1:B5) MAXLargest value=MAX(C1:C20) MINSmallest value=MIN(C1:C20) COUNTCount numeric cells=COUNT(A1:A10) IFConditional logic=IF(A1>50,"Pass","Fail") VLOOKUPVertical lookup=VLOOKUP(A1,B:D,2,0) Charts

Select data → Insert tab → Charts
Types: Bar, Column, Line, Pie, Area, Scatter

Important Shortcut Keys ShortcutAction Ctrl+HomeGo to cell A1 Ctrl+EndLast used cell F2Edit active cell Ctrl+Shift+LAutoFilter Alt+EnterNew line within cell

MS Excel — ADCA Notes

MS Excel — ADCA Notes

💻 Code Editor - Try It Yourself