Using Tables and Charts

Gemima now has the Formula dialog box open. Which formula should Gemima use to show the amount of vitamin C in the fruit salad?

=SUM(ABOVE)

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

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

Which command group does a user need to access the Formula dialog box?

Data

What is the purpose of the Chart feature in Word?

Information can be typed into a chart to create a graph.

Gemima wants to show the amount of vitamin C a fruit salad contains in the blue cell of the table below. To do this, she needs to open the Formula dialog box. Which tab should Gemima use to open the Formula dialog box? Which command group should she use? Which icon should she click?

Layout, Data, Formula

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.

Link and Use Destination Styles Link and Keep Source Formatting

Gemima has converted her table to a clustered column chart. She now wants to add a title. What should Gemima do first? What should Gemima do next? What should Gemima do last?

Select the table, Use Ctrl+A, Type the title.

After sorting the data, Gemima wants to add a title row to her table. Order the steps Gemima needs to take to add the title in a single cell at the top of the table.

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

Which step should Gemima fix to complete the task correctly?

Step 4

Why is it important to put the insertion point in the table when sorting table data?

This action opens Table Tools, which contains the sorting feature.

Which tasks can be completed using the Chart Tools Design tab? Check all that apply.

add a title to a chart change the way a chart looks change the type of an existing chart

How can an Excel table be added to a Word document? Check all that apply.

by using the Insert Object dialog box by linking an Excel table to a Word document

Which object tells Word that a formula is being entered into a cell?

equal sign