MS Excel Which of the following formulas is not entered correctly? =10+50 =B7+14 10+50 =B7*B1 =10+50 =B7+14 10+50 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar 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 must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What symbol is used before a number to make it a label ? ' (apostrophe) _ (underscore) " (quote) = (equal) ' (apostrophe) _ (underscore) " (quote) = (equal) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS