MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation 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(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you wrap the text in a cell ? Format, cells, protection Format, cells, alignment Format, cells, font Format, cells, number Format, cells, protection Format, cells, alignment Format, cells, font Format, cells, number 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 The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS