Excel Chapter 4

Sep 10th, 2023

4.7 (114 reviews)

98 test answers

question

What is true about adding a new field to the right side of an existing data table?A) You must insert the new field somewhere inside the existing table, then move thecolumns to the order you desire.B) You cannot add a new field to an existing data table.C) You can add it to the right of the data table and Excel will extend the table to include thenew field.D) You must convert the table back to a range, add the field, then recreate the table.

answer

You can add it to the right of the data table and Excel will extend the table to include the new field.

question

Which one of the following filter options is not found on the text filter submenu?A) Custom Filter B) Includes C) Contains D) Begins With

answer

Includes

question

In conditional formatting what happens if the cell value does not pass the logical test?A) The cell is formatted however you have determined for the FALSE result.B) The cell is formatted with Excel's default FALSE format.C) A small green triangle displays in the top-left corner of the cell.D) The cell is not formatted.

answer

The cell is not formatted

question

How does Excel indicate that a column has been selected in a structured reference?A) A type of colored sticky note is attached to that column.B) There is nothing to indicate a column has been selected.C) A light shading appears in that column.D) A colored border appears around that column.

answer

A colored border appears around that column

question

If you use the Color Scale conditional formatting, you are limited to how many colors (andtheir gradations?)A) Unlimited B) 2 or 3 C) 1,012 D) 256

answer

2 or 3

question

What feature in Excel automatically displays a list of field headings when you begin to create astructured reference?A) Formula AutoCompleteB) Reference AutoCompleteC) AutoCompleteD) Nothing automatically displays a list of field headings.

answer

Formula AutoComplete

question

What is the default data table style?A) Medium 1 B) Medium 2 C) Normal D) None

answer

Medium 2

question

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?A) The number of rows to subtotalB) The row number in which to place the subtotalC) The COUNT functionD) The SUM function

answer

The COUNT function

question

What data does Excel print by default?A) The entire dataset on the active sheetB) The entire workbookC) The selected range of dataD) There is no default setting for this in Excel.

answer

The entire dataset on the active sheet

question

By default, what is the first table on a worksheet named? A) Table B) Table AC) Table 1 D) Data tables do not have names.

answer

Table 1

question

Which of the following is not a conditional formatting option?A) Data bars B) Table format C) Color Scales D) Icon Sets

answer

Table format

question

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?A) The range to be included in the calculationB) The PAID recordC) The label for the resultant Total RowD) The Excel function called PAID

answer

The range to be included in the calculation

question

Where does Excel display the Total row in a table?A) Below the last row in the tableB) After each subtotal in the tableC) At the top of the tableD) Two rows below the last row in the table

answer

Below the last row in the table

question

By default Excel prints page in what order?A) All the even numbered pages, then all the odd numbered pagesB) All the odd numbered pages, then all the even numbered pagesC) Top-left section, top-right section, bottom-left section, and bottom-right sectionD) Top-left section, bottom-left section, top-right section, and bottom-right section

answer

Top-left section, bottom-left section, top-right section, and bottom-right section

question

By how many levels will Excel allow you to sort?A) 32 B) 128 C) 64 D) 16

answer

question

Which conditional formatting option would you choose if you wanted to apply formatting tocells whose value falls between two numbers?A) Top/Bottom Rules B) Highlight Cells RulesC) Color Scales D) Between Values Rules

answer

Highlight cells rules

question

What is not true about tables in Excel?A) Column headings stay on the screen automatically.B) You can export the data to a SharePoint list.C) Filter arrows make it quick and easy to filter the data in the table.D) Row headings stay on the screen automatically.

answer

Row heading stay on the screen automatically

question

On which tab will you find options if you have to print a large dataset?A) Page Layout B) Home C) Print D) Review

answer

Page layout

question

When you have frozen rows and columns, what happens when you press the Ctrl+Homecombination?A) A1 becomes the active cell.B) The first unfrozen cell becomes the active cell.C) Row 1 and whatever column was active when you pressed the combination becomes theactive cell.D) Column A and whatever row was active when you pressed the combination becomes theactive cell.

answer

The first unfrozen cell becomes the active cell

question

To what does the @ symbol refer in a structured reference? A) Current column B) Current cellC) Current table D) Current row

answer

Current row

question

The filter Begins With... option is found on which type of filter? A) Custom filter B) Text filter C) Number filterD) Date filter

answer

Text Filter

question

Which conditional formatting option is not found in the Quick Analysis Gallery? A) Duplicate Values B) Unique ValuesC) Text Contains D) Undo Format

answer

Undo Format

question

Which wildcard character only replaces one character with one other character?A) Tilde ~ B) Number sign #C) Question Mark ? D) Asterisk *

answer

Question Mark ?

question

Using the data bars conditional formatting, how is the highest value represented?A) By the most number of bars B) By the longest barC) By the darkest bar D) By the tallest bar

answer

By the longest bar

question

Which of the following is not a freeze option? A) Freeze Top Row B) Freeze First ColumnC) Freeze Panes D) Freeze Section

answer

Freeze section

question

If you use the Icon sets conditional formatting, you are limited to how many categories? A) Three, four, or five B) One, two, or threeC) Four, five, or six D) Two, three, or four

answer

Three, four, or five

question

Which of the following is not a way to bring up the Go To dialog box? A) F5 B) Ctrl+G C) Alt+F7 D) Name Box

answer

alt+f7

question

What cannot be found on the Manage Rules dialog box? A) New Rule B) Edit Rule C) Copy Rule D) Delete Rule

answer

Copy rule

question

Which one of the following filter options is not found on the number filter submenu? A) Below Average B) Bottom 10... C) Greater Than... D) Between...

answer

bottom 10...

question

When would you not need to use a fully qualified structured reference? A) When referring to a cell on a different worksheetB) When referring to a cell on a different workbookC) When referring to a cell within the tableD) When referring to a cell outside the table

answer

When referring to a cell within the table

question

Which of the following is not a characteristic of a table?A) Can contain multiple ranges B) Contains related dataC) Helps to analyze information D) Helps to manage information

answer

Can contain multiple ranges

question

In a structured reference what do you use to indicate a column heading or field name?A) Parenthesis () B) Curly brackets {}C) Brackets [] D) Quotes

answer

Brackets []

question

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use whatfeature in Excel?A) AutoComplete formatting B) Aggregate Cell formattingC) AutoFill formatting D) Conditional formatting

answer

Conditional formatting

question

What is not true about creating a data table? A) Make sure to leave one blank row below the data labels.B) Format the field names so that they stand out visually.C) Keep field names short.D) Make sure no column labels are the same.

answer

Make sure to leave one blank row below the data labels

question

Which table style option is useful to display aggregated data when it is checked?A) Last Column B) Header Row C) Filter Button D) Total Row

answer

Last column

question

What is not true about creating a data table? A) Each record should be unique somehow.B) For efficiency, make sure your data table does not exceed 256 rows.C) Delete any blank columns in your table.D) It is best to put individual data tables on separate sheets.

answer

For efficiency, make sure your data table does not exceed 256 rows

question

Which table style option shows the field names when it is checked? A) Banded Columns B) Total RowC) First Column D) Header Row

answer

Header Row

question

What would be the result if you sorted the following dates in ascending order: December 25,2000; January 1, 2015; January 16, 1957; December 26, 1959?A) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959C) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

answer

January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015

question

What is not true about using the AND function in a custom conditional formatting rule? A) You may have as many tests as you need in the formula.B) You must have at least two tests in the formula.C) All the tests must be of the same data type, for example: all numbers or all text.D) All the logical tests must be true for the formatting to be applied.

answer

All the tests must be of the same data type, for example: all numbers or all text

question

Which one of the following filter options is not found on the date filter submenu? A) Between B) First Quarter C) Last Month D) Tomorrow

answer

First Quarter

question

In a structured reference, when you use field headings without row references it iscalled a(n) ________ reference.

answer

Unqualified

question

Match the following terms with their description:I. Color scaleII. Icon setIII. FilteringIV. SortingV. Data barsA. Colors are based on the relative values in the cell.B. Arranging recordsC. Symbols or signs that classify dataD. Various widths represent the cell's value.E. Using conditions to limit the visible data

answer

1.a 2.c 3.e 4.b 5.d

question

Match the following terms with their description:I. Unqualified referenceII. Fully qualified structured referenceIII. Structured referenceIV. SUBTOTAL functionV. Total rowA. Uses a field name as the reference in a tableB. Contains the table nameC. Field headings without row referencesD. Displays below the last row in a tableE. Calculates an aggregate value

answer

1.c 2.b 3.a 4.e 5.d

question

Using the Print ________ can help you save paper.

answer

Preview

question

Use the Sort by ________ Color if you want to sort records by the color of the text.

answer

font

question

Match the following Conditional Formatting Options with their description:I. Highlight Cells RulesII. Top/Bottom RulesIII. Data barsIV. Color ScalesV. Icon SetsA. Formats cells if they fall in the lowest % (% determined by the user)B. Formats cells with gradients of color depending on the cell's value compared to theother values in the rangeC. Formats cells with colors whose width is proportional to the other values in therangeD. Formats cells if a date falls in a certain rangeE. Uses symbols to represent the comparison of values

answer

1.d 2.a 3.c 4.b 5.e

question

Match the following Subtotal Function with their Table Numbers:I. AVERAGEII. MAXIII. MINIV. SUMV. COUNTAA. 104B. 103C. 101D. 109E. 105

answer

1.c 2.a 3.e 4.d 5.b

question

Match the following terms with their description:I. FieldII. RecordIII. TableIV. Table styleV. Total rowA. Includes complimentary fill colorsB. Complete set of fields for one entityC. Structured rangeD. Appears below the last row in a tableE. Smallest piece of data collected

answer

1.e 2.b 3.c 4.a 5.d

question

You can see how many records meet the conditions of the filter by looking at the ________ bar.

answer

Status

question

When you set up various conditions with the purpose of only showing a subset of data, that process is called ________.

answer

Filtering

question

Match the following table style options with their description:I. Header RowII. Total RowIII. First ColumnIV. Last ColumnV. Filter ButtonA. Displays a total row when selectedB. Makes sure that the row headings stand outC. Displays on the right side of each heading in the header rowD. Used to make aggregated data stand outE. Removes field names when not checked

answer

1.e 2.a 3.b 4.d 5.c

question

________ references help to clarify what type of data is being used in any calculations.

answer

Structured

question

Data ________ is the method used to organize data points in a dataset.

answer

Structure

question

Excel will allow you to sort on ________ levels.

answer

question

In a data table each column is considered a(n) ________.

answer

Field

question

If you wanted several cells to be filled with a certain color where the width of the fillcolor in the cell represents that cell's value compared to the values in the other cells,you would use the Data ________ conditional formatting option.

answer

Bars

question

When you include table names in a structure reference it is called a(n) ________ structured reference.

answer

Fully qualified

question

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

answer

home

question

A collection of fields about one person would be considered a(n) ________.

answer

record

question

Table ________ add color and borders to a table.

answer

style

question

A(n) ________ is a range of organized, related data

answer

table

question

________ page breaks can be inserted if the automatic page breaks would occur atundesirable places.

answer

manual

question

In a data table each row is considered a(n) ________.

answer

record

question

Match the following table style options with their description:I. Header RowII. Total RowIII. First ColumnIV. Last ColumnV. Banded RowsA. The formatting of this row/these rows take/takes priority over column formatting.B. Alternate fill colors distinguish one row from another row.C. Makes sure that the row headings stand outD. Displays the field names when checkedE. Often used for aggregated data

answer

1.d 2.a 3.c 4.e 5.b

question

The Table Styles ________ shows you all the table styles which are available.

answer

gallery

question

Match the following terms with their description:I. Print areaII. Print orderIII. Page breakIV. FreezingV. Conditional formattingA. Where data will print on the next pageB. The range of cells that will be printedC. Rules used to emphasize cellsD. Keeps certain rows or columns on the screen at all timesE. Sequence of printed pages

answer

1.b 2.e 3.a 4.d 5.c

question

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:I. Text ContainsII. Duplicate ValuesIII. Unique ValuesIV. Equal ToV. Clear FormatA. Formats cells that have exactly the same valueB. Formats any cell that has content that matches the first content in the first selectedcellC. Removes any conditional formattingD. Formats cells that have no matching valuesE. Formats cells that have the value

answer

1.b 2.a 3.d 4.e 5.c

question

If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n) ________ sort.

answer

custom

question

The print ________ is the range of cells that will be printed.

answer

area

question

Match the following Data Type Sort Options with their example:I. Sort Z to AII. Sort Oldest to NewestIII. Sort Largest to SmallestIV. Sort A to ZV. Sort Newest to OldestA. Number; Othniel; PsychologyB. 11/20/2015; 8/20/2015; 5/25/91C. 58; 29; 27D. 1/16/1957; 12/26/1959; 1/7/87E. Karen; Doug; Barb

answer

1.e 2.d 3.c 4.a 5.b

question

True or False: Filter arrows are always displayed in data tables.

answer

False

question

True or False: Selecting a range automatically makes it a data table.

answer

False

question

True or False: When you use the Freeze Panes option you freezing both columns and rows.

answer

True

question

True or False: In a data table calculated columns will copy down the table automatically.

answer

True

question

True or False: John Smith is a good example of a field.

answer

False

question

True or False: You can freeze as many columns and rows at the same time as you desire.

answer

True

question

True or False: It is impossible to create a data table from random, unorganized data.

answer

False

question

True or False: After a table has been named, that name can be used in functions instead of cell references.

answer

True

question

True or False: You can select multiple print areas.

answer

True

question

True or False: To print row labels on the left side of each page you would select the row(s) that contain thelabels in the rows to repeat at left box.

answer

False

question

True or False: You can manually adjust a page break by pointing to the page break line and waiting for thefour-headed arrow to appear, then drag the page break to your desired location.

answer

False

question

True or False: This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

answer

True

question

True or False: Excel uses dashed blue lines to indicate manual page breaks.

answer

False

question

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

answer

False

question

True or False: Excel uses solid blue lines to indicate automatic page breaks.

answer

False

question

True or False: Records are individual pieces of information.

answer

False

question

True or False: It is a good practice to print column and row labels on each page.

answer

True

question

True or False: When you enter a structured reference in a formula Excel copies that formula down the rest ofthe column automatically.

answer

True

question

True or False: Rows and/or columns which have been deleted in a data table can be brought back with theUndo command.

answer

True

question

True or False: In Normal view or Page Layout view the data to be printed has a dark blue border.

answer

False

question

True or False: You cannot sort cells by their fill color.

answer

False

question

True or False: Before you freeze panes make sure the active cell is one row above and one column to the leftof the rows and columns you want to freeze.

answer

False

question

True or False: In Page Break Preview, the area to be printed has a light blue background.

answer

False

question

True or False: You can add a row to a data table as long as you put in the row immediately below the table.

answer

True

question

True or False: Locking is the process of making sure that certain rows or columns are visible at all times.

answer

False

question

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

answer

true

question

In Normal view or Page Layout view the data to be printed has a dark blue border.

answer

false

question

You cannot sort cells by their fill color.

answer

false

1 of 98

question

answer

You can add it to the right of the data table and Excel will extend the table to include the new field.

question

Which one of the following filter options is not found on the text filter submenu?A) Custom Filter B) Includes C) Contains D) Begins With

answer

Includes

question

answer

The cell is not formatted

question

answer

A colored border appears around that column

Don’t waste time

You can get a custom paper by one of our expert writers.

Get your custom essay

Helping students since 2015

question

If you use the Color Scale conditional formatting, you are limited to how many colors (andtheir gradations?)A) Unlimited B) 2 or 3 C) 1,012 D) 256

answer

2 or 3

question

answer

Formula AutoComplete

question

What is the default data table style?A) Medium 1 B) Medium 2 C) Normal D) None

answer

Medium 2

question

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?A) The number of rows to subtotalB) The row number in which to place the subtotalC) The COUNT functionD) The SUM function

answer

The COUNT function

question

What data does Excel print by default?A) The entire dataset on the active sheetB) The entire workbookC) The selected range of dataD) There is no default setting for this in Excel.

answer

The entire dataset on the active sheet

question

By default, what is the first table on a worksheet named? A) Table B) Table AC) Table 1 D) Data tables do not have names.

answer

Table 1

question

Which of the following is not a conditional formatting option?A) Data bars B) Table format C) Color Scales D) Icon Sets

answer

Table format

question

answer

The range to be included in the calculation

question

Where does Excel display the Total row in a table?A) Below the last row in the tableB) After each subtotal in the tableC) At the top of the tableD) Two rows below the last row in the table

answer

Below the last row in the table

question

answer

Top-left section, bottom-left section, top-right section, and bottom-right section

question

By how many levels will Excel allow you to sort?A) 32 B) 128 C) 64 D) 16

answer

question

answer

Highlight cells rules

question

answer

Row heading stay on the screen automatically

question

On which tab will you find options if you have to print a large dataset?A) Page Layout B) Home C) Print D) Review

answer

Page layout

question

answer

The first unfrozen cell becomes the active cell

question

To what does the @ symbol refer in a structured reference? A) Current column B) Current cellC) Current table D) Current row

answer

Current row

question

The filter Begins With... option is found on which type of filter? A) Custom filter B) Text filter C) Number filterD) Date filter

answer

Text Filter

question

Which conditional formatting option is not found in the Quick Analysis Gallery? A) Duplicate Values B) Unique ValuesC) Text Contains D) Undo Format

answer

Undo Format

question

Which wildcard character only replaces one character with one other character?A) Tilde ~ B) Number sign #C) Question Mark ? D) Asterisk *

answer

Question Mark ?

question

Using the data bars conditional formatting, how is the highest value represented?A) By the most number of bars B) By the longest barC) By the darkest bar D) By the tallest bar

answer

By the longest bar

question

Which of the following is not a freeze option? A) Freeze Top Row B) Freeze First ColumnC) Freeze Panes D) Freeze Section

answer

Freeze section

question

If you use the Icon sets conditional formatting, you are limited to how many categories? A) Three, four, or five B) One, two, or threeC) Four, five, or six D) Two, three, or four

answer

Three, four, or five

question

Which of the following is not a way to bring up the Go To dialog box? A) F5 B) Ctrl+G C) Alt+F7 D) Name Box

answer

alt+f7

question

What cannot be found on the Manage Rules dialog box? A) New Rule B) Edit Rule C) Copy Rule D) Delete Rule

answer

Copy rule

question

Which one of the following filter options is not found on the number filter submenu? A) Below Average B) Bottom 10... C) Greater Than... D) Between...

answer

bottom 10...

question

answer

When referring to a cell within the table

question

Which of the following is not a characteristic of a table?A) Can contain multiple ranges B) Contains related dataC) Helps to analyze information D) Helps to manage information

answer

Can contain multiple ranges

question

In a structured reference what do you use to indicate a column heading or field name?A) Parenthesis () B) Curly brackets {}C) Brackets [] D) Quotes

answer

Brackets []

question

answer

Conditional formatting

question

answer

Make sure to leave one blank row below the data labels

question

Which table style option is useful to display aggregated data when it is checked?A) Last Column B) Header Row C) Filter Button D) Total Row

answer

Last column

question

answer

For efficiency, make sure your data table does not exceed 256 rows

question

Which table style option shows the field names when it is checked? A) Banded Columns B) Total RowC) First Column D) Header Row

answer

Header Row

question

answer

January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015

question

answer

All the tests must be of the same data type, for example: all numbers or all text

question

Which one of the following filter options is not found on the date filter submenu? A) Between B) First Quarter C) Last Month D) Tomorrow

answer

First Quarter

question

In a structured reference, when you use field headings without row references it iscalled a(n) ________ reference.

answer

Unqualified

question

answer

1.a 2.c 3.e 4.b 5.d

question

answer

1.c 2.b 3.a 4.e 5.d

question

Using the Print ________ can help you save paper.

answer

Preview

question

Use the Sort by ________ Color if you want to sort records by the color of the text.

answer

font

question

answer

1.d 2.a 3.c 4.b 5.e

question

Match the following Subtotal Function with their Table Numbers:I. AVERAGEII. MAXIII. MINIV. SUMV. COUNTAA. 104B. 103C. 101D. 109E. 105

answer

1.c 2.a 3.e 4.d 5.b

question

answer

1.e 2.b 3.c 4.a 5.d

question

You can see how many records meet the conditions of the filter by looking at the ________ bar.

answer

Status

question

When you set up various conditions with the purpose of only showing a subset of data, that process is called ________.

answer

Filtering

question

answer

1.e 2.a 3.b 4.d 5.c

question

________ references help to clarify what type of data is being used in any calculations.

answer

Structured

question

Data ________ is the method used to organize data points in a dataset.

answer

Structure

question

Excel will allow you to sort on ________ levels.

answer

question

In a data table each column is considered a(n) ________.

answer

Field

question

answer

Bars

question

When you include table names in a structure reference it is called a(n) ________ structured reference.

answer

Fully qualified

question

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

answer

home

question

A collection of fields about one person would be considered a(n) ________.

answer

record

question

Table ________ add color and borders to a table.

answer

style

question

A(n) ________ is a range of organized, related data

answer

table

question

________ page breaks can be inserted if the automatic page breaks would occur atundesirable places.

answer

manual

question

In a data table each row is considered a(n) ________.

answer

record

question

answer

1.d 2.a 3.c 4.e 5.b

question

The Table Styles ________ shows you all the table styles which are available.

answer

gallery

question

answer

1.b 2.e 3.a 4.d 5.c

question

answer

1.b 2.a 3.d 4.e 5.c

question

If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n) ________ sort.

answer

custom

question

The print ________ is the range of cells that will be printed.

answer

area

question

answer

1.e 2.d 3.c 4.a 5.b

question

True or False: Filter arrows are always displayed in data tables.

answer

False

question

True or False: Selecting a range automatically makes it a data table.

answer

False

question

True or False: When you use the Freeze Panes option you freezing both columns and rows.

answer

True

question

True or False: In a data table calculated columns will copy down the table automatically.

answer

True

question

True or False: John Smith is a good example of a field.

answer

False

question

True or False: You can freeze as many columns and rows at the same time as you desire.

answer

True

question

True or False: It is impossible to create a data table from random, unorganized data.

answer

False

question

True or False: After a table has been named, that name can be used in functions instead of cell references.

answer

True

question

True or False: You can select multiple print areas.

answer

True

question

True or False: To print row labels on the left side of each page you would select the row(s) that contain thelabels in the rows to repeat at left box.

answer

False

question

True or False: You can manually adjust a page break by pointing to the page break line and waiting for thefour-headed arrow to appear, then drag the page break to your desired location.

answer

False

question

True or False: This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

answer

True

question

True or False: Excel uses dashed blue lines to indicate manual page breaks.

answer

False

question

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

answer

False

question

True or False: Excel uses solid blue lines to indicate automatic page breaks.

answer

False

question

True or False: Records are individual pieces of information.

answer

False

question

True or False: It is a good practice to print column and row labels on each page.

answer

True

question

True or False: When you enter a structured reference in a formula Excel copies that formula down the rest ofthe column automatically.

answer

True

question

True or False: Rows and/or columns which have been deleted in a data table can be brought back with theUndo command.

answer

True

question

True or False: In Normal view or Page Layout view the data to be printed has a dark blue border.

answer

False

question

True or False: You cannot sort cells by their fill color.

answer

False

question

True or False: Before you freeze panes make sure the active cell is one row above and one column to the leftof the rows and columns you want to freeze.

answer

False

question

True or False: In Page Break Preview, the area to be printed has a light blue background.

answer

False

question

True or False: You can add a row to a data table as long as you put in the row immediately below the table.

answer

True

question

True or False: Locking is the process of making sure that certain rows or columns are visible at all times.

answer

False

question

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

answer

true

question

In Normal view or Page Layout view the data to be printed has a dark blue border.

answer

false

question

You cannot sort cells by their fill color.

answer

false

Excel Chapter 4

Haven't found what you need?