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 What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the latest version of Excel Excel 365 Excel 2007 Excel 2016 Excel XP Excel 365 Excel 2007 Excel 2016 Excel XP 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 Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS