MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Worksheets and charts Charts Workbooks Worksheets Worksheets and charts Charts Workbooks Worksheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Form Data, Sort Data, Table Data Subtotals Data, Form Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find Both You can Find and Replace within the sheet or workbook None of the listed here Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature All of the listed here Applies a boarder around the selected cells Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells Extends a sequential series of data Automatically adds range of cell values ANSWER DOWNLOAD EXAMIANS APP