MS Excel How do you display current date and time in MS Excel ? Time() Now () Today () Date () Time() Now () Today () Date () ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place Clicking the formula button None of these Selecting Edit > Edit cell from the menu Double clicking the cell to edit it in place ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Click the Find button on the standard toolbar Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The status bar does not display the cell address An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS