MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is not the function of "Edit, Clear" command? Delete notes Delete contents Delete cells Delete formats Delete notes Delete contents Delete cells Delete formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS