MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 All of above Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Divide Square Percentage Goal seek Divide Square Percentage Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key End key Ctrl key Shift key Esc key End key Ctrl key Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS