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 status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can be modified ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key Shift key End key Ctrl key Esc key Shift key End key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets You can search for bold and replace with italics You can search in formula too You can decide whether to look for the whole word or not You can search by rows or columns or sheets 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
EXAMIANS