Multiple Choice
Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this.
-Next you tell Jane that she can accomplish the task by clicking the _____.
A) Recreate as Table button (DATA tab | Table group)
B) Convert to Table button (HOME tab | Styles group)
C) Format as Table button (HOME tab | Styles group)
D) Apply Table Formatting button (LAYOUT tab | Styles group)
Correct Answer:

Verified
Correct Answer:
Verified
Q91: Why is the VLOOKUP function used more
Q92: In a table,or database,the data related to
Q93: Dan is manipulating data in a table
Q94: _ cause(s)adjacent rows to have different formatting.
Q95: The comparison criteria in the _ range
Q97: _ causes adjacent rows to have different
Q98: Excel includes _ database functions that allow
Q99: The path to the Percent Style button
Q100: The Subtotal command displays outline symbols beside
Q101: If the function references a(n)<u>range</u> that grows