MS Excel Concatenation of text can be done using Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Orientation Margins Headers and Footers Page Break Preview Page Orientation Margins Headers and Footers Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel Right clicking something in Excel: Nothing the right mouse button is there for left handed people Deletes the object Opens a shortcut menu listing everything you can do to the object Selects the object Nothing the right mouse button is there for left handed people Deletes the object Opens a shortcut menu listing everything you can do to the object Selects the object ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Shows the location of the previously active cell Appears to the left of the formula bar Appears below the status bar Appears below the menu bar Shows the location of the previously active cell Appears to the left of the formula bar Appears below the status bar Appears below the menu bar ANSWER DOWNLOAD EXAMIANS APP