MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red All of above Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet Sheet tabs can be colored The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 Xls 123 Wk1 Xlw Xls 123 Wk1 Xlw ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 A1 #a#1 !A!1 $A$1 A1 #a#1 ANSWER DOWNLOAD EXAMIANS APP