Examlex
The MATCH and INDEX functions can be used to overcome the data range limitations of the VLOOKUP and HLOOKUP functions.
Q9: An enhanced pie chart is a chart
Q18: Using a(n)_ pie chart,you can emphasize a
Q29: A table style is a predefined set
Q44: The _ function returns the value of
Q51: To enter unique data,formulas and information in
Q53: A(n)_ calculated field is created when you
Q68: To remove any nonprinting characters from a
Q86: Tiles provide a dynamic navigation strip allowing
Q89: You can import tables and queries from
Q99: The PivotTable _ tab focuses on formatting