Question 1

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.​

Accepted Answer

The answer of To open the Formula dialog box, click...

Question 2

Describe the different ways you can sort data in a table and how to do so.

Accepted Answer

The answer of Describe the different ways you can sort...

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.  
​ The total sales for Quarter 1 and Quarter 2 for each of the four salespeople are in cells D3 through D6. 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. The sales for the 1st quarter for P. Burke are in cell B4 and the sales for the 2nd quarter are in cell  C4. How can you use the SUM function to calculate the total sales for P. Burke in cell D4? ( Hint : Write the formula.)

Accepted Answer

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

Question 5

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: 
  
What could you do to quickly make the table more attractive and easy to read?

Accepted Answer

The answer of You are preparing a summary budget for...

Question 6

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: 
  You decide to combine Print and Misc. into one cell. How can you do this?

Accepted Answer

The answer of You are preparing a summary budget for...

Question 7

Use the ____________________ function to quickly total the numbers in a column or row.

Accepted Answer

The answer of Use the ____________________ function to quickly total...

Question 8

You must type a(n) ____________________in any blank cell before using the SUM function.

Accepted Answer

The answer of You must type a(n) ____________________in any blank...

Question 9

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

Accepted Answer

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

Question 10

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.  
There are four salespeople in the table. 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...

Quiz 6: Creating and Formatting Tables

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.​

Describe the different ways you can sort data in a table and how to do so.

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: What could you do to quickly make the table more attractive and easy to read?

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: You decide to combine Print and Misc. into one cell. How can you do this?

Use the ____________________ function to quickly total the numbers in a column or row.

You must type a(n) ____________________in any blank cell before using the SUM function.

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. There are four salespeople in the table. How would you sort the table by the names of the salespeople in alphabetical order?

To open the Formula dialog box, click the Formula button in the ____________________ group on the Table Tools Layout tab.