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.
Make the following changes:
Freeze panes so you can scroll the worksheet without losing the column
and row headings.
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%.)
Adjust all column widths to the length of the longest entry. (Autofit)
Change the color of the shading behind the title Inventory Units
Purchased. You determine the color.
Change the font color and the shading color for A2:O2. You determine the
colors.
Change the page orientation to landscape. (Hint:Do this at the Page
Setup dialog box with Page tab selected.)
Computer Science Homework Solutions
#55688
Excel S2-P1
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.)
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$3.99)
Included in Download
- Plain text response
- Attached file(s):
- Excel S2-P1.xls
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- A workbook can contain more than one worksheet. - A workbook can contain more than one worksheet. Can you give an example of a spreadsheet application where it would be necessary to have more than one worksheet, can you explain how that works?
- Excel S4-R1 - Excel S4-R1
- Give an example of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer. - Give an example of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer.
- What is the difference between a workbook and a worksheet? - What is the difference between a workbook and a worksheet? Why would you want to use separate worksheets when using Excel? Please give two general examples. Please research and find the method for ...
- Excel - Questions attached regarding making and changing Excel Spread Sheets. (Please find the attached word for questions and make changes to Excel sheet)
