Question

1.
Answer the following questions:
What is a workbook?
2. What is a worksheet?
3. What is cell reference?​

Answer 1

Answer:

1. A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template.

2. A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

3. A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. Data contained in different areas of a worksheet.

Answer 2

• A range of cells is a rectangular block consisting of a few cells, an entire row, an entire column or the whole worksheet.

• The cell address that we use in the formula is known as the cell reference. The address of the cell consists of the column letter followed by the row number. For example, cell address A1 denotes the column name as A and the row number as 1.

Explanation:

work book

• A workbook is the name given to an Excel document and has the file extension (". xlsx"). A workbook contains one or more worksheets and there are 3 worksheets in the default workbook. There are tabs at the bottom of the workbook to enable you to select worksheet