Deck 6: Creating and Formatting Tables

Question 1

Item ____, shown in the accompanying figure, is a cell.

A) 1
B) 2
C) 3
D) 4

Answer 1

B

Question 2

The Table button is on the INSERT tab.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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 8

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

Question 9

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

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

Question 10

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

Question 11

The lines that divide columns and rows are called grids.

Question 12

Use the buttons in the Table Styles group on the TABLE TOOLS LAYOUT tab to apply a table style. _________________________

Question 13

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

Question 14

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

Question 15

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 16

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

Question 17

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 18

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

Question 19

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

Question 20

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

Question 21

Item ____, shown in the accompanying figure, is used to move the table.

A) 1
B) 2
C) 3
D) 4

Question 22

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

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

Question 23

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 24

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 25

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 26

Which sort order lists data alphabetically from A to Z?

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

Question 27

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 28

Item ____, shown in the accompanying figure, is an end of cell mark.

A) 1
B) 2
C) 3
D) 4

Question 29

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 30

Item ____, shown in the accompanying figure, is an end of row mark.

A) 1
B) 2
C) 3
D) 4

Question 31

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 32

Item ____, shown in the accompanying figure, is a column.

A) 2
B) 3
C) 4
D) 5

Question 33

Item ____, shown in the accompanying figure, is an Insert Control.

A) 1
B) 2
C) 3
D) 4

Question 34

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 35

Item ____, shown in the accompanying figure, is a result of clicking item 1.

A) 1
B) 2
C) 3
D) 4

Question 36

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

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

Question 37

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

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

Question 38

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 39

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 40

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 41

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

Question 42

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 43

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

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

Question 44

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

Question 45

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

Question 46

The Colors list arrow is on the ____ tab.

A) HOME
B) STYLE
C) SWATCHES
D) DESIGN

Question 47

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

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

Question 48

In the accompanying figure, the cell reference of the insertion point is ____.

Question 49

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

Question 50

In the table shown in the accompanying figure, what type of cell is the cell labeled "C"?

A) sorted
B) merged
C) split
D) formatted

Question 51

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

Question 52

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

Question 53

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

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

Question 54

In the table shown in the accompanying figure, what is the cell reference for the cell labeled "A"?

A) 1C
B) A3
C) C1
D) 3A

Question 55

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 56

____________________ sort order lists data alphabetically or sequentially.

Question 57

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 58

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

Question 59

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

Question 60

The Shading list arrow is in the ____ group.

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

Question 61

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 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. Below is the table that you have created thus far.

How can you use the SUM function to calculate the total sales for P. Burke? ( Hint : Write the formula.)

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. Below is the table that you have created thus far.

Once all the sales per person totals have been calculated, how would you use the SUM function to calculate the grand total of all the sales?

Question 64

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 65

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. Below is the table that you have created thus far.

How would you sort the table by the names of the salespeople in alphabetical order?