What is the correct answer?


When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

Correct Answer :

B. Excel edits cell references in the newly copied formula

Related Questions

In a worksheet you can select Which of the following is invalid statement? The auto calculate feature Which function is not available in the Consolidate dialog box? It is acceptable to let long text flow into adjacent cells on a worksheet… Hyperlinks can be Microsoft Excel is a powerful ........... Which of the following is not a basic step in creating a worksheet? You can set Page Border in Excel from The Chart wizard term data categories refers to; How many worksheets can a workbook have? To remove the content of selected cells you must issue ______ command What will be the output if you format the cell containing 5436.8 as #,##0.00'? To activate the previous cell in a pre-selected range, press Which of the cell pointer indicate that you can move the content to other… Which elements of worksheet can be protected from accidental modification The Delete key of keyboard is assigned to which command in Excel? Edit >> Delete command How can you update the values of formula cells if Auto Calculate mode… The autofill feature Which command will you choose to convert a column of data into row? Which of the cell pointer indicates that you can fill series? You want to set such that when you type Baishakh and drag the fill handle,… How many characters can be typed in a single cell in Excel? What is the short cut key to replace a data with another in sheet? Which of the following is the oldest spreadsheet package? Without using the mouse or the arrow keys, what is the fastest way of… What is the correct way to refer the cell A10 on sheet3 from sheet1? You can merge the main document with data source in Excel. In mail merge… How can you remove borders applied in cells?ACC