Blog

Which describes viral marketing?

(Excel) Consider this Excel table, which is named AirTurbines. To calculate the total Maintenance cost for Honeywell, which would NOT be appropriate?

Which is FALSE regarding information technology and systems use in sustaining competitive advantage

(Excel) The data below lists individual sales of fruit. Cell C7 contains the smallest sales quantity for Lemons. This value is displayed in cell F2. Which would be the formula in F2?

(Excel) In this example, students with a score 65 or above receive a Pass result, otherwise a Fail. However, students without a submission (no score recorded) will receive an Incomplete as a result.   Which of these formulas would be found in cell D3?

(Excel) A 2-D (2 variable) Data Table has been created in the range E2:J7. Currently, the cell I4 is selected (and conveniently highlighted.) After having used Excel to create the data table, which would be the formula in cell I4?  

(Excel) Consider the following Excel data:   The formula in cell B4 is: =IF(COUNTIF(B2:C2,”>”&D2)=0, D2, IF(B2>C2,C2,B2)) What is the output in cell B4?

Information systems have been defined as socio-technical organizational systems made up of five components. Which is NOT one of the five?

(Excel) Using EXCEL to do some calculating, suppose today you have $1,000 in your savings account. If the yearly interest rate is r, then your savings balance in n years will be 1000(1+r)n (Hint: the formula written in Excel would be “=1000*(1+r)^n” ). Now we want to see how the savings balance would differ if the interest rate r and the number of years n vary. Consider the following example in Excel.     You must key a formula in cell C3, and then copy and paste it by dragging the lower right corner to all the other rows and columns of the table. Which of these is the appropriate formula for cell C3 with the correct use of relative and/or absolute cell references that would allow you to copy-paste the formula to the other cells such that the addresses for rows and columns gets updated automatically?

Which is TRUE about advice given to firms who would aspire to digital disruption?