MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Square Percentage Divide Goal seek Square Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Tool Bar None Status Bar Formula Bar Tool Bar None Status Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Enter text and data Save workbook Copy the worksheet Modifiy the worksheet Enter text and data Save workbook Copy the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =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) =SUM(Sales)-A3 =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Both Formula Cell value None Both Formula Cell value None ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS