Question

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	c.	prints the range as a table
b.	enters a table	d.	converts the table back to a range

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)	c.	Format as Table button (HOME tab | Styles group)
b.	Convert to Table button (HOME tab | Styles group)	d.	Apply Table Formatting button (LAYOUT tab | Styles group)

Answer 1

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.

Ans :enters a table

Next you tell Jane that she can accomplish the task by clicking the _____.

C.

Format as Table button (HOME tab | Styles group)