MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F8 F9 F11 F10 F8 F9 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel probably considers the cell entry January 1, 2020 to be a Value Text string Formula Label Value Text string Formula Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Smart cell Word Excel Lotus 1-2-3 Smart cell Word Excel Lotus 1-2-3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The status bar does not display the cell address 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? Column chart Line chart Row chart Pie chart Column chart Line chart Row chart Pie chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS