MS Excel When a row of data is to be converted into columns 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and 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 then go to Cells then on Alignment tab click 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 Comments can be added to cells using Edit > Comments Insert > Comments File > Comments View > Comments Edit > Comments Insert > Comments File > Comments View > Comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? All of above Solver Goal seek Scenario Manager All of above Solver Goal seek Scenario Manager ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto correct Auto format Auto sum AutoFill Auto correct Auto format Auto sum AutoFill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Paste Special > Transpose Cut and Paste Both of above None of above Paste Special > Transpose Cut and Paste Both of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS