Ch2: Working in Microsoft Excel Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What is a worksheet? Write steps to insert a new worksheet in a workbook-

A

• 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Write the steps to delete a worksheet-

A

• 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a range? Write the steps to name a range in Excel-

A

• 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a formula? Explain with the help of an example-

A

• 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]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is cell referencing? Explain its different types-

A

• 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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is an error? List some errors in excel-

A

• 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A _______ is a collection of worksheets

A

Workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A worksheet contains cells organised in the form of rows and _______

A

Columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A cell with a dark border around it indicates that it is an _______

A

Active cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

_______ means to replace the old name with a new one.

A

Rename

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A new _______ gets inserted before the selected sheet name.

A

Sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You can rename a worksheet by double-clicking on it in the _______ tab.

A

Sheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You can _______ a new worksheet by clicking on the insert worksheet tab.

A

Insert

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Clicking on the _______ option helps to delete a selected worksheet

A

Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly