Deck 5: Creating and Formatting Tables

Question 1

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

Answer 1

True

Question 2

The lines that divide columns and rows are called grids.

Answer 2

False

Question 3

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.

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

The Table button is on the Insert tab.

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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

Question 25

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 26

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

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 29

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

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

Question 30

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 31

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

Question 32

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

Question 33

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 34

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

Question 35

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 36

Which sort order lists data alphabetically from A to Z?

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

Question 37

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

____________________ sort order lists data alphabetically or sequentially.

Question 42

The Colors list arrow is on the ____ tab.

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

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

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

Question 45

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 46

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

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

Question 47

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

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

Question 48

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 49

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 50

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

Question 51

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 52

The Shading list arrow is in the ____ group.

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

Question 53

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

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

Question 54

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

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

Question 55

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 56

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

Question 57

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

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

Question 58

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

Question 59

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 60

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

Question 61

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

Question 62

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 63

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

Question 64

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

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:

You decide to combine Print and Misc. into one cell. How can you do this?

Question 66

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?

Question 67

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

Question 68

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 69

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

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