Electronic Spreadsheet (Advanced) Class – X

Part – 3

Short Notes

  • Setting up Multiple Sheets

When you open a new spreadsheet, by default, it has a sheet named Sheet1 which is managed using tabs at the bottom of the spreadsheet.

  • Inserting New Sheets

There are several ways to insert a new sheet.

  1. The first step, in all cases, is to select the sheet that will be next to the new sheet. 
  2. Then do any of the following: 
  3. Select Insert > Sheet from the menu bar, or
  4. Right-click on the tab and select Insert Sheet, or click in an empty space at the end of the line of sheet tabs.
  • Renaming Worksheets

The steps involved in renaming a worksheet are as follows :

  1. Double-click on one of the existing worksheet names. 
  2. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu. 
  3. Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option. 
  • Creating The Reference With The Mouse

The steps involved to create the reference with the mouse are as follows :

  1. Click the = icon next to the formula bar.
  2. Switch to the other spreadsheet (the process to do this will vary depending on which operating system you are using
  3. Select the sheet (Savings account) and then the reference cell
  4. Switch back to the original spreadsheet
  5. Click on the green checkmark on the formula bar.
  • Creating The Reference With The Keyboard

The reference has three parts to it:

  1. Path and filename
  2. Sheet name
  3. Cell 

 

Video Tutorial

Questions and Answers

Q 1. How can we rename a worksheet? 

Ans.   Double-click on one of the existing worksheet names.

  • Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.
  • Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.

Q 2. What is a cell reference?

Ans.  A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want the formula to calculate.

 

Q 3. What are the two ways of referencing cells in other worksheets?

Ans. There are two ways :

  • Creating The Reference With The Mouse
  • Creating The Reference With The Keyboard

Q 4. Differentiate between relative and absolute hyperlinks

Ans. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other.

Q 5. What is a chart?  What are the advantages of charts?

Ans.  A chart is a graphical representation of data in a worksheet.  It helps to provide a better understanding of large quantities of data.  Charts make it easier to draw a comparison and see growth, relationship among the values and trends in data.  They provide an accurate analysis of information.

Q 6. What are the two axes of a chart?

Ans.  Category Axis:  It is the horizontal axis of a chart and also called as X axis.

          Value Axis :  It is the vertical axis used to plot the values and also called Y axis.

Q 7. State any four types of charts.

Ans.  The four types of charts are

  • Column chart:  Depicts data as vertical bars.
  • Line Chart: Depicts data as a series of lines.
  • Pie Chart: Categorizes only one data series as a series of slices, each contributing to a whole
  • Bar chart:  Depicts a column chart whose data series are presented horizontally instead of vertically.

Q 8. How to create a chart?  Write steps.

Ans.  To create a chart in Excel  follow the given steps :

  1.  Select a range of cells which is to be displayed in a chart.
  2. Choose the Insert tab and then in the charts group, click the required chart.
  3. Click the desired chart subtype.

Q 9. What is linking?

Ans.  Consolidating data from other workbook is referred to as linking.  A link is a reference to a cell or a range of cells in another workbook.

Q 10. How many sheets are there in a spreadsheet by default?

Ans.  There are 3 sheets by default named as Sheet1, Sheet2, Sheet3 and so on.

error: Content is protected !!
Back to Top