Share/Like This Page
Print Instructions

NOTE: Only your test content will print.
To preview this test, click on the File menu and select Print Preview.




See our guide on How To Change Browser Print Settings to customize headers and footers before printing.

Excel Tasks (Continuing Education)

Print Test (Only the test content will print)
Name: Date:

Excel Tasks

Instructions: You've been asked to give advice to a new user of Excel. Below they have listed all of the tasks they need to do with their spreadsheet.

Use the image of an Excel spreadsheet in Question 1 to answer all questions. Describe how each of the tasks could be accomplished and provide all directions in order. Be as specific as possible and where appropriate, use specific cell references (i.e. C3 etc.) in your answer.

1. 
If I want all of the data in the columns to be centered what are the steps I need to take?





2. 
What are the steps I need to take if I want to add the total sales for each row? Describe the fastest way to accomplish this.





3. 
What are the steps I need to take if I want to highlight the sales of Pencils by Andrews in Central.




4. 
I want to combine the text in rows C & D into one cell in Row I with a period in between the new text. Ex. Jones.Pencil








5. 
What are the steps I need to take if I want to add a column between columns E & F? .




6. 
What are the steps I need to take if I want dollar signs to appear next to the values in the Unit Cost Column?



7. 
What are the steps I need to take if I want to add a title centered above the entire spreadsheet?





8. 
What are the steps I would need to take if to sort all of the information by Item rather than by Date?






9. 
What steps would I take if I would like to exclude any sales for items that cost less than 1.99 from this spreadsheet?





10. 
What steps would I take if I would like to hide the column titled Region?



Become a Help Teaching Pro subscriber to access premium printables

Unlimited premium printables Unlimited online testing Unlimited custom tests

Learn More About Benefits and Options

You need to be a HelpTeaching.com member to access free printables.
Already a member? Log in for access.    |    Go Back To Previous Page