MS Excel
Computers · MS Excel
📋Quick Overview
MS Excel is a spreadsheet application by Microsoft used for data analysis, calculations, and creating charts. A workbook contains worksheets. Each worksheet has cells arranged in rows (numbered 1,2,3...) and columns (lettered A,B,C...). Excel formulas begin with = sign. By default, a new workbook has 1 worksheet (earlier versions had 3).
⭐
Excel file extension: .xlsx (macro-enabled: .xlsm); Rows: 1,048,576; Columns: 16,384 (XFD)
⭐
Common formulas: =SUM(), =AVERAGE(), =COUNT(), =MAX(), =MIN(), =IF(), =VLOOKUP()
📖MS Excel — Key Table
| Function | Syntax | Use |
|---|---|---|
| SUM | =SUM(A1:A10) | Adds all values in range |
| AVERAGE | =AVERAGE(A1:A10) | Calculates mean |
| COUNT | =COUNT(A1:A10) | Counts cells with numbers |
| MAX/MIN | =MAX(A1:A10) | Finds largest/smallest value |
| IF | =IF(A1>10,"Yes","No") | Logical test — returns value based on condition |
| VLOOKUP | =VLOOKUP(val,range,col,0) | Vertical lookup — searches column for value |
| CONCATENATE/& | =A1&" "&B1 | Joins text strings together |
| LEN | =LEN(A1) | Returns length of text |
| TODAY/NOW | =TODAY() | Returns current date/time |
📝Important Points
- •Cell reference: A1 (column A, row 1); Range: A1:C10
- •Relative reference (A1): changes when copied; Absolute ($A$1): stays fixed
- •Ctrl+; inserts current date; Ctrl+Shift+; inserts current time
- •Chart types: Bar, Line, Pie, Scatter, Area, Column