MS Excel Which function is not available in the Consolidate dialog box ? Max Sum Pmt Average Max Sum Pmt Average 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 Which language is used to create macros in Excel? Java Visual Basic C Visual C++ Java Visual Basic C Visual C++ ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The data range that supply chart data The organization of individual values with a chart’s data series A horizontal axis A chart plot area The data range that supply chart data The organization of individual values with a chart’s data series A horizontal axis A chart plot area ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS