MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed 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 To center worksheet titles across a range of cells, you must 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 Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns 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 Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Column Chart XY Chart Line Chart Pie Chart Column Chart XY Chart Line Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top right corner Towards the bottom left corner Towards the bottom right corner Towards the top left corner Towards the top right corner Towards the bottom left corner Towards the bottom right corner Towards the top left corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel Microsoft Excel is a powerful ___ Communication S/W package Word processing package DBMS package Spreadsheet package Communication S/W package Word processing package DBMS package Spreadsheet package ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The cells selected are marked for cutting ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS