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.
-You tell Jane that if she ____,then she can easily add and delete product records,change the values of fields in records,sort the records in a different order,determine subtotals for numeric fields,display records that meet comparison criteria,and analyze data using database functions.
A) deletes the range and reenters the data in a table
B) enters a table
C) prints the range as a table
D) converts the table back to a range
Correct Answer:

Verified
Correct Answer:
Verified
Q28: A(n)_ total sums all of the data
Q29: A(n)_ is the sum of a subset
Q30: Excel turns on the outline feature automatically
Q31: Excel includes _ types of conditional formats.
Q32: In a table,a column that contains formulas
Q34: MATCHING<br>Identify the letter of the choice that
Q35: You can insert a _ at the
Q36: The _ function returns the value or
Q37: MATCHING<br>Identify the letter of the choice that
Q38: Dan is manipulating data in a table