BUS 150 Study Guide - Midterm Guide: Move, Compound Document, Sparkline

• School: University of Miami
• Department: Business
• Course: BUS 150
• Professor: Maryann Barber

Document Summary

Formaing is atached to the cell not the formula bar. Page layout view (see printed page, not as good as print preview) 4 types of series o o o o. Delete- right click>delete (have to move other things to take its place) Erase- delete key (clear all, clear format, clear content) Click on the irst cell on the new page (horizontal) Print itles- rows and/or columns that will repeat on every page *** Headlines- yes when display values, no when print cell formulas. Shrunk names (don"t care, only care about formulas) Don"t care about how many page, need to read the formulas. When copying formulas, relaive cell addresses adjust to relaive posiions. Use $ (f4) so that when the assumpion are is changed, it won"t afect the formula. Criical for reading how the spreadsheet was built. Can plug new numbers in without ediing/copying formulas (error proof) Only format if a certain rule is made.