MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Choose None on Border tab of Format cells Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None Choose None on Border tab of Format cells Both Open the list on Border tool in Format Cell toolbar then choose first tool (none)) None 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 AutoFill Auto sum Auto format Auto correct AutoFill Auto sum Auto format ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Linear Growth Time Autofill Linear Growth Time Autofill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Files created with Lotus 1-2-3 have an extension 123 WK1 Doc XLS 123 WK1 Doc XLS ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP