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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Use the addition operator Manipulate values Return a formula result Manipulate labels Use the addition operator Manipulate values Return a formula result Manipulate labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Goal seek Percentage Divide Square Goal seek Percentage Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Formula bar Horizontal scroll bar Standard toolbar Vertical scroll bar Formula bar Horizontal scroll bar Standard toolbar Vertical scroll bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Lotus 1-2-3 Word Smart cell Excel Lotus 1-2-3 Word Smart cell Excel ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Auto fill options Fill series Custom List Fill across worksheet Auto fill options Fill series Custom List Fill across worksheet ANSWER DOWNLOAD EXAMIANS APP