T3.10 and T3.11

In order to create my spreadsheet, I re-created my old spreadsheet (as I could not import the table into Zoho Sheets) and first added the Interest Rate column and labeled it. Next I added a Future Cost column, in which I used a multiplication formula, then dragged down and selected the entire column in order to apply the same formula to the whole column. Next, I used the information in my new Future Cost column to help create another new column, Future Profit, which I created by implementing a formula subtracting cells from the sales column, from the corresponding cell in the Future Cost column. For all formulas I needed to use absolute references ($) for these formulas to work correctly. Finally, I saved my changes and made the view public, and finally experimented with interest rate changes by changing the amount in my Interest Rate cell, which automatically changed values in the rest of my columns. For example, I raised the interest rate to 1.08, which raised future costs, and thus lowered future profits, as would be expected.

T3.10

I had absolutely no problems, the video was great help as were the textbook pages! I originally had a few problems, but after proofreading and a little trial and error, I managed to solve my few slight issues. Here they are:

1. SELECT "Cost", "Region", "Product", "Customer Name" FROM "Sales" WHERE "Customer Name" = 'Mathew Reese'

http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=216137000000008019&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

2. SELECT "Region", "Profit", "Customer Name", "Product", "Date" FROM "Sales" WHERE "Product" = 'Art Supplies'

http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=216137000000008121&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true

3. SELECT "Customer Name" "Cost", "Product", "Date", "Region" FROM "Sales" WHERE "Product Category" = 'Grocery'

http://reports.zoho.com/ZDBDataSheetView.cc?OBJID=216137000000008231&STANDALONE=true&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=true