explain the following terms:
formula bar:
The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function, or data in a cell. eg: The active cell displayed the answer to the formula. The actual formula for the active cell was displayed in the formula bar.
worksheet:
A worksheet is a single page or sheet in an Excel spreadsheet. By default, there are three worksheets per file. Switching between worksheets is done by clicking on the sheet tab at the bottom of the screen. eg: To create a chart in Excel, first enter th data into a worksheet.
workbook:
A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheets.
The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.
row:
Rows run horizontally in an Excel worksheet. They are identified by a number in the row header. There are 65,536 rows in each Excel worksheet. The intersection point between a row and a column is a cell, which is the basic storage unit for data in a spreadsheet.
column:
Columns are a fundamental part of any spreadsheets program such as Excel. Columns run vertically in a spreadsheet and help to identify the location of data. Each column is identified by a letter in the column header. There are 256 columns in an Excel worksheets.
cell:
In any spreadsheet program such as Excel, each rectangular box is referred to as a cell. A cell is the intersection point of a column and a row. Data entered into an Excel spreadsheet is entered into a cell. Each cell can hold only one piece of data at a time.
range:
A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by a black outline or border.
arithmatic calculations:
eg: 1+1 = 2
eg2: b6+b5= 3
logical calculations:
eg: =if(b6<b5) “loss”,”profit”
formatting:
A plan for the organization and arrangement of a specified production.
