MS Excel Multiple calculations can be made in a single formula using ___ Array formula Smart Formula Standard Formulas Complex Formulas Array formula Smart Formula Standard Formulas Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: Cell B8 only None of these Cells B7 through B9 Cells B7 and cell B9 only Cell B8 only None of these Cells B7 through B9 Cells B7 and cell B9 only ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Exclamation (!) Tilde (~) Apostrophe (') Hash (#) Exclamation (!) Tilde (~) Apostrophe (') Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS