MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel MS Excel provides the default value for step in fill Series dialog box O 10 1 5 O 10 1 5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.8 5430 5436.80 6.8 5436.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP