Word Unit E

What formula would you use to calculate the total of the values in cells A1 through A4?

=SUM(A1:A4)

____________________ sort order lists data alphabetically or sequentially.

Ascending

If you want to quickly make all the columns in a table the same width, which command do you use?

Auto fit

The lines that divide the columns and rows in a table are called:

Borders

You can click ____ in the gallery of table styles to remove all borders, shading, and other style elements from the selected table.

Clear

____________________ sort order lists data from Z to A, 9 to 0, or latest to earliest.

Descending

Use the ____________________ Table menu command to create a complex table by drawing the table columns and rows.

Draw Table

Which key is used to update a calculation?

F9

Use the ____ Table menu command to create a table with any number of columns and rows and then select an AutoFit behavior.

Insert Table

Which Table menu command would you use to insert a preformatted table template?

Quick Tables

Each cell in a table has a unique cell ______ composed of a letter and a number which is used when performing calculations

Reference

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

SUM

How do you delete a row?

Select the row, right-click the selected row, and click Delete Rows on the menu that opens.

Pressing ____ at the end of a row moves the insertion point to the first cell in the next row.

Tab

What happens when you use the Copy or Cut and Paste commands to move a row in a table?

The row is inserted above the row containing the insertion point

Press ____ as you drag a border to display the column width or row height measurements on the ruler.

[Alt]

A(n) ____________________ is the box formed by the intersection of a column and a row in a table.

cell

When you ____ a cell, you combine adjacent cells into a single larger cell

merge

A(n) ____________________ is a table that is inserted into the cell of another table.

nested