MS Excel Which of the following is an absolute cell reference? A1 #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel Right clicking something in Excel: Opens a shortcut menu listing everything you can do to the object Selects the object Nothing the right mouse button is there for left handed people Deletes the object Opens a shortcut menu listing everything you can do to the object Selects the object Nothing the right mouse button is there for left handed people Deletes the object ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F8 F11 F9 F10 F8 F11 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar Both of above None of above ANSWER DOWNLOAD EXAMIANS APP