Question 1

Describe how to convert text to a table.

Accepted Answer

The answer of Describe how to convert text to a...

Question 2

Describe three ways to resize columns and rows in a table.

Accepted Answer

The answer of Describe three ways to resize columns and...

Question 3

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far.  
 Once all the sales per person totals have been calculated, how would you use the SUM function to calculate the grand total of all the sales?

Accepted Answer

The answer of You manage the Sales department of a...

Question 4

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far.  
 How can you use the SUM function to calculate the total sales for P. Burke? ( Hint : Write the formula.)

Accepted Answer

The answer of You manage the Sales department of a...

Question 5

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far.  
 How would you sort the table by the names of the salespeople in alphabetical order?

Accepted Answer

The answer of You manage the Sales department of a...

Question 6

What could you do to quickly make the table more attractive and easy to read?

Accepted Answer

The answer of What could you do to quickly make...

Quiz 4: Creating and Formatting Tables

Describe how to convert text to a table.

Describe three ways to resize columns and rows in a table.

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. Below is the table that you have created thus far. How would you sort the table by the names of the salespeople in alphabetical order?

What could you do to quickly make the table more attractive and easy to read?