MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When no sheet is selected One sheet is selected When many sheets are selected None of the listed here When no sheet is selected One sheet is selected When many sheets are selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Justify in Edit > Cells All of above Wrap Text in Format > Cells Text Wrapping in Format > Cells Justify in Edit > Cells All of above Wrap Text in Format > Cells Text Wrapping in Format > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To delete an embedded objects, first Double click the object Press the Shift + Delete keys Select the object by clicking it Select it and then press the delete key Double click the object Press the Shift + Delete keys Select the object by clicking it Select it and then press the delete key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS