MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 Sheet3!A10 Sheet3.A10 Sheet1!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the edit comment command on the insert menu Click the comment command on the view menu Click the display comment command on the window menu Position the mouse pointer over the cell Click the edit comment command on the insert menu Click the comment command on the view menu Click the display comment command on the window menu Position the mouse pointer over the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? #a#1 A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Cut and Paste Both of above Paste Special > Transpose None of above Cut and Paste Both of above Paste Special > Transpose ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS