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 Which of the following is the oldest spreadsheet package? VisiCalc Lotus 1-2-3 Excel StarCalc VisiCalc Lotus 1-2-3 Excel StarCalc ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must 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 Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns 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 Select the cells containing the title text plus the range over which the title text is to be enfettered Widen the columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above Choose required color on Fill Color tool in Drawing toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 !A!1 #a#1 $A$1 A1 !A!1 #a#1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The organization of individual values with a chart’s data series A chart plot area The data range that supply chart data A horizontal axis The organization of individual values with a chart’s data series A chart plot area The data range that supply chart data A horizontal axis ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS