Official Study Materials for Computer Science
Explore structured advanced study materials through the Basic Computer Course BCC Chapter 04 Using Spreadsheet Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.
Advanced Resources for Computer Science
View or download the dedicated Basic Computer Course BCC Chapter 04 Using Spreadsheet Notes Set 01 resource below. Engaging with these advanced study guides under focused conditions ensures continuous academic progress and mastery of the 2026-27 curriculum for MS Office.
This chapter introduces MS Excel as an electronic spreadsheet, covering workbooks, worksheets, naming sheets, cell addresses, ranges, printing areas and saving. It goes on to data entry, auto-fill series, editing, clearing, copying, inserting and deleting rows and columns, resizing, formulas, functions and the Chart Wizard.
Introduction
MS Excel is an electronic spreadsheet. A spreadsheet is a generic term for the software package that simulates a paper worksheet often used by people in management. Most spreadsheets started as electronic versions of hard copy accounting worksheets with one major purpose, simple row and column arithmetic. It has various features to offer, namely fast calculations, what-if analysis, charts (also called graphs), automatic recalculation and many more.
A variety of applications for which MS Excel can be used include automating financial statements. Excel comes across as a powerful and flexible graphical presentation tool. Data stored in database formats can be accessed through MS Excel. Graphs or charts can be created based on data for quick assessment of a situation.
Objectives
After going through this unit, you will be able to:
1. Understand the features of Excel.
2. Navigate worksheets.
3. Make different types of entries in a worksheet.
4. Create text, numbers and data series.
5. Manipulate cells.
6. Create small budgets and sales reports.
Elements of Electronic Spreadsheet
When you start Excel, a workbook is displayed. It is here that Excel stores all its data and allows manipulation. A workbook is a collection of individual worksheets, each of which can hold data. All actions and operations of Excel take place in the worksheet. Excel has 65536 rows and 256 columns in its worksheets.
Opening of spreadsheet
Microsoft Excel can be started in the following way:
1. Click on the Start button in the Windows environment.
2. Select the Programs option from the Start menu.
3. Select the Microsoft Excel option from the Programs submenu. The Excel screen is displayed.
It has user interface features common to other Microsoft Office applications. Each worksheet is made up of cells that are the basic units for storing data.
Naming the sheets. Excel has its worksheets named Sheet1, Sheet2, Sheet3 and so on. Sheets can be given other names which may prove to be more convenient for task identification; for example, Workbook1 may contain sheets called Student, Mark sheet, Attendance and so on.
To name a sheet, double-click the sheet tab to which you want to give a new name. The Rename dialog box gets invoked where the new name can be specified. Or:
1. Go to the sheet tab and click the right mouse button.
2. Select Rename.
Once the dialog box is displayed, give the new name and click on the OK button.
Addressing of cells
Each worksheet is made up of cells, and cells are a result of the intersection of rows and columns. They are the basic units for storing data. Each cell gets its name from this intersection. The address of a cell that is in column A and has its row number as 4 is referred to as cell A4. A group of contiguous cells is called a range. An example of a cell range would be G1:G3.
In the worked example:
Cells A1 and A2 contain the names Chandan and Yashpal.
Cells B4 and C4 contain the values 400 and 800 respectively.
Cell G4 contains the formula = C4-B4.
Pressing the Enter key will result in G4 holding the result of the formula = (C4-B4).
All formula entries should begin with an = (equal to) sign. You can make a cell active by clicking on it. Files created by a spreadsheet package are known as workbooks. The automatic recalculation feature hastens the calculation tasks. If data in cell C4 is changed from 800 to 900, then the formula in cell G4 would calculate the result based on the new C4 cell content. This is due to the fact that once the formula is created with cell references in it, it establishes a relationship with the specified cell references or addresses. You can move around in a worksheet with the aid of a mouse or the keyboard, or by using the menu bars. You can use the arrow keys, Page Up, Page Down and a host of other keys in combination, to move around in the worksheet.
To move in the worksheet by using the menu bar: Select the Go To option from the Edit menu or press the F5 function key to open up the Go To dialog box, type the reference of the cell (for example E2) and click on the OK button of the Go To dialog box. The cell pointer moves to cell E2 immediately.
To move in the worksheet using the mouse: Select the cell you want to activate. Place the mouse pointer on it. Click to activate it. Several cells can be grouped to form a cell range. Cell ranges are required to be selected for calculation, and clicking on each one of them becomes a very tedious task. Cells can be selected using the keyboard or the mouse. To select a cell range, you can do the following.
Using the keyboard:
1. Move the cell pointer to the corner of the cell range which you want to select.
2. Click on the starting cell of the range.
3. Press and hold down the Shift key and then press the arrow keys to select the range.
Using the mouse:
1. Click on a corner of the range you want to select.
2. Drag the mouse over the range.
3. When you reach the end of the range, release the mouse button.
Printing of spreadsheet
Excel offers you various printing options for your worksheets. It enables you to have a preview of worksheet data with the aid of the Print Preview option. You can set margins, fonts, headers and footers to enhance your worksheets.
Printing an area. By default, Excel prints the current worksheet when the Print command is selected from the File menu. However, if you require a particular area of the worksheet to be printed, then you are offered this facility also. To do so, you can follow these steps:
1. Select the range that you want to print.
2. Select the Print option from the File menu.
3. The Print dialog box gets invoked.
4. In the Print what section of the dialog box, choose the Selection option.
5. Select the OK option to complete the procedure.
Defining and deleting a print area. There may be situations where you need to print the same range repeatedly. To avoid the tedium of specifying the same range for printing several times, you can conveniently define ranges as the print area.
1. Select the area you want to specify.
2. Select the Print Area option from the File menu.
3. Select Set Print Area from the Print Area submenu.
4. Select the Print option from the File menu.
5. Click on the OK button.
6. You can select Clear Print Area when you want to remove the defined print area.
To print worksheets, the steps are:
1. Select the Print option from the File menu. This invokes the Print dialog box.
2. This dialog box is very similar to the one you used in the MS Word Print dialog box. The only difference is the three extra buttons which are given below.
| Option | Effect |
|---|---|
| Selection | Prints selected cells. |
| Active sheet(s) | Prints only selected worksheets. |
| Entire workbook | Prints the open workbook. |
Printing worksheets. Worksheets can be very conveniently printed by the use of the Print command that sends your worksheet pages to the printer immediately.
Device options. Controls the print quality and allows you to adjust printer memory tracking (this affects how the driver tracks printer memory usage).
Saving workbooks
Whenever workbooks are created, they are named, by default, as Workbook1, Workbook2 and so on. Saving the worksheets of these workbooks makes them permanent. To save the work on your worksheets, you should follow the steps:
1. Select the Save option from the File menu to save it to the disk.
2. You can also click on the Save button on the standard toolbar.
3. Name the file you have saved and specify the location at which the workbook should be placed.
Saving multiple files. When you have a number of files that are open, you can conveniently save them all. You can select the Exit option from the File menu and click on the Yes to All button in the Save As dialog box that is displayed.
Saving as an HTML file. Excel allows you to publish your workbook data on the web and even move to other files by using hyperlinks. You can also save an Excel worksheet as an HTML file for publishing on the World Wide Web. To do so, you can select the Save as HTML option.
Manipulation of Cells
The active cell is indicated by a rectangular boundary over that cell. Data entry is accomplished by feeding the data in the active cell. A1 is always the active cell in a new worksheet by default, but if you want to move on to another cell for data entry, then you can make that cell active by moving the mouse pointer on it and clicking on it. As you type, the data is displayed in the active cell as well as in the formula bar.
Entering text, numbers and dates
Entering text. Text entries can be numbers, letters or symbols. Numbers can also be treated as text, especially in cases where calculations are not required; for example, telephone numbers, record numbers, zip codes, roll numbers and so on.
Excel studies the entered data to determine the type. If you type an address which is alpha-numeric in nature, it is automatically taken as a text entry, for example, 6 CGO Complex, New Delhi-110003. Numeric entries that are to be treated as text should be preceded with an apostrophe; for example, '64 is then considered as a text entry.
Entering numbers. Date and time entries can also be made in Excel worksheets. Excel allows calculation on dates because it converts the entry to a serial date number; for example, you can find out the age of a person by subtracting the date of birth from the current date. Excel recognizes date and time only when they are specified in the right formats.
| Valid date formats | Valid time format |
|---|---|
| 6/10/06, 6-Oct, Oct-6 | 12:30:20 am |
Creating text, number and date series
You may sometimes find yourself in a situation where you need to key in a series of text, dates, times or numbers. A time series, for example, can include increments of days, weeks or months. It can include repeating sequences such as weekdays, months or quarters. In such cases, specifying the initial time selections and the last value of the series would result in the entire series being generated automatically by Excel. A few examples of time series are given below.
| Initial selection | Extended series |
|---|---|
| 9:00, 10:00 | 11:00, 12:00, 13:00 |
| Mon | Tue, Wed, Thu |
| Jan | Feb, Mar, Apr |
You can also generate linear series and growth series by selecting the initial values for the series and positioning them in the first two cells of the range of cells to be generated. Examples of linear series are given below.
| Initial selection | Extended linear series |
|---|---|
| 1, 2 | 3, 4, 5 |
| 100, 95 | 90, 85 |
| 1, 3 | 5, 7, 9 |
A series can be created by three methods:
1. Auto-fill feature (the Auto-fill handle is the small plus sign at the bottom right corner of the active cell)
2. Menu bar
3. Shortcut menu
Creating a text series. To fill a range of cells with text entries, such as days and months, using the Auto-fill feature, follow the steps:
1. Enter the first value in the cell which would be at the beginning of the series, and select the cell.
2. Drag the Auto-fill handle across the cells that you want to fill.
3. Release the mouse button.
4. Excel fills the range of selected cells with the appropriate text entries.
Use the menu bar to perform the same task by following these steps:
1. Enter the first value and select the range to be filled.
2. Select the Fill option from the Edit menu.
3. Select the Series option from the Fill submenu.
4. Indicate whether you want to fill your series in rows or columns.
5. Specify the type of series you want to create: Linear, Growth, Date or Auto-fill.
6. You can now specify the step and the stop values.
7. You can create series such as: 4:00, 5:00, 6:00, 7:00; Redg100, Redg101, Redg102; Jan, Feb, Mar; Sun, Mon, Tue; North, South, East, West.
The method for entering series of dates and series of numbers is the same as given above. You can enter a series of numbers or a series of dates where increments and decrements are by a specific value. Suppose you want to generate a list of even numbers. You can do it in the following way, using the Auto-fill feature:
1. Enter the number 2 or any date in the first cell and the number 4 or any other date in the second cell.
2. Select both the cells.
3. Drag the Auto-fill handle over the range of cells you want to fill.
4. Release the mouse button.
Excel fills the range of cells with the appropriate entries. You can also use the Series option from the Fill submenu of the Edit menu for generating a series of numbers.
Editing worksheet data
The data that exists in cells may require some editing, such as moving data from one location to another, clearing cell contents and so on. You can edit the contents of the cell by using the formula bar or the in-cell editing option as described below.
Formula bar method:
1. Select the cell you want to edit.
2. Click on the formula bar or press the F2 function key.
In-cell editing. To edit the contents of a cell, the insertion point appears at the end of the cell contents and can be moved to the required position for editing.
Clearing a cell. To clear a cell is to erase the cell content, but it is not the same as deleting a cell. Deleting a cell or cells causes the other cells on the right or bottom to shift positions. Clearing cells, on the other hand, does not cause the other cells to shift. There are different ways of clearing cell contents.
(i) To clear a cell using the shortcut menu:
1. Highlight the cell or range of cells to be cleared.
2. Click on the right mouse button.
3. Select Clear Contents from the shortcut menu.
(ii) To clear the cell contents by using the Delete key, follow the steps:
1. Select the cell and use the Delete key to clear a cell.
2. Excel clears all the data from the cell, but does not change cell formatting.
(iii) To clear the contents of a cell using the menu bar, follow the steps:
1. Select the cell.
2. Select the Clear option from the Edit menu, and then choose one of the following.
| Option | Effect |
|---|---|
| Contents | Clears the cell contents. |
| Comments | Clears the comments in the cell. |
| All | Clears everything from the cell, including formatting and cell notes. |
| Formats | Clears only the cell formatting from the cell. |
Copying data. To create multiple copies of worksheet data, you use the copy and paste feature of Excel. This makes it easier to copy the contents of the cells than typing the data all over again. The task can be accomplished in several ways.
(i) Using the menu bar, you need to:
1. Select the cell or range of cells having the cell contents that are to be copied.
2. Select the Copy option from the Edit menu.
3. Select the cells in which you want to paste a copy of the data.
4. Select the Paste option from the Edit menu or press Ctrl+V.
(ii) You can use the shortcut menu to copy and paste by following the steps:
1. Select the range of data that you want to copy.
2. Click on the right mouse button.
3. Select Copy from the shortcut menu.
4. Select the cells in which you want to paste your data.
5. Click on the right mouse button again and select the Paste option from the shortcut menu.
(iii) To use the drag and drop method to copy and paste data, follow these steps:
1. Select the cells or range of cells that contain the data you want to copy.
2. Position the mouse pointer on the Fill handle.
3. Drag the Fill handle over the adjacent cells.
4. The cell contents would be copied in the adjacent cells.
(iv) The Auto-fill command enables you to copy to adjacent cells. To do so, you can follow these steps:
1. Select the cell or range of cells that contain the data you want to copy.
2. Position the mouse pointer on the Fill handle.
3. Drag the Fill handle over the adjacent cells.
4. The cell contents would be copied in the adjacent cells.
5. Release the mouse button.
Cut and paste. When you select the Cut command to move the data, a copy of the data is stored in the Windows clipboard. Later, when you use the Paste option, the data is placed in another area of the worksheet. The method for performing cut and paste is similar to copy, except that instead of Copy, Cut is selected from the menu.
Inserting and deleting rows and columns
You can insert rows, columns and cells if required. Insertion of rows, columns and cell ranges always causes the data already in the worksheet to shift position to accommodate the inserted object. The method for deleting / inserting rows / columns is similar to deletion / insertion of cells, except that a row or column is selected instead of a cell.
1a) To insert a column using the main menu, the steps are: Position the cell pointer in the column where you want the new column to be inserted. Select the Columns option from the Insert menu. Excel inserts a new column and the existing columns shift to the right.
1b) To insert a column using the shortcut menu, the steps are: Position the cell pointer in the column where you want your new column to be inserted. Click the right mouse button on the column header and select the Insert option from the shortcut menu.
2a) To delete a column using the main menu, the steps are: Click the letter of the column you want to delete. Select the Delete option from the Edit menu.
2b) To delete a column using the shortcut method, the steps are: Select the letter of the column you want to delete. Click on the right mouse button and select the Delete option from the shortcut menu.
3a) To insert a row using the main menu, the steps are: Select a cell in the row below the location where the new row should appear. Select the Rows option from the Insert menu.
3b) To insert a row using the shortcut menu, the steps are: Select a cell in the row below where the new row should appear. Click the right mouse button on the row header and then select the Insert option from the shortcut menu.
4a) To delete a row using the main menu, the steps are: Select the row which you want to delete. Select the Delete option from the Edit menu.
4b) To delete a row using the shortcut menu, the steps are: Select the row which you want to delete. Click the right mouse button and select the Delete option from the shortcut menu.
Changing cell height and width
The data that you enter in the cells is sometimes too long for the column width to accommodate. You can increase the column width and row height to display the entire cell entry.
Changing column width. Column width can be changed by using the mouse or the menu commands. (i) To change the column width using the mouse:
1. Position the mouse pointer on the right border of the heading of the column that has the width to be changed.
2. Press the mouse button and drag it to the right to increase the column width or towards the left to decrease the width.
3. Once the right width has been selected, release the mouse button.
(ii) To change the column width using the menu bar, the steps are:
1. Click on the heading of the column that has the width you want to change.
2. Select the Column option from the Format menu.
3. Select the Width option from the Column submenu.
4. Enter the column width in the Column Width text box.
5. Select the OK option.
Changing row height. Change the row height by using the mouse and the menu bar. (i) To change the row height by using the mouse, the steps are:
1. Position the mouse pointer on the heading of the row (where the row numbers are specified) having the height you want to change.
2. Press the mouse button. A double-headed arrow is displayed.
3. Drag the arrow down or up to increase or decrease the row height.
4. Release the mouse button when the appropriate height is selected.
(ii) To change the row height by using the menu bar, the steps are:
1. Click on the heading of the row whose height you want to change.
2. Select the Row option from the Format menu.
3. Select the Height option from the Row submenu.
4. Enter the row height in the Row Height text box.
5. Select the OK option.
Formulas and Functions
Excel uses formulas for calculations. Formulas can be simple as well as complex in nature. Charts are introduced in worksheets to make analysis tasks easier. Charts are a presentation aid. They not only enhance the worksheet but also allow a user to gather a lot of information in much less time.
Using formulas
Using a formula, expressions can be calculated by typing the formula in the appropriate cell; for example, = B4+C5 is a formula that adds the content of cell B4 to the content of cell C5. The formula must be preceded by an equal to (=) sign. Some examples of formulas are:
= 35 * 44 = 23 ^ 2 = C5 - C3 = C1 + C2 + C3 + C4 + C5 = 53 - D6 * 44/3
Formulas can also contain named cells or cell ranges. The strength of an Excel formula lies in the fact that it can relate the formula to the cells referred to in it, and if the contents of these cells change, a new result is calculated with the aid of the automatic recalculation feature. After the formula is entered in the active cell, press the Enter key. Observe that the cell displays the result, and the formula bar displays the formula or expression.
Functions
Functions are predefined formulas that perform calculations by using specified values called arguments in a particular order, called the syntax; for example, the SUM function adds the values in a range of cells.
To enter a formula that contains a function, follow the steps:
1. Click on the cell in which you want to enter the formula.
2. To type the formula with the help of a function, click on the AutoSum button on the standard toolbar.
3. Click on the down arrow right next to the Functions box to invoke a drop-down list of available functions, which includes SUM, COUNT, AVERAGE, MAX and so on.
4. Click on the function you want to add to the formula. If the function does not appear in the list, click on More Functions.
5. Enter the arguments for the function.
6. When you complete the formula, press the Enter key.
7. The other convenient way of choosing functions is by using the Insert Function button (the fx symbol) that appears on the standard toolbar.
You can also select the Function option from the Insert menu to select an Excel function. Both the actions invoke the Paste Function dialog box. The function category list displays Excel's built-in functions. Select the required function from the list. If you are not sure which function to select, there is a Help button in the Office Assistant to guide you.
Charts
Growth rate analysis or monthly sales reports, which would be a very tedious job, can be made quite interesting and time saving if depicted through charts. To create a chart, you must select a range of cells containing both labels and numeric values. Then you can use the Chart Wizard button on the standard toolbar. Charts are created as chart sheets in a workbook by default or can be embedded in a worksheet. You can create a chart using the Chart Wizard by following the steps listed here:
1. Select a range with numeric data and labels.
2. Click on the Chart Wizard tool on the standard toolbar.
3. When the mouse button is released, the Chart Wizard dialog box gets invoked. The Chart Wizard then guides you through different steps of creating a chart of your own choice.
4. Click on the Finish button to complete the process of creating the chart. A chart using the default format is drawn.
5. You can select the Next option to go to the next step, which would show the Step 2 of 4 dialog box, and in this manner you can move to steps 3 and 4 to make your charts more detailed and according to your convenience.
6. The Step 2 of 4 dialog box lets you specify the range of data that you want to include in the chart.
7. The Data Range tab displays the range recognized by the chart. If you need to change it, type in the new range.
8. The Series tab allows you to add and remove a data series. You can also specify the x-axis labels.
9. The Step 3 of 4 dialog box of the Chart Wizard has a number of tabs. Each one has a specific purpose.
| Tab | Purpose |
|---|---|
| Titles | Adds / removes titles to charts. |
| Axes | Toggles the axis values on and off. |
| Gridlines | Displays gridlines parallel to the x and y axes. |
| Legend | Toggles the legend on and off, and places it on the chart. |
| Data Labels | Adds or removes labels and values to the series. |
| Data Table | Links or removes the source data from the chart. |
The Chart Wizard also helps you to specify the location of the chart, either as an embedded chart on a worksheet or as a chart sheet. Select the option As object in and click on Finish. Your final chart would be placed on your worksheet.
Summary
- A spreadsheet is software that simulates a paper worksheet.
- MS Excel is a Windows based spreadsheet package. Movement in a worksheet is possible by using the keyboard, mouse or the scroll bars.
- Data entry can be of text, numbers, date and time. Series of text, numbers, dates and times can be conveniently created.
- Saving a workbook saves all the worksheets contained in it.
- A worksheet can also be saved in different formats. Modification in a worksheet is possible by editing a cell or a cell range; copying and moving data from one place to another in a worksheet can also be done.
- Worksheets can be inserted and renamed, and deletion of these worksheets is also permitted. Column width can be changed by using the Format, Column and Width commands.
- Row height can be altered by using the Format, Row and Height option. Charts can be embedded in your worksheets by using the Chart Wizard feature of Excel.
Free study material for Computer Science
Free CBSE Study Guides: Computer Science MS Office
Comprehensive Study Resources for MS Office
Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.
Understanding Marking Schemes
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.
Complete Revision for Computer Science
Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.
FAQs
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.
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.
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.
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.
All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.
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.