Grade Details1. Question:
(TCO 4) If there are certain columns of information that are not needed at a particular time, but might be needed later, ____________ the unneeded columns to allow users to focus on only the essential information.
(TCO 4) Working with a worksheet that is too large to fit within a single monitor screen can be confusing for users because ____________.
(TCO 4) To go to the top of your spreadsheet quickly, use the __________ key(s).
(TCO 4) To hide a worksheet, it must be:
(TCO 4) If you print a large worksheet that takes up two pages horizontally and two pages vertically, the order in which the pages will be printed is _______________ .
(TCO 4) Once you have created a table within an Excel worksheet, _________________ can be edited.
(TCO 4) To put the records in an Excel table into order by last name, use the:
(TCO 4) To sort a list of employees into alphabetical order by last name, and at the same time put employees with the same last name in order by first name, you can use a ____________.
(TCO 4) The process of inserting data from another application into an Excel workbook is called __________ .
(TCO 4) To apply a red background color to cells for employees who have sales greater than $1,000, you can use ______________.
(TCO 4) When using Excel’s advanced filtering feature, a ____________ is an area apart from a data table that contains conditions used to filter the table.
(TCO 4) Which tab of the Ribbon contains the range name features?
(TCO 4) To create a PivotChart you must always create a:
(TCO 4) How do you customize the formatting for a field in a PivotTable?
(TCO 4) The default summary function used to calculate the Values field in a PivotTable is ____________