JKSSB Graduate Level ⏱️ 3 Min Read

MS Excel

Microsoft Excel

Definition: Electronic Spreadsheet software used for organizing, calculating, and analyzing data.

Extension: .xlsx (2007 onwards), .xls (2003 and earlier).

1. Key Terminology

  • Workbook: A collection of worksheets. The file itself.
  • Worksheet: A single page or sheet used to enter data.
  • Row: Horizontal line of cells. Identified by Numbers (1, 2, 3...).
  • Column: Vertical line of cells. Identified by Letters (A, B, C...).
  • Cell: Intersection of a Row and Column. Basic unit of data storage.
  • Cell Address: Location of a cell (e.g., A1, B5).
  • Active Cell: The cell currently selected (Green border).
  • Name Box: Displays the address of the active cell.
  • Formula Bar: Displays the content or formula of the active cell.
  • Range: A block of selected cells (e.g., A1:B10).

2. Data & Functions

Formulas: Always start with an = (Equal to) sign.

Common Functions:

  • =SUM(A1:A5): Adds values in the range.
  • =AVERAGE(A1:A5): Calculates the average.
  • =MIN(A1:A5): Finds the smallest value.
  • =MAX(A1:A5): Finds the largest value.
  • =COUNT(A1:A5): Counts cells containing numbers.
  • =NOW(): Returns current date and time.
  • =TODAY(): Returns current date only.
  • =LEN(text): Returns the number of characters in a text string.
  • =UPPER(text): Converts text to uppercase.

3. Charts

Graphical representation of data.

  • Column Chart: Vertical bars. Good for comparisons.
  • Bar Chart: Horizontal bars.
  • Pie Chart: Shows parts of a whole (Percentages).
  • Line Chart: Shows trends over time.
← Previous Chapter
Memory Primary and Secondary
Next Chapter →
MS PowerPoint