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 The auto calculate feature Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto format Auto sum AutoFill Auto correct Auto format Auto sum AutoFill Auto correct ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? All of above Number format Border format Font format All of above Number format Border format Font format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Horizontal scroll bar Formula bar Standard toolbar Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar Vertical scroll bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Description Aditibility Efficiency Clarity Description Aditibility Efficiency Clarity ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS