BUS 1350 EXAM 2 QUESTIONS &
CORRECT PASSED ANSWERS
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
CORRECT PASSED ANSWERS
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
