Exam 5: Creating and Formatting Tables

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

Free
(Multiple Choice)
4.8/5
(33)
Correct Answer:
Verified

A

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

Free
(Multiple Choice)
4.7/5
(42)
Correct Answer:
Verified

A

The Colors list arrow is on the ____ tab.

Free
(Multiple Choice)
4.7/5
(38)
Correct Answer:
Verified

D

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

(Short Answer)
4.9/5
(28)

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

(Multiple Choice)
4.9/5
(33)

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.

(Multiple Choice)
4.9/5
(33)

How do you insert multiple rows at the same time?

(Multiple Choice)
4.8/5
(36)

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

(True/False)
4.8/5
(41)

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

(Multiple Choice)
5.0/5
(24)

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

(True/False)
4.9/5
(31)

The Table button is on the Insert tab.

(True/False)
4.7/5
(39)

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

(True/False)
4.9/5
(38)

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

(Multiple Choice)
4.8/5
(28)

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

(Multiple Choice)
4.9/5
(30)

You are preparing a summary budget for an advertising campaign in San Francisco. The contents of the table you have created so far are: Type Location Cost Web SFGate.com 25,000 Examiner.com 3,250 Print San Francisco Chronicle 27,600 San Francisco Examiner 15,300 San Francisco Magazine 12,400 Misc. Taxi tops 18,000 Muni bus stops 13,500 What could you do to quickly make the table more attractive and easy to read?

(Essay)
4.8/5
(36)

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

(Essay)
4.8/5
(35)

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

(True/False)
4.8/5
(30)

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.

(Multiple Choice)
4.9/5
(26)

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

(Multiple Choice)
4.9/5
(42)

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

(Multiple Choice)
4.9/5
(33)
Showing 1 - 20 of 70
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)