create advanced filters manage conditional formatting rules Prepare a workbook for 0 1 2 3 internationalization and accessibility Totally got this I’ll figure it out Needs review No clue Modify tab order among workbook elements and objects display data in multiple international formats modify worksheets for use with accessibility tools utilize international symbols manage multiple options for +Body and +Heading fonts Total score ______ x 4 = __________ minutes needed to review Preparation resources Create advanced formulas Look up data with functions 0 1 2 3 Totally got this I’ll figure it out Needs review No clue Utilize the LOOKUP function utilize the VLOOKUP function utilize the HLOOKUP function utilize the TRANSPOSE function Apply advanced date and time 0 1 2 3 functions Totally got this I’ll figure it out Needs review No clue Utilize the NOW and TODAY functions use functions to serialize dates and times Total score ______ x 4 = __________ minutes needed to review Preparation resources Create advanced charts and tables Create advanced chart elements 0 1 2 3 Totally got this I’ll figure it out Needs review No clue Add trendlines to charts create dual axis charts create custom chart templates view chart animations
create advanced filters manage conditional formatting rules Prepare a workbook for internationalization and accessibility 0 Totally got this 1 I’ll figure it out 2 Needs review 3 No clue Modify tab order among workbook elements and objects display data in multiple international formats modify worksheets for use with accessibility tools utilize international symbols manage multiple options for +Body and +Heading fonts Total score ______ x 4 = __________ minutes needed to review Preparation resources Create advanced formulas Look up data with functions 0 Totally got this 1 I’ll figure it out 2 Needs review 3 No clue Utilize the LOOKUP function utilize the VLOOKUP function utilize the HLOOKUP function utilize the TRANSPOSE function Apply advanced date and time functions 0 Totally got this 1 I’ll figure it out 2 Needs review 3 No clue Utilize the NOW and TODAY functions use functions to serialize dates and times Total score ______ x 4 = __________ minutes needed to review Preparation resources Create advanced charts and tables Create advanced chart elements 0 Totally got this 1 I’ll figure it out 2 Needs review 3 No clue Add trendlines to charts create dual axis charts create custom chart templates view chart animations
Excel2013expert1.docx