MS Excel A circular reference is Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Cell value Formula Both None Cell value Formula Both None ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a reference to the original source application The word document contains a copy of the actual data The word document cannot be edit The word document must contain a hyperlink The word document contains a reference to the original source application The word document contains a copy of the actual data The word document cannot be edit The word document must contain a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Rows Cells Document Columns Rows Cells Document Columns ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS