MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Insert handle Border Copy handle Fill handle Insert handle Border Copy handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To select a distribution of figures To add borders To insert a background To add shading or color to a cell range To select a distribution of figures To add borders ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Math & Trigonometry Statistical Financial Logical Math & Trigonometry Statistical Financial ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key Pressing the Esc key Pressing the Tab key Clicking on the formula bar Pressing an arrow key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS