MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ * % & $ * % ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? $A$1 !A!1 #a#1 A1 $A$1 !A!1 #a#1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the format painter multiple times before you turn it off by Pressing the Alt 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 Ctrl key and clicking the format painter button Pressing the Alt 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 Ctrl key and clicking the format painter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS