MS Excel How do you display current date only in MS Excel? Date () Today () Now () Time () Date () Today () Now () Time () ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts cells having alphabets Counts empty cells Counts cells having number Counts non-empty cells Counts cells having alphabets Counts empty cells Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column latters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column latters and row numbers Column numbers and row letters Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To select a distribution of figures To add shading or color to a cell range To add borders To insert a background To select a distribution of figures To add shading or color to a cell range To add borders ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Value and cell references Values or cell references although not both at the same time Cell references but not values Values but not cell references Value and cell references Values or cell references although not both at the same time Cell references but not values ANSWER DOWNLOAD EXAMIANS APP