MS Excel Which of the following is not a valid data type in Excel ? Character Number Label Date/Time Character Number Label Date/Time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip None of above Small thin plus icon Doctor’s symbol (Big Plus) Mouse Pointer with anchor at the tip None of above Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? 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 Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous A formula that either directly or indirectly depends on itself A cell that points to a drawing object Geometric modeling tool Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS