BUS 1305 Exam 3 Solved 100% Correct
Before you can add subtotals to a data range, what must you first do with the data? -
ANSWER-the data must first be sorted by a field, such as the Office or Dept field
*By default, where does Excel store workbook templates? - ANSWER-Excel will save
the file to the user's Custom Office Templates folder
*Can slicers be moved to any worksheet or external workbook? - ANSWER-yes
*Can slicers be used with both data ranges and Excel tables? - ANSWER-yes
*How do you create a worksheet group consisting of sheets that are not adjacent in a
workbook? - ANSWER-click the sheet tab of one worksheet in the group, press and
hold CTRL, click the sheet tabs of the remaining worksheets in the group, and then
release CTRL
*How do you ungroup a worksheet group that consists of all the sheets in the
workbook? - ANSWER-right-click the sheet tab of one worksheet in the group and then
click Ungroup Sheets on the shortcut menu
*How does Excel indicate that a cell contains linked text? - ANSWER-underline
*If you split the worksheet into panes at cell E3, how many panes are created? -
ANSWER-4
*What are the three freeze pane options? - ANSWER--freeze panes
-freeze top row
-freeze first column
*What does Excel do when a hyperlink is clicked by the user? - ANSWER-opens its
linked resource using the application associated with that resource
*What happens to banded rows in an Excel table when you insert or delete a row? -
ANSWER-they automatically adjust
*What happens to the data they contain? - ANSWER-it remains the same
*What happens to worksheet rows that do not match the filter criteria? - ANSWER-they
are hidden
*What is a field? - ANSWER-where each column in a data range stores a record
containing a group of related field values
*What is a record? - ANSWER-A set of data for the fields in a table
Before you can add subtotals to a data range, what must you first do with the data? -
ANSWER-the data must first be sorted by a field, such as the Office or Dept field
*By default, where does Excel store workbook templates? - ANSWER-Excel will save
the file to the user's Custom Office Templates folder
*Can slicers be moved to any worksheet or external workbook? - ANSWER-yes
*Can slicers be used with both data ranges and Excel tables? - ANSWER-yes
*How do you create a worksheet group consisting of sheets that are not adjacent in a
workbook? - ANSWER-click the sheet tab of one worksheet in the group, press and
hold CTRL, click the sheet tabs of the remaining worksheets in the group, and then
release CTRL
*How do you ungroup a worksheet group that consists of all the sheets in the
workbook? - ANSWER-right-click the sheet tab of one worksheet in the group and then
click Ungroup Sheets on the shortcut menu
*How does Excel indicate that a cell contains linked text? - ANSWER-underline
*If you split the worksheet into panes at cell E3, how many panes are created? -
ANSWER-4
*What are the three freeze pane options? - ANSWER--freeze panes
-freeze top row
-freeze first column
*What does Excel do when a hyperlink is clicked by the user? - ANSWER-opens its
linked resource using the application associated with that resource
*What happens to banded rows in an Excel table when you insert or delete a row? -
ANSWER-they automatically adjust
*What happens to the data they contain? - ANSWER-it remains the same
*What happens to worksheet rows that do not match the filter criteria? - ANSWER-they
are hidden
*What is a field? - ANSWER-where each column in a data range stores a record
containing a group of related field values
*What is a record? - ANSWER-A set of data for the fields in a table
