MS Excel Getting data from a cell located in a different sheet is called ___ Updating Referencing Accessing Functioning Updating Referencing Accessing Functioning 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 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 When a label is too long to fit within a worksheet cell, you typically must Increase the column width Adjust the row height Decrease the column width Shorten the label Increase the column width Adjust the row height Decrease the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel In a worksheet you can select Rows Columns The entire worksheet All of these Rows Columns The entire worksheet All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Data sheet Macro sheet Work sheet Chart sheet Data sheet Macro sheet Work sheet 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? Pie chart Line chart Column chart Row chart Pie chart Line chart Column chart Row chart ANSWER DOWNLOAD EXAMIANS APP