Question

5. Answer the following questions.

a) What is a worksheet?

b) What is Auto fill? How is it useful?

c) How many worksheets are there by default in a workbook in Excel 2013?

d) Which are the two ways in which you can create a workbook?

e) What is a Cell Pointer?

f) In how many ways can you edit data in a cell?

g) How can you select a complete row?
​

Answer 1

Answer:

(a) The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.

(b) Autofill is a software function that automatically enters data in web forms and spreadsheets.

(c) a wordbook contains three worksheets.

(d). 1 is this ** Open Excel.

**Select Blank workbook or press Ctrl+N.

**Start typing.

(E).The cell pointer in Excel is the active cell or the selected cell and is highlighted by a bolder rectangle.

(f) There are two ways to edit the contents of a cell: Double-click the cell which contents you want to edit and the cursor will be placed in the very same spot you clicked.

(g) Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.