MISY Final Excel Access questions & answers graded A+

MISY Final Excel AccessWhat is primary key? - correct answer field or set of fields with values that are unique throughout a table What data type is the most appropriate for the field? - correct answer Each record is unique (auto number?, short text) How do you connect tables? - correct answer Find a common field Structure of IIf function - correct answer =IIf([AirportCode]="ORD","Chicago",IIf([AirportCode]="ATL","Atlanta",IIf([AirportCode]="SEA","Seattle","Other"))) Structure of ISNull function - correct answer Isnull(expression), usually with IIF(Isnull([Descitpion]), "YES", "NO") Structure of DatePart function - correct answer Datepart(interval, date, [firstdayofweek], [firstweekofyear]) sumif, averageif, sumifs, averageifs functions - correct answer SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) Using absolute addresses ($), relative addresses - correct answer "$" Locks Cell item Order of precedence - correct answer () first , * and / second , + and - third What is the benefit of a pivot table? - correct answer Helps analyze a lot of data What is the benefit of a macro? - correct answer don't have to redo commands What is the benefit of a slicer? - correct answer allows you to easily filter reorts, tables, etc Access: Field Value is equal to - correct answer "Korea", =50 Access: Field Value is greater than - correct answer >50 Access: Field Value is Less Than - correct answer <50 Access: Field Value it NOT - correct answer Not "Value" Structure of vlookup - correct answer vlookup(what you are looking for, table range, True or False) *False means exact match Access: Starts with U - correct answer Like "U*"