MS Excel Which menu option can be used to split windows into two ? View > window > split Window > split Review > window View > split View > window > split Window > split Review > window View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Date () Time() Today () Now () Date () Time() Today () Now () ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Aditibility Description Efficiency Clarity Aditibility Description Efficiency Clarity ANSWER DOWNLOAD EXAMIANS APP