MS Excel Which of the following is not a valid data type in Excel ? Date/Time Label Character Number Date/Time Label Character Number ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F9 F11 F8 F10 F9 F11 F8 F10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Max Average Sum Pmt Max Average Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on column right border on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on column right border on column header Double clicking on the column left border of column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of workbook currently working on Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of workbook currently working on ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS