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 Which is used to perform what if analysis? All of above Solver Scenario Manager Goal seek All of above Solver Scenario Manager Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Clear Delete Delete Clear Contents Clear All Clear Delete Delete Clear Contents Clear All ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain text and data It can contain many sheets including worksheets and chart sheets It can be modified You have to work hard to create it It can contain text and data It can contain many sheets including worksheets and chart sheets It can be modified You have to work hard to create it ANSWER DOWNLOAD EXAMIANS APP