CBSE Class 9 Foundation of Information Technology: MS-Excel 2007 Solutions

Reviewed by NCERT Help Editorial Team · Updated on 29 Jul 2026

NCERT Solutions PDF Class 9 PDF

This chapter provides NCERT Solutions for Class 9 Foundation of Information Technology, focusing on MS-Excel 2007. It covers fundamental concepts such as defining a workbook, identifying the active cell, understanding default alignments for text and numbers, and the importance of formatting for data presentation. The solutions also explain how to determine cell addresses, add new worksheets, and format numbers in various ways. Key topics include relative referencing, cell ranges, and the use of fill handles for auto-filling data. Additionally, it touches upon formula evaluation order in Excel. These solutions are designed to help students grasp the essential features of MS-Excel 2007, aiding in their exam preparation and practical understanding of spreadsheet software.

Home

Quick info

Board	CBSE
Class	Class 9
Subject	Foundation of Information Technology
Session	2026
Language	English
Type	NCERT Solutions
Chapter	Chapter 11

Chapter summary

Chapter 11, MS-Excel 2007, provides essential NCERT Solutions for Class 9 Foundation of Information Technology. It covers the basics of Excel, including workbooks, worksheets, active cells, and default alignments. Students will learn about formatting techniques to enhance data readability, how to identify cell addresses, and methods for adding new worksheets. The chapter also explains number formatting, relative referencing, cell ranges, and the functionality of the fill handle. Finally, it addresses the order of operations in formula calculations within Excel. These solutions offer a clear understanding of core Excel functionalities for students.

Learning outcomes

Understand the concept of a workbook and its components in MS-Excel.
Identify the active cell and understand default alignments in a spreadsheet.
Explain the purpose and methods of formatting data in Excel.
Determine cell addresses and understand cell referencing concepts.
Learn how to add new worksheets to an Excel workbook.
Recognize different ways to format numbers in Excel.
Apply the fill handle for auto-filling data based on patterns.
Understand the order of operations in Excel formulas.

Topics covered

Paper topics

Workbook definition
Active cell identification
Default cell alignment (text, numbers, formulas)
Data formatting in spreadsheets
Cell addressing
Adding new worksheets
Number formatting options
Formatting Toolbar
Relative referencing
Cell ranges
Fill handle functionality
Formula evaluation order

Important topics

Workbook and Worksheet structure
Cell Addressing and Referencing
Formatting for Data Presentation
Fill Handle and Auto-filling
Order of Operations in Formulas

PDF preview

Read page by page below. PDF is streamed from the official NCERT website — no download button on this page.

Loading document …

Page of

Loading page …

Questions and Solutions

Question 1

Define the term workbook.

Solution: A workbook is the primary file in Microsoft Excel, serving as a container for all the data and elements you create. It is essentially a collection of one or more individual worksheets, which are like pages where you enter and organize your data. By default, when you open a new Excel file, it comes with three blank worksheets.

Question 2

Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. Help Reena in identifying the active cell on her screen.

Solution: Reena, the active cell is the one that is currently selected and ready for input or editing. You can identify it on your screen because it will have a thick, dark black border surrounding it. Any typing you do or commands you issue will affect this specific cell.

Question 3

What is the default alignment of number, text and formula in a spreadsheet?

Solution: In a spreadsheet like MS Excel, the default alignment for different types of data helps in organizing them visually. Text entries (often called labels) are typically aligned to the left side of the cell. Numbers and formulas, on the other hand, are usually aligned to the right side of the cell by default.

Question 4

Elaborate the formatting necessary.

Solution: Formatting in a spreadsheet is crucial for making your data clear, organized, and visually appealing. It involves changing the appearance of cells and their content without altering the actual data values. For instance, you can make text bolder, change its color, rotate it, adjust font sizes, or apply borders. Proper formatting makes your worksheet easier to read, understand, and present, giving it a neater and more legible outlook.

Question 5

Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell?

Solution: In MS Excel, columns are identified by letters and rows by numbers. The first row is designated as '1', and the ninth column is designated as 'I'. Therefore, the cell located at the intersection of the first row and the ninth column has the address I1.

Question 6

How many ways are there for adding a new worksheet in an Excel workbook?

Solution: There are multiple ways to add a new worksheet to an existing Excel workbook, making it convenient for users. Two common methods include:

Clicking the 'Insert Worksheet' tab (often a plus sign '+') located at the bottom of the workbook window, next to the existing sheet tabs.
Using the 'Insert' button found within the 'Cells' group on the 'Home' tab in the Excel ribbon. This option provides a dropdown menu where you can select 'Worksheet'.

Question 7

In Excel, how many ways are there to express/format a number?

Solution: MS Excel offers a variety of ways to format numbers to suit different presentation needs. Instead of just displaying a raw number, you can express it in numerous formats. Common examples include formatting numbers as dates (e.g., 15-03-2023), times (e.g., 10:30 AM), percentages (e.g., 50%), or with a specific number of decimal places (e.g., 123.45).

Question 8

Name the toolbar of spreadsheet which has all the options of changing the font properties.

Solution: The toolbar in a spreadsheet application that contains all the options for changing font properties, such as font type, size, color, and style (like bold or italics), is commonly referred to as the Formatting Toolbar. In modern versions of Excel, these options are primarily found within the 'Font' group on the 'Home' tab of the ribbon.

Question 9

What do you mean by relative referencing?

Solution: Relative referencing is a fundamental concept in spreadsheet formulas. When you refer to a cell by its relative position in the worksheet (e.g., the cell one row above and two columns to the left), Excel understands this relationship. If you copy a formula that uses relative references to a different cell, the references automatically adjust to maintain the same relative positions, ensuring the formula works correctly in its new location.

Question 10

How many cells would be there in the cell range [A1; B2]?

Solution: A cell range specifies a rectangular block of cells. The range [A1; B2] includes all cells starting from cell A1 and extending to cell B2. This encompasses the cells A1, B1, A2, and B2. Therefore, there are a total of 4 cells within the specified cell range.

Question 11

The cell A1 has value Monday. If you are asked to click and drag the Fill handle of A1 downside then what will be the contents of cell A2, A3, A4 and A5?

Solution: When you use the Fill Handle on a cell containing a day of the week like 'Monday', Excel recognizes the pattern and automatically continues the sequence. By clicking and dragging the Fill Handle downwards from cell A1, Excel will fill the subsequent cells with the following days in order. Thus, cell A2 will contain 'Tuesday', A3 will contain 'Wednesday', A4 will contain 'Thursday', and A5 will contain 'Friday'.

Question 12

If = 6 -5 *2 is entered in a cell, then what will be the cell content?

Solution: When you enter a formula in an Excel cell, the program calculates the result based on the standard order of mathematical operations (often remembered by acronyms like PEMDAS or BODMAS). In the formula = 6 - 5 * 2, multiplication is performed before subtraction. First, 5 * 2 is calculated, which equals 10. Then, 6 is subtracted from 10 (6 - 10), resulting in -4. This value, -4, will be displayed in the cell.

Common mistakes

Confusing workbook with worksheet.
Incorrectly identifying cell addresses or ranges.
Misunderstanding the concept of relative referencing.
Errors in predicting formula results due to incorrect order of operations.
Not recognizing the default alignment for different data types.

Revision tips

Review the definitions of key Excel terms like workbook and active cell.
Practice identifying cell addresses and understanding cell ranges.
Experiment with different formatting options to see their effect on data presentation.
Understand the order of operations (PEMDAS/BODMAS) as applied in Excel formulas.
Use the fill handle feature to quickly populate data and observe its behavior.

Practice MCQs

Q1. What is a collection of worksheets called in MS-Excel?

Q2. Which alignment is the default for text entries in an Excel cell?

Q3. What is the address of the cell located at the intersection of the first row and the ninth column?

Q4. Which feature in Excel allows you to automatically fill a series of data based on a pattern?

Q5. In the formula = 6 - 5 * 2, what is the result Excel will calculate?

Frequently asked questions

What is a workbook in MS-Excel 2007?

A workbook in MS-Excel 2007 is a file that contains one or more worksheets. By default, a new workbook usually starts with three worksheets.

How can I identify the active cell in an Excel sheet?

The active cell is the currently selected cell in the worksheet. It is typically highlighted with a heavy black border around it.

What is the difference between text and number alignment in Excel?

By default, text entries are left-aligned in a cell, while numbers and formulas are right-aligned. This helps in distinguishing between data types at a glance.

What does 'relative referencing' mean in Excel?

Relative referencing means that cell references in a formula automatically adjust when the formula is copied to another cell. They are based on the relative position of the cells.

How does Excel evaluate formulas like = 6 - 5 * 2?

Excel follows the standard order of operations (PEMDAS/BODMAS). In this case, it first calculates the multiplication (5 * 2 = 10) and then performs the subtraction (6 - 10 = -4).

What is the purpose of the Fill Handle in Excel?

The Fill Handle is used to quickly copy the content of a cell or to extend a series of data (like numbers, dates, or text) into adjacent cells based on a pattern.

Content reviewed by the NCERT Help team. Editorial Team and update policy

NCERT Solutions PDF PDF on NCERT Help. URL unchanged for search indexing.