vancouverbas.blogg.se

Simple openoffice spread sheet functions
Simple openoffice spread sheet functions











Callouts which appear when the mouse pointer is positioned over the cell are called” comments” in Excel but are referred to as “notes” in Calc. One tabbed sheet in an Excel workbook is a “worksheet “. One tabbed sheet in a Calc spreadsheet is a “sheet”. The entire file is called a “workbook” in Excel, but is referred to as a “spreadsheet ” in Calc. There are, however, some important differences. The page formats for printing are similar and both programs offer themes for formatting whole sheets. Charts, diagrams, graphics, and text art can be inserted into both. This includes basic arithmetic and simple statistics such as averages, medians, and means. Excel has the advantage of having advanced filters, which allows cells to be arranged according to its format, color, or by some other criteria.Īlmost 80% of the functions are identical. Rows and columns can be shown, hidden or grouped in both. The list-making, sorting and filtering capabilities are comparable. For starters, the user interface, which includes the icons, menus and toolbars are very much alike in appearance and purpose (except for MS Excel 2007).













Simple openoffice spread sheet functions