Chat with us, powered by LiveChat general business data bank | Gen Paper

Grade Details1. Question:
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.
2. Question:
4) Working with a worksheet that is too large to fit within a single monitor
screen can be confusing for users because ____________.
3. Question:
4) To go to the top of your spreadsheet quickly, use the __________ key(s).
4. Question:
4) To hide a worksheet, it must be:
5. Question:
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
_______________ .

6. Question:
4) Once you have created a table within an Excel worksheet, _________________
can be edited.

7. Question:
4) To put the records in an Excel table into order by last name,
use the:

8. Question:
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 ____________.

9. Question:
4) The process of inserting data from another application into an Excel
workbook is called __________ .

10. Question:
4) To apply a red background color to cells for employees who
have sales greater than $1,000, you can use ______________.

11. Question:
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.

12. Question:
4) Which tab of the Ribbon contains the range name features?

13. Question:
4) To create a PivotChart you must always create a:

14. Question:
4) How do you customize the formatting for a field in a PivotTable?

15. Question:
4) The default summary function used to calculate the Values field in a
PivotTable is ____________ .

error: Content is protected !!