Question

D. Answer these questions.

1.What is a worksheet? Write the steps to insert a new worksheet in a workbook.

2. Write the steps to delete a worksheet.

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

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

5. What is cell referencing? Explain its different types.

6. What is an error? List some errors in Excel.​

Answer 1

Answer:

1. A Worksheet is a collection of cells organized in rows and columns. ... Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information. Typically, a workbook contains several worksheets with related content and only one of the worksheets is active at a time.

To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet. Tip: You can also right-click the tab of an existing worksheet, and then click Insert.

5.There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.