MS Excel The autofill feature Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data ANSWER DOWNLOAD EXAMIANS APP
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 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 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 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 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 You can check the conditions against ____ when applying conditional formatting Cell value Formula None Both Cell value Formula None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 256 128 1024 16384 256 128 1024 16384 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Data sheet Macro sheet Work sheet Chart sheet Data sheet Macro sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP