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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The total button The quicktotal button The Formula button The autosum button The total button The quicktotal button The Formula button The autosum button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two View > window > split Window > split Format > window View > split View > window > split Window > split Format > window View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Worksheets Worksheets and charts Charts Workbooks Worksheets Worksheets and charts Charts Workbooks ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS