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 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 Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is no suitable abbreviation for the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text Data will be entered in the adjacent cells No data will be entered in the adjacent cells There is not time to format the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? All of above Border format Number format Font format All of above Border format Number format Font format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Smart Formula Complex Formulas Array formula Standard Formulas Smart Formula Complex Formulas Array formula Standard Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search in formula too You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search in formula too You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP