MS Excel Which of the following formulas is not entered correctly? 10+50 =B7*B1 =B7+14 =10+50 10+50 =B7*B1 =B7+14 =10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on column right border on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on the column name on column header Double clicking on column right border on column header Double clicking on the column left border of column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button Pressing the Ctrl key and clicking the format painter button Double clicking the format painter button You can use the format painter button on ly one time when you click it Pressing the Alt key and clicking the format painter button 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS