MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments put in cells are called Cell Tip Web Tip Soft Tip Smart Tip Cell Tip Web Tip Soft Tip Smart Tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Hash (#) Exclamation (!) Apostrophe (') Tilde (~) Hash (#) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Font format Number format All of above Border format Font format Number format All of above Border format ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP