MS Excel A circular reference is A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool 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 Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Split command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Line Chart Pie Chart XY Chart Column Chart Line Chart Pie Chart XY Chart Column Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? 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 None of the listed here Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? None Tool Bar Status Bar Formula Bar None Tool Bar Status Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: Cells B7 and cell B9 only Cell B8 only None of these Cells B7 through B9 Cells B7 and cell B9 only Cell B8 only None of these Cells B7 through B9 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS