MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Wrap Text in Format > Cells All of above Text Wrapping in Format > Cells Justify in Edit > Cells Wrap Text in Format > Cells All of above Text Wrapping in Format > Cells Justify in Edit > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top right corner Towards the bottom right corner Towards the bottom left corner Towards the top left corner Towards the top right corner Towards the bottom right corner Towards the bottom left corner Towards the top left corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Enter assumptions data Format cells containing numbers Create and edit formula containing functions Copy a range of cells Enter assumptions data Format cells containing numbers Create and edit formula containing functions Copy a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Delete Edit > Clear > Contents All of the listed here Edit > Clear >All Edit > Delete Edit > Clear > Contents All of the listed here Edit > Clear >All ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP