MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the drag and drop method to 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 Move cell contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort Data, Form Data, Table ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Sound Recorder Media player Calculator Macro Recorder Sound Recorder Media player Calculator Macro Recorder ANSWER DOWNLOAD EXAMIANS APP
MS Excel Right clicking something in Excel: Opens a shortcut menu listing everything you can do to the object Deletes the object Selects the object Nothing the right mouse button is there for left handed people Opens a shortcut menu listing everything you can do to the object Deletes the object Selects the object Nothing the right mouse button is there for left handed people ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search in formula too You can search for bold and replace with italics You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP