MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Data sheet Work sheet Macro sheet Chart sheet Data sheet Work sheet Macro sheet Chart sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 1024 256 65535 32767 1024 256 65535 32767 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS