Question

Explain any four component of a worksheet ​

Answer 1

Answer:

After you open an excel sheet, you will get different templates, choose the one you prefer and then there will be basic components; an Active cell, Column headings, a Formula bar, a Name box, the mouse pointer, Row headings, Sheet tabs, a Task Pane, Tab scrolling buttons and Toolbars.

Answer 2

Explanation:

spreadsheet - a table in which you can enter and manipulate data

cell - a table entry. A cell can contain:

labels e.g. Company

numbers e.g. 32.4

functions e.g. SUM(B5:B8)

formulas e.g. = 2 * 2 

OR e.g. = 2 * SUM(B5:B8)

row - cells aligned horizontally. Rows are numbered 1,2,3,...

column - cells aligned vertically. Columns are labeled A,B,C,...

range - the specification for a series of cells.

A colon ":" separates the start and end cell references.

e.g. A1:A9 - part of a column

e.g. A1:K1 - part of a row

e.g. B4:D8 - a rectangle of cells

Also, you can assign a RangeName to a group of cells. This makes it much easier to reference cell(s); you can refer to them by the kind of value contained. e.g. Instead of referencing cell P32 you could reference the cell with the name Interest(or whatever you had named that cell). 

More on naming ranges a bit later.