MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references Values or cell references although not both at the same time Values but not cell references Cell references but not values Value and cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column letters and row numbers Column numbers and row letters Cell locator coordinates Cell names Column letters and row numbers Column numbers and row letters Cell locator coordinates Cell names ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Use the word menu bar and toolbars Hyperlinked placed in a word table Linked Embedded Use the word menu bar and toolbars Hyperlinked placed in a word table Linked Embedded ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will None of the listed here Fill down in the selection Apply double underline for the active cell Open the font dialog box None of the listed here Fill down in the selection Apply double underline for the active cell Open the font dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS