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) =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 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 How can you remove borders applied in cells ? Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Choose None on Border tab of Format cells None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates you that you can make selection? Small thin plus icon Doctor’s symbol (Big Plus) None of above Mouse Pointer with anchor at the tip Small thin plus icon Doctor’s symbol (Big Plus) None of above Mouse Pointer with anchor at the tip 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 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
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? XY Chart Line Chart Pie Chart Column Chart XY Chart Line Chart Pie Chart Column Chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS