MS Excel Which menu option can be used to split windows into two Window > split Format > window View > window > split View > split Window > split Format > window View > window > split View > split ANSWER DOWNLOAD EXAMIANS APP
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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters Concatenate and manipulate text Show formula error value Replace cell references Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Accessing Referencing Updating Functioning Accessing Referencing Updating Functioning ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing spacebar Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard Pressing spacebar Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formulas All of above Validation Formats Formulas All of above Validation Formats ANSWER DOWNLOAD EXAMIANS APP