MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F8 F9 F11 F10 F8 F9 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Exclamation (!) Hash (#) Apostrophe (') Tilde (~) Exclamation (!) Hash (#) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Both Go to Tools > Options > View tab and mark or remove the check box named Gridline None Click Gridline tool on Forms toolbar Both Go to Tools > Options > View tab and mark or remove the check box named Gridline None ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Enter text and data Copy the worksheet Modifiy the worksheet Save workbook Enter text and data Copy the worksheet Modifiy the worksheet Save workbook ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Values and formulas but not labels Labels, values, and formulas Labels and values but not formulas Formulas only Values and formulas but not labels Labels, values, and formulas Labels and values but not formulas ANSWER DOWNLOAD EXAMIANS APP