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

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

NCERT Solutions PDF Class 9 PDF

This resource provides detailed 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 better readability. 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 the fill handle for series continuation. 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 preparation for exams by offering clear explanations and step-by-step guidance.

Home

Quick info

Board	CBSE
Class	Class 9
Subject	Foundation of Information Technology
Session	2026
Language	English
Type	NCERT Solutions
Chapter	11. MS-Excel 2007

Chapter summary

This chapter's NCERT Solutions for MS-Excel 2007 (Class 9 FIT) provides clear explanations for essential spreadsheet concepts. It covers the structure of a workbook, the identification and addressing of cells, and the application of formatting for improved presentation. Students will learn about different number formats, the concept of relative referencing, and how to manage cell ranges. The solutions also detail practical skills like adding new worksheets and using the fill handle. Understanding formula evaluation is also addressed, making it a comprehensive guide for mastering basic MS-Excel functionalities.

Learning outcomes

Understand the structure and components of an MS-Excel workbook.
Identify and locate the active cell within a spreadsheet.
Explain the default alignment of text, numbers, and formulas.
Describe the purpose and methods of formatting data in Excel.
Determine cell addresses based on row and column positions.
Learn different ways to add new worksheets to a workbook.
Recognize various number formatting options available in Excel.
Define and apply the concept of relative referencing.

Topics covered

Paper topics

Workbook definition
Active cell identification
Default cell alignment (text, numbers, formulas)
Data formatting in Excel
Cell addressing (row and column intersection)
Adding new worksheets
Number formatting options
Relative referencing
Cell ranges
Fill handle functionality
Formula evaluation
Spreadsheet basics

Important topics

Workbook and Worksheet Structure
Active Cell and Cell Addressing
Data Formatting and Presentation
Relative Referencing and Cell Ranges
Using the Fill Handle for Data Series
Formula Evaluation Order

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 in MS-Excel is essentially a digital file that serves as a container for your spreadsheet data. It is composed of one or more individual worksheets, which are like separate pages where you can enter and organize your information. By default, when you create a new workbook in Excel, it typically comes with three pre-existing 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: An active cell in MS-Excel is the cell that is currently selected and ready to receive data or commands. You can easily identify the active cell on your screen because it is highlighted with a distinct, heavy black color boundary or border around it. Any typing or actions you perform will affect this specific cell.

Question 3

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

Solution: In MS-Excel, the default alignment for different types of data entered into cells is as follows: Text entries, often referred to as labels, are automatically aligned to the left side of the cell. Numbers and formulas, on the other hand, are set to align to the right side of the cell by default.

Question 4

Elaborate the formatting necessary.

Solution: Formatting in MS-Excel is crucial for enhancing the presentation and readability of your data. It allows you to modify the appearance of cells and their content. For instance, you can make text bolder, rotate it to a different angle, or change its color. Essentially, formatting helps to make your worksheet look neater, more organized, and easier to understand at a glance.

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, cells are identified by their address, which is formed by combining the column letter with the row number. Since Soham has selected the cell at the intersection of the first row and the ninth column, the address of this selected cell will be 'I1'. The ninth column is represented by the letter 'I', and the first row is represented by the number '1'.

Question 6

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

Solution: There are primarily two common methods to add a new worksheet to an existing Excel workbook:

Using the Insert Worksheet Tab: You can click on the small plus (+) icon, often labeled as 'Insert Worksheet', located at the bottom of the Excel window, usually next to the existing worksheet tabs.
Using the Home Tab: Navigate to the 'Home' tab on the Excel ribbon. Within the 'Cells' group, click on the 'Insert' button and then select 'Insert Sheet' from the dropdown menu.

Both methods achieve the same result of adding a new, blank worksheet to your workbook.

Question 7

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

Solution: MS-Excel offers a wide variety of ways to express and format numbers to suit different needs and contexts. Numbers can be displayed in numerous formats, including but not limited to:

As standard numerical values with or without decimal places.
As dates (e.g., DD/MM/YYYY or Month DD, YYYY).
As times (e.g., HH:MM:SS AM/PM).
As percentages (e.g., 50%).
In scientific notation for very large or small numbers.
As currency values with appropriate symbols.

These formatting options help in presenting numerical data clearly and appropriately.

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 known as the Formatting Toolbar. This is typically part of the main ribbon interface in modern versions of Excel.

Question 9

What do you mean by relative referencing?

Solution: Relative referencing is a method used in Excel formulas where cell references are defined based on their position relative to the cell containing the formula. When a formula with relative references is copied or filled into other cells, the references automatically adjust to maintain the same relative relationship. For example, if a formula in cell C1 refers to cell A1, and you copy this formula to cell C2, the reference in C2 will automatically change to A2 (assuming a simple downward copy).

Question 10

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

Solution: The cell range [A1; B2] refers to a rectangular block of cells starting from cell A1 and extending to cell B2. This range includes all cells within these boundaries. The cells included are A1, B1, A2, and B2. Therefore, there would be a total of 4 cells in 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 in MS-Excel to drag down from a cell containing a day of the week like 'Monday', Excel recognizes this as a series and automatically fills the subsequent cells with the following days in sequence. Therefore, if cell A1 contains 'Monday', dragging the Fill handle down will result in:

Cell A2 will contain 'Tuesday'
Cell A3 will contain 'Wednesday'
Cell A4 will contain 'Thursday'
Cell A5 will contain 'Friday'

This feature is very useful for quickly entering sequential data.

Question 12

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

Solution: When the formula

= 6 - 5 * 2

is entered into an Excel cell, the software evaluates it following the standard order of operations (often remembered by acronyms like PEMDAS or BODMAS). In this case, multiplication is performed before subtraction:

First, the multiplication is calculated: $5 * 2 = 10$ .
Then, the subtraction is performed: $6 - 10 = -4$ .

Therefore, the cell content will be -4.

Common mistakes

Confusing cell address with row or column number.
Incorrectly applying or understanding relative referencing.
Misinterpreting the order of operations in formula evaluation.
Not understanding the difference between text and number alignment.
Overlooking the fill handle's functionality for series generation.

Revision tips

Practice identifying cell addresses and ranges in a sample Excel sheet.
Experiment with different formatting options to see their effect on data presentation.
Try creating simple formulas and observe how Excel evaluates them.
Use the fill handle to auto-complete series for dates, numbers, and text.
Review the definitions of key terms like workbook, worksheet, and active cell.

Practice MCQs

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

Q2. Which of the following best describes an active cell in Excel?

Q3. By default, how is text aligned in an Excel cell?

Q4. What is the cell address for the intersection of the first row and the ninth column?

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

Q6. What does relative referencing mean in Excel?

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 on my Excel screen?

The active cell is the currently selected cell, which is highlighted with a thick, dark border around it. It's the cell where your input will appear.

What is the default alignment for numbers and text in Excel?

By default, text (or labels) are left-aligned in an Excel cell, while numbers and formulas are right-aligned.

What does it mean to format data in Excel?

Formatting data in Excel involves changing its appearance, such as making it bold, changing its color, rotating text, or applying different number styles, to make the worksheet look neater and more legible.

How do I find the address of a cell at the intersection of the first row and ninth column?

The address is determined by the column letter followed by the row number. The ninth column is 'I' and the first row is '1', so the address is I1.

What is relative referencing in Excel?

Relative referencing means that cell references in a formula are based on their position relative to the cell containing the formula. If you copy the formula, these references adjust automatically.

How does Excel evaluate the formula = 6 - 5 * 2?

Excel follows the order of operations (PEMDAS/BODMAS). Multiplication is performed before subtraction, so it calculates 5 * 2 = 10 first, and then 6 - 10 = -4.

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

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