Using Tables and Charts

Question 1

Gemima wants to order the different kinds of food alphabetically on the table. Which actions should she take? Check all that apply.

Revolt · Accepted Answer

Click inside the table.; Click on the Sort icon.; Choose the Header Row option in the Sort dialog box.

Question 2

Type the title in the cell.Click the Merge Cells icon.Put the cursor in the Food cell.✔ Insert a row above the header row.

Revolt · Accepted Answer

Insert a row above the header row.

Question 3

Type the title in the cell.✔ Click the Merge Cells icon.Put the cursor in the Food cell.Insert a row above the header row.

Revolt · Accepted Answer

Click the Merge Cells icon.

Question 4

✔ Type the title in the cell.Click the Merge Cells icon.Put the cursor in the Food cell.Insert a row above the header row.

Revolt · Accepted Answer

Type the title in the cell.

Question 5

Order the steps Gemima needs to take to add the title in a single cell at the top of the table.

Revolt · Accepted Answer

Step 1:: Put the cursor in the Food cell.; Step 2:: Insert a row above the header row.; Step 3:: Click the Merge Cells icon.; Step 4:: Type the title in the cell.

Question 6

Order the steps Gemima needs to take to add the title in a single cell at the top of the table. Step 1: Step 2: Step 3: Step 4:

Revolt · Accepted Answer

✔ Put the cursor in the Food cell.; Selection 1: Put the cursor in the Food cell.; Selection 2: Insert a row above the header row.; Selection 3: Click the Merge Cells icon.; Selection 4: Type the title in the cell.

Question 7

DesignInsert✔ Layout

Revolt · Accepted Answer

Layout

Question 8

Which formula should Gemima use to show the amount of vitamin C in the fruit salad?

Revolt · Accepted Answer

=SUM(ABOVE)

Question 9

Which step should Gemima fix to complete the task correctly?

Revolt · Accepted Answer

Step 4

Question 10

Gemima’s classmate Tristan sent her an Excel table that shows the amount of vitamin C in seafood. She wants to paste this table to her Word document.Which pasting option should she use so that the updates in the Excel table are reflected in her Word document? Check all that apply.

Revolt · Accepted Answer

Link and Use Destination Styles; Link and Keep Source Formatting

Using Tables and Charts Answers

More from this Course

TRY EDGENUITY HACKS