MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
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 All of above Use =if() function to format the required numbers red 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 All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Use the word menu bar and toolbars Edit the hyperlink Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Return a formula result Use the addition operator Manipulate values Manipulate labels Return a formula result Use the addition operator Manipulate values Manipulate labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells Justify in Edit > Cells All of above Text Wrapping in Format > Cells Wrap Text in Format > Cells Justify in Edit > Cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS