IT Tools and Business Systems Chapter 05 Spreadsheet Notes Set 01

Official Study Materials for Computer Science

Access comprehensive study materials and useful resources for MS Office using the IT Tools and Business Systems Chapter 05 Spreadsheet Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.

Advanced Resources for Computer Science

Navigate directly to the advanced Computer Science study materials using the digital viewer below. Each resource pack includes detailed conceptual summaries and solved practice questions, allowing students to instantly reinforce their learning.

This chapter introduces the Excel spreadsheet: the parts of the window, creating, saving and editing workbooks, adding and deleting worksheets, and entering data and formulas. It also covers the four kinds of operators, the main groups of functions, cell formatting, printing, charts, and importing text files and web tables.

Objectives

At the end of the chapter the users will be able to:

  • understand the concept of an electronic spreadsheet
  • understand the functions in a spreadsheet
  • know how to format a worksheet
  • understand the usage of charts and graphs
  • know how to integrate text and web pages

Overview of Spreadsheet

  • Microsoft Excel is the most widely used spreadsheet package and lets the user organize data into lists and then summarize, compare and present the data graphically.
  • A spreadsheet is a generic term for the software application package that simulates a paper worksheet, often used by people in management.
  • Microsoft Excel is an electronic spreadsheet.
  • MS Excel can be used for a variety of tasks, which include automating financial statements.
  • The spreadsheet is an interactive computer application program for organizing and analyzing data in tabular form.
  • The spreadsheet program operates on data represented as cells of an array, organized in rows and columns.
  • Each cell of the array is an element that contains numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
  • Data stored in database formats can be accessed through MS Excel.
  • Excel emerges as a powerful and flexible graphical presentation tool. Graphs or charts can be created based on data, for quick assessment of a situation.

Parts of the Excel window

PartDescription
Name BoxA quick and easy way to move around and select ranges in a large spreadsheet.
Office ButtonIn the upper left corner of the Excel 2007 window is the Microsoft Office button. Clicking it displays a drop-down menu containing a number of options.
Quick Access ToolbarNext to the Microsoft Office button. It is grouped with Save, Undo, Redo and Print options.
Title barNext to the Quick Access Toolbar. Microsoft Excel displays the name of the current workbook on the title bar.
RibbonIn Microsoft Excel 2007, the Ribbon is located at the top of the Excel window and below the Quick Access Toolbar. It has several tabs; clicking a tab displays several related command groups, and within each group are related command buttons.
Tab listSimilar to a menu, it displays a different ribbon.
Column lettersColumns are vertical lines of cells. They are named from A to Z and then continuing from AA to AZ, BA to BZ and so on.
Row numbersRows are horizontal lines of cells. A number identifies each row. The rows are numbered 1 to 1,048,576.
Formula barA toolbar at the top of the Microsoft Excel spreadsheet window. It can be used to enter or copy an existing formula into the cells or charts. It shows the contents of the current cell and allows the user to create and view formulas. It is labeled with the function symbol (fx). The formula bar becomes activated when the user types an equal (=) symbol in a cell, or clicks on it.
Status barDisplays various messages like the status of the Num Lock, Caps Lock and Scroll Lock keys on the keyboard.
Active cellThe dark outline indicates the currently active cell.
Sheet tab scroll buttonsOn the bottom left of the worksheet, used to move to the First sheet, Previous sheet, Next sheet and Last sheet.
Page view buttonsChange the way the worksheet is displayed by clicking one of these buttons.
Page zoom controlThe worksheet has zoom in and zoom out controls.

Working with Spreadsheet

Creating a new workbook

Creating a blank workbook: To create a new Excel file, click the File tab, then click the New button and then double click Blank Workbook, or click the Create button.

Creating from a sample template: To open a template, click the File tab, then click the New button and then double click one of the templates, or click the Create button.

Saving a workbook

1. For saving a workbook, click the File tab and then click Save or Save As, or press Ctrl + S on the keyboard.
2. Select the required drive, type the file name, check the file type, and then click the Save button.

Editing a workbook

  • To edit a saved workbook, open the existing file, make changes in the file and then save.
  • To move or copy entire data, select the data and point to the top, bottom, left or right border around the data. When the mouse pointer appears as an arrow, drag and drop.

Inserting and Deleting Worksheets

Excel gives three worksheets by default.

To add a worksheet:

1. Right click the tab of the sheet before which the user wants to add the new one. To insert a sheet between sheets 2 and 3, for instance, right click the Sheet 3 tab.
2. Choose Insert and then double click Worksheet.

To delete a worksheet:

1. Right click the tab of the sheet which the user wants to delete.
2. Then click Delete.

Entering Data into Spreadsheet

  • Enter data into a spreadsheet by typing in the active cell.
  • After typing, press the ENTER key; the next cell becomes active.
  • The user can also use the arrow keys to move from one cell to another.

The user can enter the student details table by doing the following steps:

1. In the blank workbook, move the cell pointer to cell A1. Type S.NO.
2. Press the right arrow key to move to cell B1. Type STUDENT NO.
3. Press the right arrow key to move to cell C1. Type STUDENT NAME.
4. Press the right arrow key to move to cell D1. Type MARK1.
5. Press the right arrow key to move to cell E1. Type MARK2.
6. Press the right arrow key to move to cell F1. Type MARK3.
7. Press the right arrow key to move to cell G1. Type TOTAL.
8. Now move the cursor to cell A2 and press Enter. Repeat the steps to enter the data for S.NO, STUDENT NO, STUDENT NAME, MARK1, MARK2 and MARK3.
9. Move the cell pointer below the TOTAL field (G2).
10. Enter the formula in the formula bar as =SUM(D2+E2+F2) for calculating the TOTAL and then press ENTER.
11. The TOTAL is displayed. Then drag the active cell at G2 down to G6; the totals for all the following cells are calculated.

Handling Operators

  • Excel allows the user to use formulae to calculate and analyze data in the worksheet.
  • A formula uses the values in cells to perform operations such as addition, subtraction, multiplication and division.
  • Formulas need mathematical operators such as (+, -, *, /) and can use the cell reference or cell names for referring to the contents of a cell.
  • A formula always begins with an equal (=) sign.

There are four types of operators: arithmetic operators, comparison operators, text operator and reference operators.

Arithmetic operators

These are used to perform basic mathematical operations, and to combine numeric values to produce a numeric result.

OperatorNameExampleResult
+Addition=10+515
-Subtraction=10-55
-Negation=-10-10
*Multiplication=10*550
/Division=10/52
%Percentage=10%0.1
^Exponentiation=10^5100000

Comparison operators

These are used to compare two values and produce a logical result, either True or False (0 or 1). The following are the logical operators.

OperatorNameExampleResult
=Equal to=10=5FALSE
>Greater than=10>5TRUE
<Less than=10<5FALSE
>=Greater than or equal to="a">="b"FALSE
<=Less than or equal to="a"<="b"TRUE
<>Not equal to="a"<>"b"TRUE

Text operator

This operator joins two or more text values to produce a single combined text value. Text formulas use the ampersand (&) operator to work with text cells, text strings enclosed in quotation marks, and text function results.

OperatorNameExampleResult
&ampersand="soft"&"ware"software

Reference operators

The reference operators combine two cell references or ranges to create a single joint reference.

OperatorNameDescription
: (colon)RangeProduces a range from two cell references such as A1:C5
(space)IntersectionProduces a range that is the intersection of two ranges such as A1:C5 B2:E8
, (comma)UnionProduces a range that is the union of two ranges such as A1:C5,B2:E8

Functions

  • A function is a predefined formula in Excel.
  • Like formulas, functions begin with the equal sign ( = ) followed by the function's name and its arguments.
  • The function name tells Excel what calculation to perform.
  • The arguments are contained inside round brackets.

There are several types of functions in a spreadsheet; some of them are: Math Functions, Logical Functions, Statistical Functions, Text Functions, and Date and Time Functions.

Math Functions
The Excel math functions are provided by Excel to carry out many of the common mathematical calculations, including basic arithmetic, conditional sums and products, and the trigonometric ratios.
E.g. ABS(), CEILING(), COS(), SIN(), LOG() etc.

Logical Functions
Logical functions are provided by Excel to help the user to work with the logical values TRUE and FALSE. They include boolean operators, conditional tests and functions to return the constant logical values.
E.g. IF(), NOT(), TRUE(), FALSE(), AND() etc.

Statistical Functions
Excel provides a large selection of statistical functions that perform most of the common statistical calculations, from basic mean, median and mode calculations to the more complex statistical distribution and probability tests.
E.g. AVERAGE(), COUNT(), CORREL(), FDIST(), FINV() etc.

Text Functions
Text functions are provided by Excel to help the user to work with text strings. They include functions to return information about a text string, to apply formatting to a text string, to convert between text and other data types, and to cut up and join together text strings.
E.g. FIND(), CONCATENATE(), LOWER(), UPPER(), MID() etc.

Date and Time Functions
Date and Time functions are used to calculate dates, times and days.
E.g. DATE(), DAY(), MONTH(), HOUR(), MINUTE() etc.

Function Wizard

  • The Function Wizard prompts the user for the information needed for each function.
  • It can be useful if users are not sure of the correct format to use to enter the formula.
  • The Function Wizard also gives a description of the function at the bottom, as well as presenting the formula result.
  • It also offers many built-in functions which the user can utilize.

Formatting a Worksheet

  • In Excel, every cell can be formatted differently.
  • There are many options available to customize the Excel workbook, which can make the worksheet easier to read.
  • Excel also provides many number formats, allowing the user to standardize how numbers will appear in the document.

Formatting cells includes the following: changing data alignment, date fields, currency or accounting fields, and changing font.

Changing Data Alignment

  • Formatting is the process of changing the appearance of the data in a worksheet.
  • The default alignment of text data, such as labels and column titles, is on the left side of a cell.
  • Numbers, formulas and dates, which are referred to as values, are right aligned by default.
  • These default alignments are not always the best choice for the user's data, so Excel makes it easy to improve the layout and appearance of a worksheet by using the cell alignment icons on the Home tab of the ribbon. The Alignment group is under the Home tab.

Vertical Alignment
In vertical alignment there are three options: Top Align, Middle Align and Bottom Align. To change the vertical alignment:

1. Select a cell or range of cells.
2. Click the Top Align, Middle Align or Bottom Align command.

Horizontal Alignment
Horizontal alignment is used to align the text left, centre and right. To align text or numbers in a cell:

1. Select a cell or range of cells.
2. Click either the Align Left, Center or Align Right command on the Home tab.

Orientation
The user can rotate data clockwise, counterclockwise, vertically, rotate text up or down, or click Format Cell Alignment to set a more precise orientation by specifying the number of degrees to rotate the text.

1. Select the cell.
2. On the Home tab of the ribbon, in the Alignment group, locate the button containing "ab" (angled, with an arrow underneath).
3. Click the button to display the Orientation menu.

Indentation
Select Increase Indent to increase the indentation within the cell by one character space. Select Decrease Indent to remove indentation by one character space.

Indenting cell data:

1. Select the cells containing the text which the user wants to indent.
2. Click the Increase Indent button in the Alignment group on the Home tab.
3. Each time the user clicks the Increase Indent button, Excel adds a small amount of space between the cell border and the data itself.

Removing cell indentation:

1. Select the cells containing the indented text.
2. Click the Decrease Indent button in the Alignment group on the Home tab.
3. Each time the user clicks the Decrease Indent button, Excel removes a small amount of space between the cell border and the data itself.

Wrap Text
Wrap Text wraps the contents of a cell across several lines if they are wider than the column width.

Merge & Center
Merge & Center is used to merge cells and centre the text, merge across multiple rows of cells, and merge and unmerge the selected cells.

To change text control:

1. Select a cell or range of cells.
2. Select the Home tab.
3. Click the Wrap Text command or the Merge & Center command.

Date Fields

1. Highlight all the date fields.
2. Select the Home tab.
3. In the Cells group, click the Format button.
4. From the drop-down list, select Format Cells.
5. In the dialog box, select the Number tab.
6. Select Date in the column at the left of the dialog box.
7. Select one of the date formats and highlight that choice.
8. Click OK to save the format.

Currency or Accounting Fields

  • Currency format: displays the currency symbol immediately to the left of the number and displays a minus sign in front of negative values.
  • Accounting format: displays the currency symbol at the left edge of the cell, lines up the decimal points in a column, and encloses negative values within parentheses. It also indents numbers slightly from the right edge of the cell to accommodate the right parenthesis in negative values.

Follow these steps to format numbers in Excel 2007 as currency:

1. Select the cells containing the numbers that the user wants to format.
2. From the Home tab, click the Number dialog box launcher in the bottom-right corner of the Number group.
3. The Format Cells dialog box appears, with the Number tab on top.
4. In the Category list, select Currency.
5. Change any other options as desired, such as the number of decimal places or the symbol to use for currency. The Accounting format also enables the user to choose different ways to display negative values.
6. Click OK.

Changing Font

  • The characters that Excel displays on the screen have a specific font type, style, size and colour.
  • Excel allows the user to change the font characteristics in a single cell, a range of cells, the entire worksheet or the entire workbook.
  • From the Font Face drop-down list choose one of the fonts as needed.
  • Font Size is used to change the size of the font. Increase and Decrease Font Size increase and decrease the size of the font.
  • Bold, Italic, Underline and Double Underline are used to make changes to the selected text.
  • Borders are used to put a border around the selected cells.
  • Fill Colour and Font Colour change the background and text colour.

Printing a Worksheet

1. From the File tab, in the Backstage view, click the Print option or use the keyboard shortcut Ctrl + P.
2. The user can now see the print preview.
3. To preview the other pages that will be printed, click Next Page or Previous Page at the bottom of the window.
4. Under Print, select the number of copies to be printed.
5. From Printer, choose the name of the printer.
6. In Settings, the first drop-down list has three options: Print Active Sheets, Print Entire Workbook and Print Selection.
7. Print Active Sheets: for printing only the active sheets.
8. Print Entire Workbook: for printing the entire workbook.
9. Print Selection: for printing only the selected portion of the sheet.
10. Pages can be specified by entering the page numbers in the text boxes.
11. If one copy contains multiple pages, the user can switch between Collated and Uncollated.
12. The user can switch between Portrait Orientation (more rows but fewer columns) and Landscape Orientation (more columns but fewer rows).
13. Select the paper size as needed.
14. Select one of the predefined margins (Normal, Wide or Narrow) from the Margins drop-down list.
15. Select Fit Sheet on One Page from the Scaling drop-down list.
16. After all changes are made, finally click the Print button to get the printout.

Working with Charts

Creating charts

1. To select the data for creating a graph, click on the first cell of data and then drag the cursor over the remaining data to be included as part of the chart.
2. Go to the Insert tab and click the Line chart under the Charts group.
3. Click the chart, go to the Design tab and click the chart layouts for creating a chart title.
4. The user can change the title name and axis names.
5. To edit the names of the series, first click on the graph to activate the Chart Tools menu. Under Chart Tools choose the Design tab and, under the Data group, click Select Data.
6. To edit the name of a series, highlight it and then click the Edit button.
7. When the Edit Series dialog box appears, type the series name in the box labeled Series name.

Previewing charts

If the user wants to print, go to the File tab and click the Print option, or press Ctrl + P on the keyboard. On the print page the user can see the preview of the page on the right side.

Modifying charts

1. Click the chart and drag it to another location on the same worksheet, or click the Move Chart button on the Design tab.
2. Click the Object in radio button to choose where the object is placed. Then click OK.
3. To change the colour of the chart, click Design and click any one of the Chart Styles.
4. To reverse which data are displayed in rows or columns, click the chart and then click the Switch Row/Column button on the Design tab.

Integrating Text into Spreadsheet

1. Open a blank or existing Excel 2010 spreadsheet. Click the Data tab on the Ribbon and choose From Text.
2. Choose the text file the user wants to import and double click it. This will open the Text Import Wizard.
3. In Step 1, the user can choose the data type and the row at which to start the data, and click Next.
4. Step 2 of the wizard allows the user to manage the break lines (delimiters) between the data.
5. Step 3 of the wizard allows the user to choose column formats, provides a data preview, and other advanced settings. When everything is organized, click Finish.
6. A final window will be displayed asking where the user wishes to put the data in the sheet. The user can select either Existing Worksheet or New Worksheet.
7. The text data will now be placed in the Excel sheet.

Integrating Web Pages into Spreadsheet

1. From the Excel Ribbon click on Data.
2. From the Data tab, in the Get External Data group, click From Web. A New Web Query dialog box is displayed.
3. Enter the website address that the user wants to get data from, and click Go. The page will load in the preview box, and the user might have to scroll to find the data wanted on the page.
4. The user will see a small arrow beside any web tables that can be imported into Excel. Click the arrow to select the data, and then click the Import button at the bottom of the dialog.
5. Select where the user wants Excel to place the web data, and click OK.
6. A message in the spreadsheet shows that Excel is getting the data.
7. After a few moments, the web data will appear in Excel.

Summary

In this chapter, we have learnt about:

  • Spreadsheet concepts
  • How to create, save, edit, insert and delete worksheets
  • How to handle operators
  • Various types of functions
  • Formatting a spreadsheet in different ways
  • Usage of charts and graphs
  • Integrating text and web pages

Computer Science Exam Resources: MS Office

Essential Notes for Computer Science

Review targeted study resources for MS Office tailored for learners. Utilizing these structured notes and quick-revision tools ensures complete alignment with current CBSE evaluation standards.

Verified Solutions for Computer Science

Each resource draws directly from authorized textbooks to maintain academic accuracy. Evaluating solved examples allows students to master the formal presentation and answer-writing standards expected in upcoming school exams.

Enhance Accuracy with Online Tests

Wrap up your chapter revision by testing your knowledge against standard objective question formats. Explore our full library of free, up-to-date sample papers and online assessments to secure top grades in your CBSE examinations.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.