Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started