Skip to content
Excel Spreadsheet – Study Notes
“`

Excel Spreadsheet

Excel is a spreadsheet software developed by Microsoft. It is used to store, organize, calculate, analyze, and present data in a tabular format.

1. What is Excel?

Microsoft Excel is a spreadsheet application in which data is arranged in rows and columns. The intersection of a row and a column is called a cell.

Example:

If a student’s name is entered in cell A2 and the marks are entered in cell B2, Excel can be used to calculate the student’s total, average, grade, etc.

2. Uses of Excel

  1. Store large volumes of data: Excel can store information in rows and columns.
    Example: Maintaining a list of students, employees, products, customers, or sales records.
  2. Manage data: Excel provides features such as sorting, filtering, and rearranging data.
    Example: Sort employees according to salary or filter students who scored more than 80 marks.
  3. Query and perform calculations: Excel formulas and functions can be used to perform calculations.
    Example: =SUM(B2:B10) calculates the total of values from B2 to B10.
  4. Analyze data and prepare reports: Excel can create charts, tables, PivotTables, and other reports.
    Example: A column chart can be used to compare monthly sales.
  5. Print data: Excel allows users to format and print worksheets and reports.
    Example: A school can print a formatted student marks report.

3. Common Versions of Excel

Microsoft Excel has been released in many versions over the years. Some commonly known versions include:

Excel Version Example of Usage
Excel 2007 Used for spreadsheet creation, calculations, charts, etc.
Excel 2010 Introduced improvements to data analysis and visualization.
Excel 2016 Provided improved charts, analysis tools, and data features.
Excel 2019 Included additional functions, charts, and productivity features.
Note: Excel is also available in newer Microsoft 365 versions, which receive feature updates over time.

4. Workbook and Worksheet

Workbook

An Excel file is called a Workbook. It can contain one or more worksheets.

The default workbook name when creating a new workbook is commonly displayed as Book1, followed by Book2, Book3, etc., until the file is saved with a chosen name.

Worksheet

A worksheet, also called a sheet, is the working area inside an Excel workbook. It consists of rows and columns and is used to enter and work with data.

Example:

A workbook named School_Records.xlsx might contain:

  • Sheet 1 – Student Details
  • Sheet 2 – Marks
  • Sheet 3 – Attendance

5. Excel Keyboard Shortcuts

Shortcut Action Example
Ctrl + N Create a new workbook Opens a new Excel workbook.
Ctrl + O Open an existing workbook Opens the file selection window.
Ctrl + S Save the workbook Saves changes made to the workbook.

6. Excel File Format

Modern Excel workbooks are commonly saved with the .xlsx file extension.

Example:

If the workbook is named Student_Marks, it can be saved as:

Student_Marks.xlsx

7. Rows and Columns in a Worksheet

In modern versions of Excel, a worksheet contains:

  • 16,384 columns
  • 1,048,576 rows

Columns are identified using letters, while rows are identified using numbers.

Example:
  • Column A – first column
  • Column B – second column
  • Row 1 – first row
  • Row 2 – second row
  • A1 – cell at the intersection of column A and row 1

8. Cells and Cell References

A cell is the basic unit of an Excel worksheet. Every cell has a unique address called a cell reference.

Example:
Cell Possible Data
A1 Student Name
B1 Marks
A2 Rahul
B2 85

9. Simple Excel Formula Example

Excel formulas generally begin with an equals sign (=).

Example:

If cells B2, B3, and B4 contain marks:

B2 = 80
B3 = 75
B4 = 90

You can calculate the total using:

=SUM(B2:B4)

The result will be 245.

10. Quick Revision Table

Topic Important Point
Excel Spreadsheet software used to store, manage, calculate, analyze, and present data.
Workbook An Excel file containing one or more worksheets.
Worksheet A working sheet containing rows and columns.
File extension .xlsx
Columns 16,384 in a modern Excel worksheet.
Rows 1,048,576 in a modern Excel worksheet.
New workbook Ctrl + N
Open workbook Ctrl + O
Save workbook Ctrl + S

11. Practice Questions

A. Fill in the Blanks

  1. Excel is a __________ software.
  2. An Excel file is called a __________.
  3. A workbook contains one or more __________.
  4. The common file extension of a modern Excel workbook is __________.
  5. The shortcut key for creating a new workbook is __________.
  6. The shortcut key for opening an existing workbook is __________.
  7. The shortcut key for saving a workbook is __________.
  8. A worksheet contains rows and __________.

B. Multiple Choice Questions

  1. Which of the following is spreadsheet software?
    A. MS Paint    B. Microsoft Excel    C. Notepad    D. Calculator
  2. Which shortcut is used to save an Excel workbook?
    A. Ctrl + N    B. Ctrl + O    C. Ctrl + S    D. Ctrl + P
  3. Which file extension is commonly used for modern Excel workbooks?
    A. .docx    B. .pptx    C. .xlsx    D. .txt
  4. What is the intersection of a row and a column called?
    A. Worksheet    B. Cell    C. Workbook    D. Table
  5. How many columns are available in a modern Excel worksheet?
    A. 1,024    B. 16,384    C. 65,536    D. 1,048,576

C. Short Answer Questions

  1. What is Microsoft Excel?
  2. Write any five uses of Excel.
  3. What is a workbook?
  4. What is a worksheet?
  5. Differentiate between a workbook and a worksheet.
  6. What is a cell? Give an example of a cell reference.
  7. Write the shortcut keys for New, Open, and Save.
  8. How many rows and columns are available in a modern Excel worksheet?

D. Practical Questions

  1. Create a new Excel workbook using the keyboard.
  2. Enter the following data into a worksheet:

    Name English Maths Science
    Anil 80 75 90
    Priya 88 92 85
    Ravi 70 82 78
  3. Calculate the total marks for each student using the SUM function.
  4. Sort the students according to their total marks.
  5. Create a chart to compare the students’ marks.
  6. Save the workbook as Student_Marks.xlsx.

E. Think and Answer

  1. Why is Excel useful for managing a large amount of data?
  2. How can filtering help when working with a large worksheet?
  3. Why are formulas useful in Excel?
  4. What is the difference between sorting and filtering?
  5. How can charts help in analyzing data?

12. Summary

Microsoft Excel is a powerful spreadsheet application used for data storage, data management, calculations, analysis, reporting, chart creation, and printing. An Excel file is called a workbook, and each workbook can contain multiple worksheets. Data is entered into cells, which are organized into rows and columns.

Remember:
Ctrl + N → New Workbook
Ctrl + O → Open Workbook
Ctrl + S → Save Workbook
.xlsx → Common Excel Workbook File Extension
16,384 → Columns
1,048,576 → Rows
Excel Spreadsheet – Study Notes and Practice Material
“`