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 doesn’t adjust relative cell references

Correct Answer: Excel edits cell references in the newly copied formula

When you copy a formula Excel edits cell references in the newly copied formula.
Bissoy MCQ
#Computer Fundamentals #MS Excel

Related Questions

At a photocopy center , the first 10 copies cost x taka each. Each of the next 50 copies costs 2 taka less per copy . From the 61 st copy on, the cost 1 Taka per copy, In terms of x how much does it cost in. Taka to have 200 copies made/
A 10x+240
B 50x-10
C 50(x-5)
D 60x+140
A machine can copy six pages in 9 seconds. How many pages can it copy in 24 minutes?
A 12
B 16
C 36
D 960
One copy machine can make 20 copies a minute , and a second copy machine makes 15 copies a minute. If the two copiers work together, how long would it take them to make 2100 copies?
A 60 minutes
B 105 minutes
C 122 minutes
D 140 minutes
One copy machine can make 20 copies a minute, and a second copy machine makes 15 copies a minute. If the two copies work together, how long would it take them to make 2100 copies?
A 60 minutes
B 105 minutes
C 122 minutes
D 140 minutes
You are the administrator of contoso.local domain. You organize the domain into organizational units as shown in the EXHIBIT. You configure the local security options and other settings for the default domain policy object You delegate administration of Michigan and Florida OU. You want to prevent those administrators from creating any other group policy objects with settings that conflict with those you configured.What should you do?
A From the group policy options from the contoso.local domains set the option not override
B From the group policy options from the Michigan and Florida OU, set the option not override
C Block the group policy inheritance for the contoso.local domain
D Block the group policy inheritance for Michigan and Florida OU
E None of above
In MS Excel, which of the following can be used to copy the value of a cell to another where the value of the source cell was derived through a formula?
A Copy, Value
B Paste, Value
C Copy, Paste Special, Value
D Copy, paste, value
In MS Excel, which of the following can be used to copy only the value of a cell to another where the value of the source cell was derived through a formula?
A Copy, Value
B Paste, Value
C Copy, Paste Special, Value
D Copy, Paste Value
Which of the following features allow you to combine a form letter with the contents of a database(usually a name and address file), creating a separate copy of the letter for each entry in the database?
A Letter Wizard
B Mail Merge
C Document Map
D Book Mark
Which of the following features allow you to combine a form letter with the contents of a database (usually a name and address file), creating a separate copy of the letter for entry in the database?
A Letter Wizard
B Mail Merge
C Document Map
D Book Mark
You copy a configuration from a network host to a router's RAM. The configuration looks correct, yet it is not working at all. What could the problem be?
A You copied the wrong configuraion into RAM
B You copied the configuration into flash memory instead
C The copy did not override the shutdown command in running-config
D The IOS became corrupted after the copy command was initiated

Next steps