MS Excel Which of the following is not a valid data type in Excel ? Character Number Date/Time Label Character Number Date/Time Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Shorten the label Decrease the column width Adjust the row height Increase the column width Shorten the label Decrease the column width Adjust the row height Increase the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu 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 Sheet tabs can be colored Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically You can set the column width automatically fit the amount of text Sheet tabs can be colored Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ % * & $ % * ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above 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