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 status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references Show formula error value Concatenate and manipulate text Return ASCII values of characters Replace cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Line chart Column chart Row chart Pie chart Line chart Column chart Row chart Pie chart 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 The data range that supply chart data A chart plot area A horizontal axis The organization of individual values with a chart’s data series The data range that supply chart data A chart plot area A horizontal axis ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature All of the listed here Automatically adds range of cell values Applies a boarder around the selected cells Extends a sequential series of data All of the listed here Automatically adds range of cell values Applies a boarder around the selected cells Extends a sequential series of data ANSWER DOWNLOAD EXAMIANS APP
MS Excel To edit in an embedded excel worksheet object in a word document Use the word menu bar and toolbars Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Edit the hyperlink Use the word menu bar and toolbars Edit the data in a excel source application Use the excel menu bar and toolbars inside the word application Edit the hyperlink ANSWER DOWNLOAD EXAMIANS APP