BMGT 301 Study Guide - Midterm Guide: Pivot Table, Net Present Value, Lincoln Near-Earth Asteroid Research

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 301
• Professor: Karake

Document Summary

Right click the sheet tab, then point to the tab color on the shortcut menu. In the cells group, click the format arrow, in the organize sheets section, point to tab color and in tab color click desired color. Ctrl-click the rev sheet tab and then tab color. In standard color click dark blue option then close. To format worksheet tab, right click the revenues sheet tab and on the shortcut menu point to tab color. On tab color palette in the standard colors section click dark blue. Double click sheet tab and type new worksheet name. Select cell f16 and type 1590 then press right arrow key to enter the number in the cell. Click cell b17 point to the lower right corner of cell b17 until the pointer charges to a black crosshair pointer. Press and hold the mouse button and drag the fill handle to the right over cell d17 and then release mouse button.