Saturday, January 4, 2025

Electronic Spreadsheets Windows & its Terminology | Excel Concept!

  1) Workbook - A workbook is like a book and consists worksheets.

2) Worksheet - A worksheet is working area consists rows and columns. 

By default three worksheet in a workbook.

3) Rows - Rows are the set of rectangular boxes. There are 10,48,576 rows.

4) Columns - Columns are the vertical set of rectangular boxes. There are 1024 columns.

5) Cell - Cell is the intersection of rows and columns.

6) Title Bar - It lies below the top of window screen.

7) Menu Bar - It lies below the title bar.

8) Standard Toolbar - It lies below the Menu Bar.

9) Formatting Toolbar - It lies below to the standard toolbar.

10) Formula Bar - It lies below the formatting toolbar.

11) Cell Pointer -

12) Cell Address - 

13) Name Box -

14) Status Bar -

15) Sheet Tab -

16) Horizontal scroll Bar -

17) Vertical Scroll Bar - 

18) Numeric Data -

19) Text Data -

20) Date and Time -

21) Formula - Formula is a feature of spreadsheet which allowed to do the calculation.

There are three types of formula:-

1) Formula with cell address.

2) Formula with cell name.

3) Formula with in-built function.

No comments:

Post a Comment