MS Excel
Which of the following formulas will Excel not be able to calculate?

=SUM(A1:A5)-10
=SUM(Sales)-A3
=SUM(A1:A5)*0.5
=SUM(A1:A5)/(10-10)

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To center worksheet titles across a range of cells, you must

Format the cells with the comma style
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered

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 select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
From Format Cells dialog box click on Merge Cells check box

ANSWER DOWNLOAD EXAMIANS APP