BUS 1350 – Exam 2, 2026 – Study guide and practice material
what type of filter should you use when you want to display records that meet And / OR
conditions? - correct answer ✔✔ Advanced filter
after adding data to a table where a filter is applied, what should you do to filter the new data?
- correct answer ✔✔ reapply the filter
when you insert a table, it is organized into rows of data called ___________. - correct answer
✔✔ records
which of the following is a way to make a table accessible ? - correct answer ✔✔ enter a
descriptive table name
an excel table contains columns named Salary and Commission. Which of the following formulas
uses a structural reference to add the values in the Salary column to the values in the
Commission column? - correct answer ✔✔ =[Salary]+[Commission]
ursula wants to freeze the header row so that it remains visible while she scrolls down the
worksheet. to do so, she can click the view tab and then click freeze top row. - correct answer
✔✔ true
Boris is displaying two instances of the same workbook and wants to remove one. Which button
should he click on the View tab? - correct answer ✔✔ Hide
Carol wants to redisplay a workbook window she had hidden earlier. Which button should she
click on the
View tab? - correct answer ✔✔ Unhide
, Myra right clicks the benefits sheet tab then clicks hide on the shortcut menu. what is the
result? - correct answer ✔✔ the benefits worksheet is hidden
when you lock a cell, it is hidden in the worksheet. true or false - correct answer ✔✔ false
Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt
look more distinctive? - correct answer ✔✔ apply a smart art style
Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the
SmartArt to group blocks of information in a pyramid. What should he do? - correct answer ✔✔
change the layout
Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He
also wants a picture he inserted to fit the worksheet design. Which of the following should he
do? - correct answer ✔✔ add a blue border
Brielle wants to increase the width of SmartArt but not its height. Which of the following should
she do? - correct answer ✔✔ drag the middle sizing handle on the right
What happens when you drag a corner handle on SmartArt? - correct answer ✔✔ you resize the
SmartArt proportionally
how can you change the data displayed in the PivotTable - correct answer ✔✔ edit the data
source and then refresh the PivotTable
a _________ is a graphic object you can use to filter data in a PivotTable - correct answer ✔✔
slicer
What happens if you select the City and Product Type check boxes in the Insert Slicers dialog
box? - correct answer ✔✔ you add the City and Product Type to the worksheet
what type of filter should you use when you want to display records that meet And / OR
conditions? - correct answer ✔✔ Advanced filter
after adding data to a table where a filter is applied, what should you do to filter the new data?
- correct answer ✔✔ reapply the filter
when you insert a table, it is organized into rows of data called ___________. - correct answer
✔✔ records
which of the following is a way to make a table accessible ? - correct answer ✔✔ enter a
descriptive table name
an excel table contains columns named Salary and Commission. Which of the following formulas
uses a structural reference to add the values in the Salary column to the values in the
Commission column? - correct answer ✔✔ =[Salary]+[Commission]
ursula wants to freeze the header row so that it remains visible while she scrolls down the
worksheet. to do so, she can click the view tab and then click freeze top row. - correct answer
✔✔ true
Boris is displaying two instances of the same workbook and wants to remove one. Which button
should he click on the View tab? - correct answer ✔✔ Hide
Carol wants to redisplay a workbook window she had hidden earlier. Which button should she
click on the
View tab? - correct answer ✔✔ Unhide
, Myra right clicks the benefits sheet tab then clicks hide on the shortcut menu. what is the
result? - correct answer ✔✔ the benefits worksheet is hidden
when you lock a cell, it is hidden in the worksheet. true or false - correct answer ✔✔ false
Colin inserted SmartArt using an Organizational Chart layout. How can he make the SmartArt
look more distinctive? - correct answer ✔✔ apply a smart art style
Sam inserted SmartArt arranged as a horizontal series of shapes. He wants to change the
SmartArt to group blocks of information in a pyramid. What should he do? - correct answer ✔✔
change the layout
Isaac formatted a worksheet so that all the cells with data or formulas have blue borders. He
also wants a picture he inserted to fit the worksheet design. Which of the following should he
do? - correct answer ✔✔ add a blue border
Brielle wants to increase the width of SmartArt but not its height. Which of the following should
she do? - correct answer ✔✔ drag the middle sizing handle on the right
What happens when you drag a corner handle on SmartArt? - correct answer ✔✔ you resize the
SmartArt proportionally
how can you change the data displayed in the PivotTable - correct answer ✔✔ edit the data
source and then refresh the PivotTable
a _________ is a graphic object you can use to filter data in a PivotTable - correct answer ✔✔
slicer
What happens if you select the City and Product Type check boxes in the Insert Slicers dialog
box? - correct answer ✔✔ you add the City and Product Type to the worksheet
