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

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

Question 2

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 3

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

Revolt · Accepted Answer

C: ✔ Put the cursor in the Food cell.

Question 4

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

Revolt · Accepted Answer

D: =SUM(ABOVE)

Question 5

Which step should Gemima fix to complete the task correctly?

Revolt · Accepted Answer

B: Step 4

Question 6

✔ Select the table.Select the Chart Title text box.Open the Chart Type dialog box.

Revolt · Accepted Answer

A: ✔ Select the table.

Question 7

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.PictureKeep as TextUse Destination StylesKeep Source FormattingLink and Use Destination StylesLink and Keep Source Formatting

Revolt · Accepted Answer

E: Link and Use Destination Styles; F: Link and Keep Source Formatting

Question 8

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

D: ✔ Insert a row above the header row.

Question 9

✔ Use Ctrl+A.Use Ctrl+C.Use Ctrl+V.

Revolt · Accepted Answer

A: ✔ Use Ctrl+A.

Question 10

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

B: ✔ Click the Merge Cells icon.

Using Tables and Charts Answers

More from this Course

TRY EDGENUITY HACKS