MS Excel Which menu option can be used to split windows into two View > split View > window > split Window > split Format > window View > split View > window > split Window > split Format > window ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 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 row, select the same number of cells in row and paste 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 Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual C++ C Visual Basic Java Visual C++ C Visual Basic Java ANSWER DOWNLOAD EXAMIANS APP
MS Excel In a worksheet you can select The entire worksheet All of these Rows Columns The entire worksheet All of these Rows Columns ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS