Ch2: Working in Microsoft Excel Flashcards
What is a worksheet? Write steps to insert a new worksheet in a workbook-
• A spreadsheet is called a worksheet in Excel. A worksheet is made of cells organised in rows and columns.
• To insert a worksheet, follow these steps:
1. From the sheet tab, right-click on the worksheet before which you want to insert a new worksheet. A pop-up menu appears.
2. Click on the insert option. The Insert dialog box appears.
3. Select the worksheet option in the general tab.
4. Click on OK.
5. A new worksheet gets inserted before the selected sheet name.
Write the steps to delete a worksheet-
• These are the steps to delete a worksheet:
1. From the sheet tab, right-click on the worksheet which you want to delete. A popup menu appears.
2. Click on the delete option.
3. The selected sheet gets deleted.
What is a range? Write the steps to name a range in Excel-
• A selected rectangular block of two or more cells is called a range. A range is represented by the cell addresses of the first cell and its diagonally opposite cell.
• The steps to name a range are:
1. Select the range of cells you want to name.
2. Right-click on the selected range. A pop-up menu appears.
3. Click on the Define Name option. The New Name dialog box appears.
4. Type the name in the Name textbox.
5. Click on OK. The selected range gets a name.
What is a formula? Explain with the help of an example-
• You can use Excel to perform mathematical calculations such as addition, subtraction, multiplication, average, and percentage. For this, you need to use equations called formulas.
• A formula starts with an equals sign (=). It can contain numbers, cell addresses, numbers and operators.
[Placeholder for example]
What is cell referencing? Explain its different types-
• A cell address used in a formula is called a cell reference. A cell range in a formula is also called a cell reference.
• Three types of cell referencing are:
1. A relative cell reference is a reference to a cell relative to the position of a formula. A formula with a relative cell reference changes as you copy it from one cell to another. Eg: A2, G6
2. An absolute cell reference is a cell reference that always refers to a particular cell. It does not change when the formula is copied. To create an absolute cell reference, you use a dollar sign ($) before the column heading and before the row heading. Eg: $A$2, $G$6
3. A mixed cell reference is a combination of relative and absolute column and row references. To create a mixed reference You type the dollar sign either before the column or before the row heading. Eg: $A2 $G6
What is an error? List some errors in excel-
• An error in Excel means that there is something wrong with the way your formula has been typed or there is something wrong with the cells you are referencing.
Some errors in Excel are:
1. #DIV/0! Division by zero is not possible
2. #### Column is not wide enough for the value.
3. #VALUE! Excel does not recognise the value.
4. #REF! Invalid cell reference in th formula.
A _______ is a collection of worksheets
Workbook
A worksheet contains cells organised in the form of rows and _______
Columns
A cell with a dark border around it indicates that it is an _______
Active cell
_______ means to replace the old name with a new one.
Rename
A new _______ gets inserted before the selected sheet name.
Sheet
You can rename a worksheet by double-clicking on it in the _______ tab.
Sheet
You can _______ a new worksheet by clicking on the insert worksheet tab.
Insert
Clicking on the _______ option helps to delete a selected worksheet
Delete