Concept
Find
Calculate
More Calculate
Show
100
What keyboard shortcut makes a table?
cmd/ctrl + t
100
What state does row 950 contain?
Michigan
100
What is the earliest Acquisition Date?
10/30/2016
100
What is the average of the Gross Profit %?
17.16%
100
Make the sheet look cleaner, shrink the number of decimals in the sheet to a maximum of 2
200
If you were to want to find a correlation between sq ft and Gross profit what would you do to visualize it?
Any good answer
200
Are there more half sheets or full sheets?
781 full , 719 half
200
How many rows are there in the spreadsheet?
1,501
200
What percent of Wood Types covered are Oak?
27.40%
200
Use conditional formatting to make all cells with a negative operating profit red
300
What column would you add and why?
Revenue, Expenses, etc as long as the explanation is good
300
How many cells in this sheet contain the string “5.25”?
3
300
What is the sum of the Transaction ID numbers on this sheet?
1,125,750
300
What is the change in operating profit from the 20th entry to the 21st?
-112.05%
300
Create an ascending line chart of the sq ft column
400
What is a possible reason for wanting a return on expense?
Good measure for where to allocate money to maximize returns; estimate future returns; Looks good in a presentation
400
Create a table and sort Operating Profit by descending, what are the first 3 numbers listed?
.3874; .3746; .3718
400
What is the total square foot of Oak construction?
51,151.27
400
What is the difference of the average date of acquisition and the average transaction date?
-45.04 days
400
What type of wood is most commonly used in Minnesota?
Oak
500
Daily Double: What is the name of the external director?
Kayla Sorenson
500
How many days are negative operating profits?
542
500
Assuming construction costs are your only expense what is the operating profit for the first transaction?
$84.52
500
How many transactions are there in 2018? (Based on transaction date)
499
500
What is the R-squared value of Square Feet compared to Gross profit on a linear trendline?
=0.2636