Question

1. The horizontal division in excel is called as _______

2. ________ displays the location of the cell pointer.

3. By default how many worksheets are provided in ms-excel ________

4. Name the two buttons present in the formulae bar
1.___________
2.___________

5. In the spreadsheet column headers are denoted by ___________ and row headers are denoted by _________

6. In MS-excel the formulae always starts with _______ sign and give one example of formulae _________

7. How many characters can be entered in a single cell __________​

Answer 1

Answer:

Ans 1) Alternatively referred to as a column separator or row separator, Grid lines or gridlines are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet.

Ans 2) Ctrl displays the location of the cell pointer

Ans 3) three sheets

Naming worksheets

When you open an Excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.

Ans 4) The left most is called as "Cell Name Box", middle one is "Formula Bar Buttons" and right one is the contents of the Active Cell. Data or formula entered in the Active Cell will appear in right-most section.

Ans 5) Row header or Row heading is the gray-colored column located on the left side of column 1 in the worksheet which contains the numbers (1, 2, 3, etc.) where it helps out to identify each row in the worksheet. Whereas column header is the gray-colored row, usually it will be letters (A, B, C, etc.)

Ans 6) All Excel formulas begin with an equal sign (=). After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.17-Dec-2015