Click here for more: Scholars nexus
Excel Chapter 4 Questions with Detailed Verified
Answers
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 the
columns 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 the
new field.
D) You must convert the table back to a range, add the field, then recreate the table.
Ans: You can add it to the right of the data table and Excel will extend the table to
include the new field.
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
Ans: Includes
In conditional formatting what happens if the cell value does not pass the logical test?
© Get it right 2025 Getaway - Stuvia US All rights reserved
,Click here for more: Scholars nexus
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.
Ans: The cell is not formatted
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.
Ans: A colored border appears around that column
If you use the Color Scale conditional formatting, you are limited to how many colors
(and
their gradations?)
A) Unlimited
B) 2 or 3
C) 1,012
D) 256
Ans: 2 or 3
What feature in Excel automatically displays a list of field headings when you begin to
create a
structured reference?
© Get it right 2025 Getaway - Stuvia US All rights reserved
, Click here for more: Scholars nexus
A) Formula AutoComplete
B) Reference AutoComplete
C) AutoComplete
D) Nothing automatically displays a list of field headings.
Ans: Formula AutoComplete
What is the default data table style?
A) Medium 1
B) Medium 2
C) Normal
D) None
Ans: Medium 2
In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?
A) The number of rows to subtotal
B) The row number in which to place the subtotal
C) The COUNT function
D) The SUM function
Ans: The COUNT function
What data does Excel print by default?
A) The entire dataset on the active sheet
B) The entire workbook
C) The selected range of data
© Get it right 2025 Getaway - Stuvia US All rights reserved
Excel Chapter 4 Questions with Detailed Verified
Answers
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 the
columns 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 the
new field.
D) You must convert the table back to a range, add the field, then recreate the table.
Ans: You can add it to the right of the data table and Excel will extend the table to
include the new field.
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
Ans: Includes
In conditional formatting what happens if the cell value does not pass the logical test?
© Get it right 2025 Getaway - Stuvia US All rights reserved
,Click here for more: Scholars nexus
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.
Ans: The cell is not formatted
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.
Ans: A colored border appears around that column
If you use the Color Scale conditional formatting, you are limited to how many colors
(and
their gradations?)
A) Unlimited
B) 2 or 3
C) 1,012
D) 256
Ans: 2 or 3
What feature in Excel automatically displays a list of field headings when you begin to
create a
structured reference?
© Get it right 2025 Getaway - Stuvia US All rights reserved
, Click here for more: Scholars nexus
A) Formula AutoComplete
B) Reference AutoComplete
C) AutoComplete
D) Nothing automatically displays a list of field headings.
Ans: Formula AutoComplete
What is the default data table style?
A) Medium 1
B) Medium 2
C) Normal
D) None
Ans: Medium 2
In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?
A) The number of rows to subtotal
B) The row number in which to place the subtotal
C) The COUNT function
D) The SUM function
Ans: The COUNT function
What data does Excel print by default?
A) The entire dataset on the active sheet
B) The entire workbook
C) The selected range of data
© Get it right 2025 Getaway - Stuvia US All rights reserved
