MS Excel What does COUNTA () function do? Counts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cells Counts cells having number Counts empty cells Counts cells having alphabets Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto format Auto sum Auto correct AutoFill Auto format Auto sum Auto correct AutoFill ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? % & * $ % & * $ ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP