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 The Delete key of keyboard is assigned to which command in Excel ? All of the listed here Edit > Clear > Contents Edit > Clear >All Edit > Delete All of the listed here Edit > Clear > Contents Edit > Clear >All Edit > Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the latest version of Excel Excel 2016 Excel 2007 Excel 365 Excel XP Excel 2016 Excel 2007 Excel 365 Excel XP ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet Sheet tabs can be colored The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells Wrap Text in Format > Cells Text Wrapping in Format > Cells All of above Justify in Edit > Cells Wrap Text in Format > Cells Text Wrapping in Format > Cells All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > split View > window > split Window > split Review > window View > split View > window > split Window > split Review > window ANSWER DOWNLOAD EXAMIANS APP