Need Help With Excel Project, Please. Thank you.?

Question

3. Add a new worksheet and place it in front of the Accounting worksheet. Name the sheet “Summary.” Important: the file P4.gif downloaded above previews the worksheet Summary you will create that displays a count of males and females for all students in the junior and senior class. Make sure to develop the formulas to generate this table by using ONLY 3-D references to summarize the individual worksheets.
4. In the cell in which you entered the title “All Students,” add the comment “Counts are based on full-time students – 12 or more credits.” Set the comment so it is only visible when your mouse hovers over the cell.
5. You want a way to quickly jump to each worksheet from the Summary worksheet. Enter “Majors” in cell F2, and then enter the name of each worksheet in the range F3:G11. Use this list to create hyperlinks to the corresponding worksheets. For example, if the user clicks Accounting, then the Accounting sheet becomes the the active sheet.

6. In cell B* of the Summary worksheet, type the name of your institution and then insert a hyperlink from this label to your institution's Web page. Add a Screen Tip of your choosing to this hyperlink.

Answer 1

3. To add a new worksheet, right click the tab of a worksheet that will be after the one you are adding and select on Insert. To rename a worksheet, double click the tab, or right click the tab and select Rename. In Excel 2007, you can add a new worksheet by clicking the Insert Worksheet tab (it has a yellow star on it).

4. Comments are added by right clicking the cell and selecting Insert Comment. By default, comments only show up when you hover over the cell. If you right click and select Show/Hide Comments, the comment will appear even if you're not hovering over the cell.

5. For hyperlinks, type out the names that you want, one to each cell. Now, right click one of the cells and select Hyperlink. In the dialog box, you can link to web pages, documents, or places in the current worksheet. You'll have to link all of your worksheets individually.