MS Excel Which of the following formulas will Excel not be able to calculate? =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 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK 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 Font format Border format Number format All of above Font format Border format Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Files created with Lotus 1-2-3 have an extension WK1 XLS Doc 123 WK1 XLS Doc 123 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. File Insert View Tools File Insert View Tools ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and select Edit >Row from the menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar All of the listed here ANSWER DOWNLOAD EXAMIANS APP