Features Of Microsoft Excel ( The Spreadsheet Interface )

By

 

 


INTRODUCTION TO SPREAD-SHEET APPLICATION

In this lesson, we will emphasize on the features of the spreadsheet interface.


A spreadsheet is a software for computation, organization, analysis and storage of data in tabular form.

A cell is a point where a column and a row meets. It is the fundamental unit in a worksheet. Data such as text, numeric values or formulas are mentioned in the cells of the worksheet. 

FEATURES OF SPREADSHEET INTERFACE

Title bar: The title bar is a horizontal bar displayed on top of the excel window. The title bar shows the name of the work book you are using. In recent applications, the Quick access is also found on the title bar.

Tool bars: The toolbars consist of the standard toolbar and formatting toolbar. The standard toolbar is found just below the menu bar. Below the standard bar is the formatting toolbar. The toolbars contain buttons and list of boxes that allow you to perform frequent tasks quickly than when using the menu bar.

Recent Excel applications have combined the toolbars to the ribbon tools.

Rows and columns: Through a spreadsheet’s grid system of row and columns, all of your information is neatly organized in one easy-to-read space.

Formatting: The cells which one selects can be formatted to represent different numeric values in spreadsheet. Example, it is beneficial for financial data and accounting purposes. It will place decimals and commas to indicate dollars and cents.

Formulas and functions: A spreadsheet allows you to design unique formulas to give you insight into your data.

 functions evaluate values, while formulas are used to express the relationship of two or more cells in  spreadsheet, using an equal sign.

The most commonly used formulas include basic arithmetic, such as addition, subtraction and multiplication.

Frequently used functions include sum, average, count, and the minimum and maximum functions. There are more advanced functions that help you manipulate variables. Etc.

Name box: It is an area in Excel window which displays the content of an active cell.

Contact us for more

Comments

Post a Comment

Popular post

Introduction To Ms.Word Application ( File Management )

By
Image
File Management 1. Creating and saving a document 2. Printing a document 3. Closing a document Creating and saving a document. Every word processor provides the facility for creating and working documents.  After developing a document and working with it, you may want to save it for future references.  Saving means, keeping a permanent copy of a document on storage media. Printing a document A document develop using the computer is an electronic one or a soft copy.  In order to have a hard copy or a paper copy, you will have to print it using a printer. Closing a document After creating, Printing, or saving a document, there is a facility for closing the word processor without damaging either the word processor or your own document. All the facilities described above are usually grouped under menu item referred to as a file.  A file is therefore a collection of related data. Editing of documen
Read more

QUESTIONS & ANSWERS

By
Image
CHOOSE THE CORRECT ANSWERS   1.         Which of the following keys check spelling and grammar of text in a document? A.         F7                    B.      Shift + F7 2.         An example of output device is the A.         Scanner           B.     headset 3.         NIC stands for A.         Network Internet Card          B.          Network Interface Card 4.         A ___________ is a rectangular box on the desktop that displays features different of that of the desktop. A.         title bar          B.     window 5.         The horizontal bar that normally lies at the bottom of a computer desktop screen is called A.       taskbar          B.    start button 6.         A folder within another folder is called A.     parent folder    B.    sub-folder 7.         Processed material which is meaningful to the user in computing is called A.        data           B.     information 8.         The copyright laws protect the works of an author for a
Read more

Features Of A Window

By
Image
  A window is rectangular area in which you view programs, files, folders and drives on a graphical user interface. It is a rectangular box on the desktop that displays features different from that of the desktop. Windows Management is the process by which computer users control the placement and appearance of Windows using the graphical user interface. Windows Explorer The windows Explorer is used to view the contents of the computer in the hierarchy of files and folders. Features Of Windows Explorer 1. Title bar     2. Tabs     3. Control box 4. Toolbar      5. Minimize  6. Maximize 7. Close button  8.  Navigation Pane 9. Windows border    10. Status bar Title bar displays the name of the window and contains the control box, minimize, maximize, restore and the close button. Tabs contain menus with related commands and options that help you control the window and it's contents. Control box contains the resizing buttons ( minimize, maximize, restore and close button ) It is use
Read more