MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F8 F9 F11 F10 F8 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of cell or range currently working on Shows the name of worksheet currently working on Shows the name of workbook currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of worksheet currently working on Shows the name of workbook currently working on None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) None of the listed here Small thin plus icon Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) None of the listed here Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Window > split Format > window View > split View > window > split Window > split Format > window View > split View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS