MS Excel Which of the following Excel screen components can NOT be turned on or off ? Status Bar None Formula Bar Tool Bar Status Bar None Formula Bar Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A collection of related data A division of results A type of chart A cell reference A collection of related data A division of results A type of chart A cell reference ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ * % & $ * % ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Average Sum Max Pmt Average Sum Max 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 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 The sheet tab is changed Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS