1. Format the text in cell A5 as follows to make it readable and more meaningful: a. Merge and center the contents of the range A5:A18. b. Rotate the text in the merged cell up so it reads from bottom to top. c. Middle align the merged cell. d. Resize column A to a width of 5.00.
Added by Travis B.
Step 1
Step 1: Select the range A5:A18 by clicking and dragging from cell A5 to A18. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 71 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
Complete the following tasks, then compare your work to the attached solution file. 1. Increase the width of columns B and C to 16 characters. 2. Merge and center the title from Cell A1 to G1. 3. Format the title in cells B3 & C3 as bold and 12-point Times New Roman. 4. Format the numbers with commas and remove all decimal places. 5. Apply cell style Accent 1 to the title in cell A1. 6. Use wrap text for cells B3 & C3. 7. Name the sheet as "Surnames". 8. In cell B19, type "Total" and right-align the text. 9. Create a formula or function in Cell C19 to add all the numbers. 10. Apply a thick bottom border to cells B3 and C3. 11. Change the Page Layout Orientation to Landscape. 12. Create a 3D clustered chart for the data. Do NOT include the totals in your chart! 13. The chart should include a chart title. 14. Position the chart below these instructions. 15. Save your worksheet - use your last name as the file name.
5. You need to format a block of financial information so that the figures are showing the correct currency symbol. How can you do this? Select all options that apply. Click on the Number Format drop-down in the Number group on the Home Ribbon and choose Currency. The currency symbol will need to be typed in the cell with the numbers. Right-click on the cell and choose Format Cells. Click on the currency symbol in the Number group on the Home Ribbon. 6. You are creating a spreadsheet to track new stock. Each product that you are listing will be assigned a category code, which will simply be two letters. You can see that Column G is not wide enough to fully display the heading "Sales Category." As the entries underneath the heading will only ever be two letters, you do not want to widen the column. How can you format the heading so that both words will be visible? Sales Category E F G H I Item Sales Cate Amount Use the Wrap Text feature. Use the Merge Cells feature. Use the Center button in the Alignment group on the Home Ribbon.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD