Purchase Solution

Inventory Units Purchase Reports

Not what you're looking for?

Ask Custom Question

1. Dana Hirsch, manager of The Waterfront Bistro, has asked you to review the Inventory Units Purchased report and modify it to make it more readable and to view as much data as possible in one window.

2. Make the following changes:
a. Freeze panes so you can scroll the worksheet without losing the column and row headings.
b. Change the zoom so you can view a much of the worksheet as possible to minimize scrolling. Make sure the cells are still readable. (Note:Depending on your monitor size, change the Custom setting to a value between 50% and 80%.)
c. Adjust all column widths to the length of the longest entry. (Autofit)
d. Change the color of the shading behind the title Inventory Units Purchased. You determine the color.
e. Change the font color and the shading color for A2:O2. You determine the colors.
3. Change the page orientation to landscape. (Hint:Do this at the Page Setup dialog box with Page tab selected.)

Purchase this Solution

Solution Summary

The inventory units for purchase reports are examined. The change for zoom for minimizing scrolling worksheets are determined.

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.