1 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 (PC)/Alt D (Mac) 2 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+0 ALT +H+B+P ALT+H+B+R ALT H+B+L 3 What combination of keys turns the value in a cell into a percentage? O cr CTRL+H (PC)/ Command H (Mac) ALT+M (PC)/ Ctrl+ M (Mac) ALT+P (PC)/Ctrl+ P (Mac) ALT + H + P (PC) / Ctrl + Shift + 96 (Mac) 4 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+ M ALT+WQ-Zoom ALT W + ALT +W V+G 5 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+P ALT+M+U ALT MD ALT+M+ N 6 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 +D ALT+ H +L+H+G ALT +H+L+H+L ALT+H+L+H+E 7Which of the following formulas properly produces the string "Income Statement"? Income&Statement - "Income "+"Statement" - "Income"&" "&"Statement -"Income"&'Statement" 8 Suppose today is December 14, 2014. Which of the following functions will NOT return 12/14/2014 as a date? =12/14/2014 =TODAY() DATE(2014,12,14) 2/14/2014 Review Late Project Weight 0.2 0.3 0.1 0.3 0.1 1.0 10,863 3,789 33,572 Total 10 Weighted average ,751 12 Given the above screenshot, which of the following formulas will NOT produce the correct weighted average of 7,751 as in cell D10? SUMPRODUCT(C3:C7,D3:DVSUMIC3 C7) SUMPRODUCTIC3:C7,D3:D7VCB 10 What combination of keys performs the grouping function in Excelt? There are no direct shortcuts on Mac. For Mac users, please refer back to video lectures for PC shortcuts.) ALT A w ALT A v ALT+A Z+N ALT+A+G+G