BTM 200 Study Guide - Midterm Guide: Reticle

141 views2 pages

Document Summary

If your workbook is shared, you can merge the different versions together. Click the compare and merge workbooks button on the quick access toolbar. You can fill adjacent cells without having to retype the formula using the fill handle (crosshair mouse pointer) E. g. copying a formula from b17 to c17 & d17. Click cell b17 then position mouse over lower-right corner. Select range of data you want to chart, including labels. Structured reference: reference to a table or table column by name instead of cell address. Type structured reference where you would normally type the cell address. Form: simplified interface for data entry that can be customized. Click new button & enter data in the fields. Click the new button to start a new record. Click the close button to close the worksheet. Link an excel chart to a powerpoint slide. When you link the chart, it will update automatically based on changes in excel.