Toolbars consist of icons that act as shortcuts to the commands. Toolbars are generally located just below the menu bar. Menu is a collection of useful commands displayed on the top of screen. Spreadsheet displays the name of the current workbook on it. Title bar is located at the very top of the screen. Row headings represent the names of the rows.Īctive cell is the in which data is entered or edited at a given time. The text the appears on the left of row is called row headings. Column headings represent the names of the columns. The text that appears at the top of column is called column headings. This is known as the cell’s address or cell coordinates. The fifth cell in second column is known as cell B5. Cells may contain text, numbers graphical patterns or formulas.Ĭells are identified by the combination of column letter and row number. The intersection of row and column is called cell. By default a workbook contains 3 worksheets. Workbook is a group of worksheets saved together as one file.
Spreadsheet consists of columns and rows to enter data.
Also explain 3-D sheet.įollowing is brief description of different elements of a spreadsheet interface: Explain the general interface of spreadsheet software. Printing can be of whole document or of any required range. You can print your documents to get a hard copy. Some simple text manipulation can also be performed. Lengthy calculations can be applied on worksheet easily by using functions.Ĭommands are used to manipulate the worksheet or its contents functions can perform different types of calculations. Spreadsheet has many built-in function s. It displays the resulting value in the cell containing the formula. The formula performs calculations on the data in spreadsheet. Values can be number, date, formula or formula result. A label is text entry such as “Gross salary”. This is known as the cell address or cell coordinates. For example, fifth cell in the second column is known as cell B5.
0 kommentar(er)
