MS Excel A numeric value can be treated as label value if ___ precedes it. Apostrophe (') Tilde (~) Exclamation (!) Hash (#) Apostrophe (') Tilde (~) Exclamation (!) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When no sheet is selected When many sheets are selected One sheet is selected None of the listed here When no sheet is selected When many sheets are selected One sheet is selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet None of above Both of above Select the sheet then choose Format > Sheet > Hide ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar 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 apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS