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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Press the F2 key Double click the cell Press the Alt key Click the formula bar Press the F2 key Double click the cell Press the Alt key 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? Line Chart Column Chart XY Chart Pie Chart Line Chart Column Chart XY Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Math & Trigonometry Statistical Logical Financial Math & Trigonometry Statistical Logical ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes Formats of cell Deletes selected cells Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell Deletes selected cells Deletes the content of a cell Deletes the comment of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Column letters and row numbers Cell locator coordinates Cell names Column numbers and row letters Column letters and row numbers Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS