MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Average Max Sum Pmt Average Max Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the drag and drop method to Move cell contents Add cell contents Copy cell contents Copy cell contents & Move cell contents Move cell contents Add cell contents Copy cell contents Copy cell contents & Move cell contents ANSWER DOWNLOAD EXAMIANS APP
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 sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address 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 > Delete Edit > Clear >All All of the listed here Edit > Clear > Contents Edit > Delete Edit > Clear >All ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Headers and Footers Page Orientation Page Break Preview Margins Headers and Footers Page Orientation Page Break Preview Margins ANSWER DOWNLOAD EXAMIANS APP