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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =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) ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto correct Auto format Auto sum AutoFill Auto correct Auto format Auto sum AutoFill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format All of above Border format Font format Number format All of above Border format Font format ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press the Alt key Press Enter Press Tab None Press the Alt key Press Enter Press Tab None ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Ctrl key Shift key End key Esc key Ctrl key Shift key End key Esc key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS