BUS 150 Lecture Notes - Lecture 7: Lookup Table
2 Nov 2016
School
Department
Course
Professor
Document Summary
Excel will use whatever is entered in top row of each column for the defined name of the selected area below it. Blank space will become an underscore. If formulas are created before the defined names are created, you will have to go back and (cid:498)apply names(cid:499) because they will not automatically update to use. Can delete, add, edit existing names in the (cid:498)name manager(cid:499: won"t update if you delete/edit/add name; you must paste the names. Formula tab use in formula paste names = gives you a list of all the. Excel creates some defined names, and sometimes they might just pop up on over again in order to have them updated defined names in the spreadsheet their own. Database functions: dsum, daverage, dmax, dmin, dcount (counts numbers, dcounta (counts numbers and text, use these when looking for complex criteria that would need multiple.
