Web Stories - Articles - Questions - Post - Experiences
menu search
brightness_auto
Add Knowledge - Updates - Promotion
more_vert

The components of the worksheet are :

1. CELL - Each cell is denoted with a cell address. For example, A5 refers to the cell at the intersection of column A and row 5. Data is stored in a cell. A cell can contain up to 32,767 characters.

2. ACTIVE CELL - When you click on a cell, a thick black border differentiates it from the rest of the cells. It indicates the current cell is active. The highlighted box is called Cell Pointer. Data can be entered only in a cell where the pointer is placed.

3. NAME BOX - Name Box is located above the Column heading on the left side of the window. This area displays the location of the cell pointer. 

4. FORMULA BAR - The Formula Bar is located to the right of the Name Box. This bar shows the characters and formulas that you enter in an active cell.

5. COLUMN HEADINGS - Alphabets across the top border of each worksheet are called column headings. These headings identify columns with letters A to Z, AA through AZ and XFD for a total of 16,384 columns.

6. ROW HEADINGS - Row headings are the numbers marked as 1 through 1,048,576 along the left border of the worksheet.

7. STATUS BAR - The Status Bar is located at the bottom of the Excel window. It gives us information about the current selection. It also displays warning messages.

thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike

Related questions

What is Operating System ? All fundamental functions, such as controlling files, processes, and memory, are handled by an operating system. As a resu...
thumb_up_off_alt 4 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
You may know there are shortcut keys that you can use to do your work easily. Let us discuss the Ctrl Shortcuts : 1. Ctrl + A : Select all 2. Ctr...
Which are the Ctrl shortcut keys of Computer ?
thumb_up_off_alt 2 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
Keyboard is an input device. Keyboard is divided into four parts: 1. Function Key Part:- This part contains 12 function keys from F1 to F12.  2....
What is the purpose of function keys available on keyboard ?
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
VDT - Virtual Display Terminal DMP - Dot Matrix Printer UNIVAC - Universal Automatic Computer EDSAC - Electronic delay storage Automatic Computer...
thumb_up_off_alt 4 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
Ads by Zaankari™ Portal
Describe data : Data is a collection of unprocessed, raw facts and information, such as text, observations, numbers, symbols, and object descriptions...
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
Once, I went for an interview and they asked me which I'd do you have, email or Gmail. I instantly replied, I have Gmail account and not the email. Th...
thumb_up_off_alt 5 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
1 answer
Read Story...
share
What is Surveillance HDD ? Surveillance drives are designed for 24/7 security systems to record video. Usually, they employ a device known as a net...
Why you should not use Surveillance hard disk in computers ? What is difference between normal hdd and surveillance hdd?
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
Ads by Zaankari™ Portal
Do you know about D2H ? It is known as Direct To Home Services. Now, India is working on the new technology called as D2M, which is the Direct To Mobi...
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
0 answers
Read Story...
share
thumb_up_off_alt 3 like thumb_down_off_alt 0 dislike
1 answer
Read Story...
share

Most popular questions within the last 4 days

Welcome to Zaankari portal, where you can ask and read questions/answers and stories. Add Questions/Stories/Posts - Earn Points !
...