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

Question

Quizplus · Accepted Answer

By entering the data into a table, Jane can efficiently manage and manipulate the data using various features like sorting, filtering, and using database functions.

Jane Has a Worksheet That Contains a Large Amount of Data