EXCEL BASICS
The spreadsheet contains text and numbers that have been entered by the user. We refer to these values as raw data. The spreadsheet also contains derived data. These are values that are calculated from the raw data with a paper spreadsheet is complicated, time consuming, and limited. If a portion of your raw data changes, you must erase and re-enter it. Then you have to erase and recalculate derived data, such as totals or averages that were affected by your changes.
For instance, if you change the amount of the January Telephone value from N48.35 to N58.35, then you must recalculate the Quarter Total, the Monthly Total, and the Balance.
Notice that when we change the January Telephone value, Excel automatically recalculated the totals and balance.
The intersection of a column and a row is called a cell. A cell’s name is composed of its column letter followed by its row number, such as c5, as shown.
In Excel, spreadsheets are called worksheets. Excel provides you with electronic worksheets that you can use to manage numbers and calculations.
Notice that the columns are labeled with letters and the rows are labeled with numbers.
when you are viewing the Excel window. The main area, called the work area, contains an empty spreadsheet organized in columns and rows.
The components of the Excel application window are the title bar, the menu bar, the toolbars, the formula bar, and the status bar.
The Title bar displays the name of the open application and document. At the left end of the title bar, the control-menu icon enables you to control the size and position of the Excel application window. The three buttons at the right end of the title bar enable you to minimize, maximize, and close the application window.
Toolbar buttons provide shortcuts for accomplishing many Excel tasks. By pointing to a button with the mouse pointer, you can display a pop-up text box, called a screen Tip, containing the button’s name. to use a button, simply click on it.
The status bar, located at the bottom of the Excel window, displays information about the current selection. When you first open a worksheet, the status bar displays “Ready” to indicate that the program is in Ready mode.
Social Plugin