Deck 6: Creating and Formatting Tables

Question 1

The lines that divide columns and rows are called grids.

Answer 1

False

Question 2

You can only use the Draw pointer and Erase pointer to change the structure of a table you draw from scratch.​

Answer 2

False

Question 3

When you copy and paste a column within a table, the column is inserted to the left of  the column containing the insertion point.​ ____________________

Answer 3

True

Question 4

Pressing [Enter] at the end of the last cell of a table creates a new row at the bottom of the table. _________________________

Question 5

The Table button is on the Insert tab.

Question 6

If you want to sort an entire table, you must select the table.

Question 7

The Split Cells command allows you to split a table into two tables.

Question 8

You can convert text that is sep arated by a comma into a table.​

Question 9

The Word Draw Table feature allows you to draw table cells exactly where you want them.​

Question 10

It is often easier to add and delete columns and rows using the mouse.

Question 11

When you split a cell that contains text, Word splits the text between the new cells.

Question 12

You copy and move rows and columns differently than you copy and move text.​

Question 13

When you copy and paste a row within a table, the row is inserted belo w the row containing the insertion point.​ ____________________

Question 14

When you select a row, you must also select the end of row mark for the row to be selected.

Question 15

Quickly resize a table by dragging the table resize handle to a new location.

Question 16

Ascending order lists data alphabetically from A-Z or sequentially from 0-9. _________________________

Question 17

You can use the Caption tab in the Table Properties dialog box to add alternative​ test for a table that will appear on a Web page.

Question 18

When sorting text information in a document, the term " fields " refers to text or numbers that are separated by a character, such as a tab or comma. ____________________​

Question 19

Use the AutoFit command to change the height of rows or the width of columns.

Question 20

Pressing [Enter] moves the insertion point to the next cell in the row.

Question 21

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

A) divider
B) table
C) cell
D) border

Question 22

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

A) [Spacebar]
B) [Tab]
C) [Enter]
D) [Ctrl]

Question 23

The Table Tools Layout tab includes buttons for applying table styles and for adding, removing, and customizing borders and shading.​ ____________________

Question 24

Use the buttons in the Table Styles group on the Table Tools  Layout tab to apply a table style. _________________________

Question 25

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

Question 26

To convert text to a table, select the text, click the Table button in the Tables group on the Insert tab, and then click _____.​

A) Import Text to Table
B) ​Convert Text to Table
C) ​Import Text
D) ​Change Text to Table

Question 27

You can convert a table to text that is separated by tabs, by selecting the table, clicking the ​_____ tab, and then clicking the Convert to Text button.

A) ​Table Tools Layout
B) ​Data
C) ​Insert
D) ​Home

Question 28

When you move the pointer to the left of two existing rows, a(n) ____ appears outside the table.

A) Insert Control
B) New Row icon
C) Mini toolbar
D) Table Selector

Question 29

Which sort order lists data alphabetically from A to Z?

A) Alphabetical
B) Descending
C) Sequential
D) Ascending

Question 30

How do you center the text vertically in each table cell?

A) Select the table and click the Center button in the Paragraph group on the Home tab.
B) Click the Select button in the Table group, click Select Table, then click the Align Center Left button in the Alignment group.
C) Select the table and click the Distribute Columns button.
D) Select the table and click the AutoFit button.

Question 31

The lines that divide columns and rows in a table are called borders . _________________________

Question 32

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

A) Quick Tables
B) Draw Table
C) Insert Table
D) New Table

Question 33

When you want to wrap text around a table, you click the Properties command in the _____ group on the Table Tools Layout tab.​

A) ​Merge
B) ​Data
C) ​Alignment
D) ​Table

Question 34

You can quickly center a table on a page by clicking the ____ button in the Paragraph group on the Home tab.

A) Center
B) Align
C) Center Table
D) Line Up

Question 35

What happens when you click the table move handle?

A) The table moves.
B) All the rows and columns are automatically resized.
C) The table is selected.
D) The pointer changes to the Move pointer.

Question 36

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

A) AutoFit Contents
B) AutoFit Window
C) Distribute Rows
D) Distribute Columns

Question 37

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

A) [Alt]
B) [Ctrl]
C) [Shift]
D) [Ctrl][Alt]

Question 38

How do you insert multiple rows at the same time?

A) Click Insert Multiple Rows in the Rows & Columns group.
B) Select the number of rows you want to insert, then use an Insert Control or use the buttons on the Ribbon.
C) Select one row and click the Insert Above or Insert Below button. You will be prompted to choose how many rows to insert.
D) You cannot insert multiple rows at the same time.

Question 39

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

A) gridlines
B) guidelines
C) borders
D) dividers

Question 40

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

A) Insert Table
B) Draw Table
C) Create Table from Template
D) Quick Tables

Question 41

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

A) =SUM(A1:A4)
B) =(A1-A4)
C) =SUM(A1-A4)
D) =(A1:A4)

Question 42

You can convert text that is separated by a tab, a(n) ____________________, or another separator character into a table.​

Question 43

The Cell Margins button appears in the ____ group on the Table Tools Layout tab.

A) Layout
B) Cell Size
C) Alignment
D) Print Preview

Question 44

The Colors list arrow is on the ____ tab.

A) Home
B) Style
C) Swatches
D) Design

Question 45

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

Question 46

Use the ____ dialog box to sort data that is not formatted as a table, such as lists or paragraphs.

A) Sort Text
B) Sort
C) Paragraph
D) Organize

Question 47

A ____ row is the first row of a table that contains the column headings.

A) header
B) title
C) primary
D) heading

Question 48

The cell in the fifth row of the third column is cell ____.

A) 5C
B) 3E
C) E3
D) C5

Question 49

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

Question 50

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

Question 51

To turn gridlines off or on, you should click the View Gridlines button in the ____ group on the Table Tools Layout tab.

A) Data
B) Table
C) Format
D) Rows & Columns

Question 52

The Split Cells command appears in the ____ group on the Table Tools Layout tab.

A) Rows & Columns
B) Cell Size
C) Merge
D) Split

Question 53

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

A) combine
B) merge
C) split
D) join

Question 54

____________________ sort order lists data alphabetically or sequentially.

Question 55

The Shading list arrow is in the ____ group.

A) Table Styles
B) Borders & Shading
C) Format
D) Design

Question 56

The text following an equal sign (=) is a(n) ____.

A) formula
B) cell reference
C) function
D) argument

Question 57

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

A) Clear
B) Reset
C) Default
D) Remove

Question 58

Use the ____ dialog box to organize the rows of a table in alphabetical or sequential order based on the data in one or more columns.

A) Organize
B) Format Table
C) Table Properties
D) Sort

Question 59

Use the ____________________ Table menu command to insert a blank Excel worksheet into a document as an embedded object.

Question 60

Which key is used to update the field result of a calculation?

A) [F6]
B) [F9]
C) [F4]
D) [F3]

Question 61

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

Question 62

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

Question 63

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?

Question 64

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.)

Question 65

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?

Question 66

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?

Question 67

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

Question 68

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

Question 69

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

Question 70

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?