MS Excel Multiple calculations can be made in a single formula using ___ Standard Formulas Array formula Smart Formula Complex Formulas Standard Formulas Array formula Smart Formula Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Max Average Pmt Sum Max Average Pmt 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? Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment 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? Both 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 None of above Both 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 None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =B7+14 10+50 =10+50 =B7*B1 =B7+14 10+50 =10+50 =B7*B1 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS