Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please put questions 1 through 10 into Sheet 1 of an Excel workbook. Use Sheet 2 for Question 11. Upload your file to Canvas. 1.

image text in transcribed
Please put questions 1 through 10 into Sheet 1 of an Excel workbook. Use Sheet 2 for Question 11. Upload your file to Canvas. 1. Create a header for vour spreadsheet that includes: date and time in the right section (automatically entered in a single line with a space in between): file name and sheet name in the center section (automatically entered on two separate lines); and your full name in the left section. 2. Create a Note cell A2 that always appears on the screen. The note should describe in one sentence what your favorite Pullman restaurant is. Use 11-point font for the note. 3. List six famous people from history Cells K2:K7. 4. Put a drop-down list in Cell D2 that contains your list of historical figures. (Make sure that Column D 1s wide enough to contain the longest name in your list.) 5. Create a list box that lies over the cell range E9:F14. Use the same list as the one that you used in Question 3. Have Cell D4 display the chosen name from the combo box. (Put the cell link in G10.) 6. Create a spin button to lie over the cell range B10:B11. The button should generate numbers between 300 and 1300, incrementing by 30 at a time. Put your result in Cell A10. 7. Merge and center Cells H12 and [12. Make the new Cell H11 23-point font. Color the font red. Create a scroll bar that lies over the cell range H13:113. Have the scroll bar cover numbers between 0 and 7000, incrementing by 250. Use a page change of 600. Display the result in Cell H11. 8. Create a group box that lies over the cell range B15:F22. The label for the group box should be \"Date Night\". Have the box contain 4 check boxes labeled, \"Hiking\

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Applied Probability And Random Processes

Authors: Oliver Ibe

1st Edition

0128010355, 9780128010358

More Books

Students also viewed these Mathematics questions