Select File/Save As to copy the workbook to a different folder or to make a copy with a different name. When finished with the workbook, select File/Close. The first time a workbook is saved, it can be renamed by typing over the default name. To open an Excel workbook, select File/Open and the name of the workbook. If more than one workbook is created in the same Excel session, Excel names them Book1, Book2 (or SalesExpense1, SalesExpense2) and so on.įollowing are the essential file management functions in Excel. They can be renamed or deleted, and new worksheets can be added by right clicking the tab and selecting from the menu. Worksheets are selected by clicking the tabs at the bottom of the window. All documents are easily renamed when saved. New "blank documents" are named Book1 or Workbook1, while documents using pre-formatted templates generally use the template name, such as ExpenseReport1 and SalesBudget1. If "blank document" is selected, a matrix of empty rows and columns is created. When Excel is launched, a pre-formatted template can be selected for various purposes such as budgets, calendars and receipts. When you create a new blank document, it starts out with three blank worksheets, and more can be added (see XL Adding worksheets). Functions are predefined formulas such as SUM, which adds numbers in a row or column.Ī document created in Excel is called a "workbook," and workbooks can include any number of pages, called "worksheets." Each worksheet is like having another document but enables related data to be kept in one file. FORMULAS - An algorithm that states how data in the cells will be calculated. Spreadsheets display a matrix or rows and columns, the intersections of which are called "cells." The three primary things a cell can contain are:ģ. Microsoft powerpoint for mac version 15.23 how to#For example, to review later how to delete rows or columns, look up XL Delete row/column. The topics covered in XL abc's are replicated under their own names with an XL prefix. Microsoft powerpoint for mac version 15.23 windows#The examples apply to all versions of Excel, whether Windows or Mac, as well as to non-Microsoft spreadsheets. XL abc'sThis tutorial is for newcomers to spreadsheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |