MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Standard Formulas Smart Formula Complex Formulas Array formula Standard Formulas Smart Formula Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will Apply double underline for the active cell None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell None of the listed here Open the font dialog box Fill down in the selection ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 Wk1 123 Xls Xlw Wk1 123 Xls Xlw ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS