MS Excel Which menu option can be used to split windows into two View > split Format > window View > window > split Window > split View > split Format > window View > window > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? None of the listed here Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation None of the listed here Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address 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 Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Split command on the window menu Unfreeze panes command on the window menu Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS