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 Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Work sheet Data sheet Macro sheet Chart sheet Work sheet Data sheet Macro sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on the column left border of column header Double clicking on column right border on column header Double click on the cell pointer in worksheet Double clicking on the column name on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 1024 128 16384 256 1024 128 16384 256 ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP