MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Calculator Media player Sound Recorder Macro Recorder Calculator Media player Sound Recorder Macro Recorder ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two View > split Window > split View > window > split Format > window View > split Window > split View > window > split Format > window ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color form Patterns tab of Format Cells dialog box ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS