MS Excel Which of the following is not a worksheet design criterion? Clarity Aditibility Description Efficiency Clarity Aditibility Description Efficiency ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Work sheet Chart sheet Data sheet Macro sheet Work sheet Chart sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Click the Find button on the standard toolbar Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS