Exploring Programming | Academics | Middle School | The American School in Japan

Exploring Programming Excel Quiz

Due at the end of class.

 

1. The linked spreadsheet  is a small portion of a spreadsheet that I created years ago to determine how much commission I would be charged on stock transactions. Do the following tasks in this file:
1. Create a new worksheet.
2. Put it at the extreme right of the other worksheets.
3. Name the worksheet “Quiz 1”.
4. Write the words “My First Name” in cell A1, “My Last Name” in cell A2, and “My Full Name” in cell A3.
5. Name cells B1, B2, and B3 “My_First_Name” and “My_Last_Name”, and “My_Full_Name” respectively.
6. Put your names in B1 and B2.
7. In cell B3, put a function that will concatenate the contents of cells B1 and B2. Note: your function must refer to the cell names, “My_First_Name” and “My_Last_Name”, not to B1 and B2.
2. Save the file in the specified location with your last name as the file name.

   Now, create a new web page and answer the following questions: You may cut and paste the questions below.

    

3. Choose an error message that begins with “#” and explain it in your Microsoft Word document.
4. Explain what the formula in cell G2 does on the “Total Stock Cost” Worksheet does.
5. Look in the help file and choose a function you have not used before and give an example of how it works. If you can’t get the function to work, write a one or two line summary below your example that explains where you are having trouble.)
6. Extra Credit: Explain what the formula in cell I2 on the “Total Stock Cost” worksheet does.