please dear expert give me all 20 mcsqs corect answer because previous expert give me all 20 mcq answer is wrong and i got makes zero. this is my second try plz plz plz give me all 20 mcqs answr is corect and dear expert i know the chagg policy is only ask 1 question that why this is only mcqs questions i will be very thanksfull to u help me plz and guve me my all 20 answr plz thanks

What combination of keys will autofill highlighted cells to the right? CTRL + R (PC and Mac) CTRL-D (PC and Mac) ALT +R (PC) / Alt + R (Mac) ATL + D (PO/Alt + D (Mac) Page 1 of 20 What combination of keys creates a top border on a cell? (There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT + H+B+P ALT + H+B+L ALT + H+B+R ALT + H+B+ Page 2 of 20 What combination of keys turns the value in a cell into a percentage? ALT + H+ P (PC) / Ctrl + Shift + % (Mac) ALT +P (PC)/Ctrl + P (Mac) CTRL + H (PC) / Command + H (Mac) ALT+M (PC)/Ctrl+M (Mac) Page 3 of 20 What combination of keys removes the gridlines from a spreadsheet? (There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT +W+V+G ALT + W + F ALT+W+Q - Zoom ALT+W+M Page of 20 un If a row is already highlighted, what combination of keys will open the name manager? (There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT +M+D ALT +M+N ALT+M+U ALT + M + P Page 5 of 20 Which of the following combination of keys highlights cells that are greater than a certain number? (There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT + H+ L+H+L ALT +H+L + H+E ALT +H+L+H+D ALT +H+L + H+G Page 6 of 20 Which of the following formulas properly produces the string "Income Statement? = "Income"&" "&"Statement =Income&Statement = "Income"&"Statement" = "Income "+"Statement" Page 7 of 20 ev Page Suppose today is December 14, 2014. Which of the following functions will NOT return 12/14/2014 as a date? =12/14/2014 =TODAYO 12/14/2014 =DATE/2014,12,14) Page 8 of 20 Prev Page Project Weight 0.2 0.3 0.1 NPV 8,530 10,863 3,548 6,842 3,789 33,572 0.3 0.1 Total 1.0 Weighted average 7,751 Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7.751 as in cell D 10? =SUMPRODUCT(03:07.03:07WSUM(C3:07) =SUMPRODUCT(03.07.03:07\/08 -03-03-C4-D4+C5*D5+C6*D6*07*D7708 =08/08 What combination of keys performs the grouping function in Excel? (There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT+A+G+G ALT + A+Z+N ALT + A+W ALT + A +V Suppose the following formula is inputted into Excel =MROUND(1/4,100) The output in the cell will be: 0.25 O 0.2500 Page 11 of 20 Prev Page Product Sales 10 Nminto 780 460 50 mo 2000 350 G 120 =SMALL(CZ C6,4 o Given the above screenshot, suppose =SMALL(C2:C6,4) is entered into cell 09. What output will result from this formula? 780 #NUM: 50 2000 Suppose =IFERROR(5000/2.1000)+100 is entered into a cell. What is the resulting output of this formula? #VALUE! 2600 1100 #NUM! Page 13 of 20 According to the information mentioned in the course, which of the following color schemes is best practice for financial modeling? Hard Codes in Blue, Formulas in Black Hard Codes in Red, Formulas in Black Hard Codes in Black, Hard Codes in Red Hard Codes in Black. Formulas in Blue Page 14 of 20 Which of the following formulas correctly anchors ONLY the row in cell A1? $A$1 A$1 Page 15 of 20 16 What is the result of inputting =IF(5>9,0k, error) into a cell? #NAME? ok error Page 16 of 20 Prev Page What is the correct syntax for the =YEARFRAC function? =YEARFRAC(end_date,start_date) =YEARFRAC{start date.end_date.(basis])! =YEARFRAC(start date) =YEARFRAC(basis.start date, end date) Page 17 of 20 Main Question Set The result of =ROUND(513.2413,2) is Page 18 of 20 Prev Page C 5/14/2017 D E F G H A B 1 Time Periods 2 Anual Data I -DATE YEAR SCST)*G1.12.31) Given the above screenshot, which of the following is the resulting value in cell G2? 12/31/2020 918 9/30/2017 12/31/2019 12/31/2021 Assets 2 Cash 3 Accounts Receivable 4 Inventory 5 Current Assets 6 Property & Equipment 7 Goodwill 8 Total Assets 67,971 5,100 7 805 80,876 45,500 20,000 146,376 10 Liabilities 11 Short Term Debt 12 Accounts Payable 13 Current Liabilities 14 Long Term Debt 15 Total Liabilities 16 Shareholder's Equity 17 Equity Capital 18 Retained Earnings 19 Shareholder's Equity 20 Total Liabilities & Shareholder's Equity 3.902 3,902 50,000 53,902 70.000 2.474 72,474 126,376 - FDS=D20. "OK") 23 19 Shareholder's Equity 20 Total Liabilities & Shareholder's Equity 72,474 126,376 =IF(D8=D20, "OK") Given the above screenshot, what is the resulting value in cell D22? OK ERROR OOOO TRUE FALSE