29 Questions. How cheap of a price can they be?1) A _____ list is preferred by most people because they think it is easier to read.A) Horizontal B) Vertical C) Bulleted D) Numbered2) To select all blank cells in a list, use the Special menu. Which shortcut opens the Go To menu that contains the Special button?A) Esc B) F1 C) F5 D) Ctrl + Esc3) Write a formula to return the first three characters and the last three characters in cell J1.A) Left(3)&Right(3) B) Left(3,J1)&Right(3,J!) C) Left(J1,3)+Right(J1,3) D) Left(J1,3)&Right(J1,3)4) Write a CHOOSE function that will determine whether a date in cell A1 occurs on a weekday or weekend.A) WEEKDAY(CHOOSE(A1),"Weekend","Weekday","Weekday",Weekday","Weekday","Weekday","weekend") B) CHOOSE(A1,"Weekend","Weekday")C) CHOOSE(WEEKDAY(A1),Weekend,Weekday,Weekday,Weekday,Weekday, Weekday,Weekend)D) CHOOSE(WEEKDAY(A1),"Weekend","Weekday","Weekday","Weekday","Weekday","Weekday","Weekend")5) An IF statement nested within another IF statement will produce how many possible results?A) two B) three C) four D) one6) Cell E1 contains the date 8/22, and cell E2 contains the date 10/21. What is the result of DATEDIF(E1,E2"m")?A) 2 B) 1 C) 12 D) 07) The EDATE function requires two arguments. Which type is the second argument?A) hours B) years C) days D) months8) Use the IFS function to return 5 if cell A5 contains the value 3, and return a 6 if it contains any other number.A) IFS(A5=3, 5, 1, 6 B) IFS(A5=3, ELSE 6) C) IFS(A5=3, 5, 0, 6) D) IFS(A5=3, 5, 6)9) Create a formula that will return the data in the last cell in column A that is not blank.A) OFFSET(A1,COUNTA(A:A)-1.0) B) OFFSET(A1,COUNTA(A:A)-1) C) OFFSET(A1,COUNTA(A:A)) D) OFFSET(A1,COUNTA(-1),0)10) Which two-digit year will Excel identify as in the twenty-first century and not the twentieth?A) 88 B) 25 C) 31 D) 4511) An employee worksheet lists employee names in column A and their salaries in column B. Which formula shows the total payroll, and will not need to be changed if the list gets larger or smaller?A) SUM(B:B) B) SUM(B:END) C) SUM(B) D) SUM(B1:B)12) What will be displayed with the formula DATE(2020,13,15)?A) 44150 B) 44211 C) 44180 D) #VALUE13) All range names are _____ addresses.A) absolute B) initial C) relative D) reference14) Which MOD formula will return 2?A) MOD(28,5) B) MOD (25,5) C) MOD(12,5) D) MOD(10,5)15) Your boss asks you to generate a random number between 0 and 100. Which formula will provide this result?A) RANDM(0,100) B) RANDOM(0,100) C) RANDBETWEEN(00, 100) D) RANDARRAY(0,100)16) To aggregate using the average, the first argument in the AGGREGATE formula should be _____.A) 1 B) 9 C) AVERAGE D) AVG17) What is the keyboard shortcut for the Show Formulas button?A) Ctrl+S B) Ctrl_Tilde C) Ctrl+F D) Ctrl_Esc18) Which formula returns an error if the argument passed to it is greater than 3999?A) LATIN B) ROMAN C) GREEK D) ARABIC19) Which formula will return the number of blank cells in cells A1:A100?A) COUNTBLANK(A:A) B) COUNTBLANK(A) C) COUNTBLANK(A, 1:100) D) COUNTBLANK(A1:A100)20) Cell C1 contains an employee salary. Write an Excel formula to round the salary to the nearest $100.A) ROUNDUP(C1, -2) B) ROUND(C1,2) C) ROUND(C1,100) D) ROUND(C1,-2)21) Which function will return TRUE if cell G7 is blank?A) ISTEXT(G7) B) ISNA(G7) C) ISNONTEXT(G7) D) ISNUMBER(G7)22) Which function returns TRUE if cell A1 contains a #N/A error?A)ISERR(A1) B) ISLOGICAL(A1) C) ISERROR(A1) D) ISFORMULA(A1)23) An employee list shows salaries in column B and the number of years worked in column C. Write a formula to find the lowest salary for employees who have worked longer than five years.A) MINIFS(B:B,C:C,5) B) MINIFS(B:B,5,C:C) C) MINIFS(C:C,5,B:B) D) MINIF(B:B,C:C,5)24) The ISFORMULA function can be used with _____ to highlight all cells in a worksheet that contain a formula.A) Formal Painter B) Fill C) Conditional Formatting D) Styles25) When using SUMIFS, why is it a good idea to use entire column references?A) Excel can scan an entire column faster B) The function will not need to be changed as the criteria list grows or shrinks.C) Using an entire column reduces the potential for error. D) The function only works with entire columns or rows.26) What is the TRIM function used for?A)To shrink text B) to remove all spaces between words C) to remove characters from the end of a string D) to remove leading and trailing spaces27) With the TEXTJOIN function, use a _____ delimiter to combine text from multiple cells.A) comma B) tab C) space D) period28) Which Excel function capitalizes only the first letter in someone's name?A) UPPER B) TRIM C) LOWER D) PROPER29) Cell D4 contains a ten-digit phone number with hyphens after the third and sixth digits. Which function will remove the hyphen after the sixth digit?A) SUBSTITUTE(D4,"-",2) B) REPLACE(D4,"-","") C) SUBSTITUTE(D4,"-","",2) D) REPLACE(D4,"-",""2)

Beazer homes was the sixth largest U.S. home builder during the 1998-2006 housing boom.  Like other major home builders, Beazer’s market value grew by a factor of 8-10 during that period.  However, the new home market slowed in 2006 and then collapsed in 2007. The SEC alleged that Michael T. Rand, Beazer’s chief accounting officer, understated Beazer’s reported profits in every quarter but one from 2000 through 2005 by understating Beazer’s “land inventory” account and by overstating its “cost to complete” reserve.  The SEC further alleged that during each of the four quarters in 2006, and in the first quarter of 2007, Mr. Rand increased Beazer’s reported profits by increasing the “land inventory” account, decreasing the “cost to complete” reserve, and fraudulently recording sale-and-leaseback transactions for model homes. The case provides an excellent overview of the U.S. housing boom and collapse.  It can be used prior to New Century Financial Corp (Chapter 3), which covers the collapse of a sub-prime and Alt A mortgage lender.  The case is also excellent for covering the practical issues of accrual accounting in uncertain environments. The SEC charges imply that it is relatively simple to estimate the value of the firm’s “land inventory” and “cost to complete” accounts.  When a home builder acquires land for a new housing development, some land is set aside for streets and sidewalks, some for parks or lakes, and some for open space near busy roads.  The builder then subdivides the remaining land into lots it hopes to sell.  Lots near a park or lake are more desirable, while lots near the entrance to a subdivision are typically less desirable.  Someone assigned a cost of the land to individual lots, and that assignment process is clearly arbitrary.  In addition, as the property becomes more or less desirable, the remaining land becomes more or less valuable than when the firm first estimated the value of each lot.  The SEC’s complaint made the valuation process seem far more objective than it is in practice. The cost-to-complete reserve covers the cost to complete sold homes.  That includes, for example, cracked driveways or basement floors, leaking faucets, roofs, or windows, or faulty painting or landscaping.  The average cost per home might be $5,000 or $10,000, depending on the home cost and the history of the development.  After 6-12 months, the allowance for a particular home might be reduced to zero as the warranty expired or as the likelihood of claims declined.  The SEC complaint made that valuation process seem far more objective than it is in practice, particularly for a rapidly growing firm that almost certainly was relying on less experienced managers and workers, and less experienced accountants. The case also covers a sale-and-leaseback transaction.  Those accounting rules are complex, so again, it might not be clear that Mr. Rand engaged in fraud. Finally, the cumulative alleged profit understatement for 2000-2005 was about $72 million for a firm that had about $2 billion of operating profits.  In addition, during nine quarters from 2007-2009, Beazer recorded about $1 billion of impairment charges.  Given the implicit subjectivity in those nine impairment charges, it seems highly likely that the “land inventory” and “cost to complete” accounts were also highly subjective numbers. I use this case to consider the subjectivity of various accrual accounts.  I also use it to consider who would make the accrual calculations.  Beazer constructed housing developments throughout the nation.  Michael T. Rand almost certainly was not personally responsible for preparing accrual estimates at the operating level. For each of the accounting issues discussed in the body of Case 9: Discuss whether it seems likely that Dell recorded the transaction improperly to manipulate results or whether it was more likely an honest mistake (e.g., Dell did not know about the rule; the implementation relied on judgment and the investigators had the benefit of hindsight; or the sheer volume of low-value orders Dell ships each day makes it very difficult to properly implement these detailed rules). Discuss whether the error addressed in Part 1 of this discussion is material and should have been disclosed. Review the accounting changes and internal control procedures that Dell proposed, and evaluate those changes in terms of their probable costs and benefits Please make sure that the bullet point and solution is together and that the solution is at least a paragraph long