Deck 4: Financial Functions, Data Tables, and Amortization Schedules

Question 1

To automatically resize the columns in a table to fit the contents of cells,click Distribute Columns.

Answer 1

False

Question 2

To move a list item to a lower level,demote the list item.

Answer 2

True

Question 3

Jayla opened a document that has information separated by tab characters and paragraph characters.She wants the information displayed in a table.She should click Table and then Convert Text to Table.

Answer 3

True

Question 4

To view the edges of cells in a table,click View Gridlines

Question 5

To create a numbered list that uses Roman numerals,change the list numbering style.

Question 6

To create two tables from a single table,click Split Table.

Question 7

Nevaeh is working on a document that has text appearing at the top of every page.To delete this text,he should remove the document header.

Question 8

To sort the rows in a table,click the Formula button.

Question 9

To join two cells into a single cell,click Merge Cells.

Question 10

Kayla wants light text to appear in the background of every page of a document,she should add a text watermark.

Question 11

Nevaeh needs bullets in a list to appear like her company's logo.She should change the bullets to a picture.

Question 12

To position text midway between the top,bottom,left,and right of a table cell,select the cell and click Align Top Left.

Question 13

To remove an unwanted page break,click to the left of the page break and press DELETE.

Question 14

Joan wants to remove a line of cells going from the top of a table to the bottom of the table.She should delete a row from the table.

Question 15

To evenly space the columns in a table,click Distribute Columns.

Question 16

To move a list item to a lower level,promote the list item.

Question 17

To add a line around the outside of a table,modify the table shading.

Question 18

To center a table on the page,change the alignment of the table.

Question 19

To specify the distance of a paragraph from the left margin,adjust the left indent marker.

Question 20

To add a border to a table,modify the table shading.

Question 21

Gabriel needs the first column in a table to have special formatting.He should do which of the following?

A) Check the First Column box in the Table Style Options group.
B) Check the Last Column box in the Table Style Options group.
C) Check the Banded Columns box in the Table Style Options group.

Question 22

Josiah needs a row to be exactly 0.5 inches tall.He should do which of the following?

A) Select the row,then enter the desired width in the Width text box.
B) Select the row,then enter the desired height in the Height text box.
C) Drag the row border to adjust the width.
D) Drag the row border to adjust the height.

Question 23

To specify the right edge of a paragraph,which of the following should be done?

A) Drag the right indent marker.
B) Drag the left indent marker.
C) Drag the first line indent marker.
D) Drag the hanging indent marker.

Question 24

To change page numbering to Roman numerals,which of the following should be done?

A) Click the Symbol button and select the desired option.
B) Select the Different First Page option.
C) Manually enter the page numbers as Roman numerals.
D) Format the page numbers.

Question 25

To increase the distance between cells in a table,which of the following should be done?

A) Increase the spacing between cells.
B) Increase the border weight.
C) Increase the cell margin.
D) Increase the width of cells.

Question 26

Jayla needs a column to be exactly 2.5 inches wide.She should do which of the following?

A) Select the column,then enter the desired width in the Width text box.
B) Select the column,then enter the desired height in the Height text box.
C) Drag the column border to adjust the width.
D) Drag the column border to adjust the height.

Question 27

To create columns and rows in a table using the cursor,first which of the following should be done?

A) Click Split Cells.
B) Click Split Table.
C) Click Merge Cells.
D) Click Draw Table.

Question 28

Chloe is experimenting with different layouts for a table.To try out different widths for a column,she should do which of the following?

A) Select Draw Table and modify the table as desired.
B) Drag the column border to resize the width to an approximate value.
C) Select the column and press Delete.
D) Select the column and press Split Cells.

Question 29

Xavier is experimenting with different layouts for a table.To try out different heights for a row,he should do which of the following?

A) Select Draw Table and modify the table as desired.
B) Drag the row border to resize the height to an approximate value.
C) Select the row and press Delete.
D) Select the row and press Split Cells.

Question 30

To increase the space between the contents of a cell and the border of the cell,which of the following should be done?

A) Increase the cell width.
B) Decrease the cell width
C) Decrease the cell margins.
D) Increase the cell margins.

Question 31

To increase the distance between a paragraph and the left margin,which of the following should be done?

A) Change the paragraph spacing.
B) Insert a tab stop.
C) Change the document margins.
D) Increase the left indent of the paragraph.

Question 32

To remove a line or cells going from right to left in a table,which of the following should be done?

A) Delete a table row.
B) Delete a table column.
C) Delete a table cell.

Question 33

Caleb has a hierarchical list that he needs to create in a document.He should do which of the following?

A) Create a multilevel list.
B) Create a single-level bulleted list.
C) Create a single-level numbered list.

Question 34

Kennedy needs to start a new section on a new page.She should do which of the following?

A) Insert a Next Page section break.
B) Insert a Continuous section break.
C) Insert a Page break.
D) Insert a Column break.

Question 35

To create a dotted line border around a table,which of the following should be done?

A) Change the border width.
B) Change the table shading.
C) Change the border style.
D) Change the border color.

Question 36

To duplicate the contents of a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

A) Copy and paste the desired table column.
B) Cut and paste the desired table column.
C) Copy and paste the desired table row.
D) Cut and paste the desired table row.

Question 37

To change the color of a bullet in a list,which of the following should be done?

A) Change the document theme.
B) Click the Colors button and select the desired option.
C) Define a new bullet with the desired color.
D) Click the Theme Effects button and select the desired option.

Question 38

To change lowercase letters to uppercase letters in a smaller font size,which of the following should be done?

A) Format the text in Small caps.
B) Manually replace the lowercase letters with uppercase letters.
C) Format the text in All caps.

Question 39

Kiara needs each column in a table to be 0.5 inches in width.She should do which of the following?

A) Specify a fixed width for the columns.
B) Autofit content in the columns.
C) Click Distribute Columns.
D) Click Distribute Rows.

Question 40

To move a multilevel list item to a higher level,which of the following should be done?

A) Increase the indent of the list item.
B) Decrease the indent of the list item.
C) Add a tab stop.
D) Change the margins.

Question 41

To sort a series of paragraphs in a document alphabetically by the first word in each paragraph,which of the following should be done?

A) Click the Equation button in the Symbols group.
B) Click the Symbol button in the Symbols group.
C) Click the Show/Hide ¶ button in the Paragraph group.
D) Click the Sort button in the Paragraph group.

Question 42

Joseph created a table with columns labeled Name,City,and Telephone.He wants to sort the table by City and then by name.He should do which of the following?

A) Click Sort and select the desired options.
B) Click AutoFit and select the desired options.
C) Click Split Table.
D) Click Properties and select the desired options.

Question 43

To ensure that the result of a formula in a table is accurate,which of the following should be done?

A) Protect the document.
B) Check the document for spelling and grammar errors.
C) Inspect the document.
D) Update the corresponding field.

Question 44

To remove a line of cells going from the top of a table to the bottom of the table,which of the following should be done?

A) Distribute the table's rows.
B) Distribute the table's columns.
C) Delete a table row.
D) Delete a table column.

Question 45

Kevin needs to sort a table by the table's first column.He should do which of the following?

A) Click Distribute Columns.
B) Click AutoFit and then select the desired option.
C) Modify the table properties.
D) Click Sort and then select the desired option.

Question 46

To join two cells into a single cell,which of the following should be done?

A) Click the Merge Cells button.
B) Click the Distribute Rows button.
C) Click the Split Cells button.
D) Click the Split Table button.

Question 47

To automatically resize the columns in a table to fit the contents of cells,which of the following should be done?

A) Click Distribute Columns.
B) Click Distribute Rows.
C) Click AutoFit Contents.
D) Click Align,then Distribute Horizontally.

Question 48

To have text appear in the background of every page in a document,which of the following should be done?

A) Insert a Text Box.
B) Insert a text watermark.
C) Insert WordArt.
D) Insert SmartArt.

Question 49

Brandon needs the outside border of a table to be red.He should do which of the following?

A) Change the border Pen Color to red and then select the Outside Borders option.
B) Change the border Pen Color to red and then select the Inside Borders option.
C) Change the shading Color to red and then select the Outside Borders option.
D) Change the shading Color to red and then select the Inside Borders option.

Question 50

Jada needs the text in a cell to be rotated 90 degrees to the right.She should do which of the following?

A) Click the Align Center Right button.
B) Click the Text Direction button.
C) Click the Sort button.
D) Click the Insert Right button.

Question 51

Brandon has a document with a large amount of data separated by tab characters and paragraph characters.He wants the information displayed in a table.He should do which of the following?

A) Select the data and then click Convert Text to Table.
B) Copy the text into the document header.
C) Create a table and then manually populate each cell with data.
D) Create a table and then click Convert to Text.

Question 52

Tyler created a table that spans across multiple pages.To have the header row appear at the top of each page,he should do which of the following?

A) Select the header row and then click Repeat Header Rows.
B) Copy the header row and paste it in the top row of every page.
C) Select the header row and click Distribute Rows.
D) Select the header and click Insert Below.

Question 53

Malik needs the text in a title to fit on one line,but there is slightly too much text to fit on the line.He needs to retain the text's font and size.He should do which of the following?

A) Set the font spacing to Condensed.
B) Set the font spacing to Expanded.
C) Apply superscript to the font.
D) Apply subscript to the font.

Question 54

To position text midway between the top,bottom,left,and right of a table cell,which of the following should be done?

A) Select the cell and click Align Bottom Center.
B) Select the cell and click Align Center Right.
C) Select the cell and click Align Center Left.
D) Select the cell and click Align Center.

Question 55

To specify the distance of a paragraph from the left margin,which of the following should be done?

A) Adjust the first line indent marker.
B) Adjust the right indent marker.
C) Adjust the hanging indent marker.
D) Adjust the left indent marker.

Question 56

To change the color of a cell in a table,which of the following should be done?

A) Modify the font color of text in the cell.
B) Modify the cell border style.
C) Apply shading to the cell.

Question 57

To evenly space the columns in a table,which of the following should be done?

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

Question 58

To move a list item to a higher level,which of the following should be done?

A) Promote the item.
B) Demote the item.
C) Insert a right tab stop.
D) Insert a left tab stop.

Question 59

To add a line around the outside of a table,which of the following should be done?

A) Modify the table border.
B) Modify the table shading.
C) Modify the table alignment.
D) Modify the cell margins.

Question 60

Laila needs to divide a cell into two cells.She should do which of the following?

A) Split the cell.
B) Merge the cell.
C) Split the table.

Question 61

Jasmine needs to modify the right boundary of a paragraph.She should do which of the following?

A) Drag the left indent marker.
B) Drag the hanging indent marker.
C) Drag the right indent marker.
D) Drag the first line indent marker.

Question 62

William has inserted a block quotation in a document.He needs to increase the distance between the paragraph and the left margin.He should do which of the following?

A) Increase the left indent of the paragraph.
B) Insert a tab stop.
C) Change the paragraph spacing.
D) Change the document margins.

Question 63

To remove a cover page,use the Remove Current Cover Page function.

Question 64

Sydney is working on a table that has no border lines.She is having a difficult time seeing where cells begin and end.She should do which of the following?

A) Add shading to the table.
B) Click View Gridlines.
C) Change the cell margins.
D) Split the table.

Question 65

Anthony needs all the rows in a table to be the same height.He should do which of the following?

A) Distribute the rows.
B) Distribute the columns.
C) AutoFit Contents.
D) AutoFit Window.

Question 66

To specify an exact column width,which of the following should be done?

A) Click Distribute Rows.
B) Specify a fixed width for the columns.
C) Click Distribute Columns.
D) Autofit content in the columns.

Question 67

To return to editing the main document after modifying a header,which of the following should be done? Select all that apply.

A) Double click in the main part of the document.
B) CTRL+Click in the main part of the document.
C) Click the Next button in the Navigation group of the Header & Footer Tools tab.
D) Click the Close Header and Footer button.

Question 68

Joan needs to calculate the average of a column of cells in a table.She should do which of the following?

A) Insert Document Info in the table.
B) Insert a Quick Part in the table.
C) Convert the table to text.
D) Insert a formula in the table.

Question 69

Gabrielle needs a table to be centered on a page.She should do which of the following?

A) Change the alignment of the table.
B) Change the alignment of the cells.
C) Change the orientation of the page.
D) Change the style of the table.

Question 70

Matthew needs to increase the space between the contents of a cell and the border of the cell.He should do which of the following?

A) Increase the cell margins.
B) Decrease the cell margins.
C) Increase the cell width.
D) Decrease the cell width