0
What else can I help you with?
What is the difference between an relative reference?
absolute reference is the adress or pointer that does not changes while relative reference changes when the target item is moved or the relationship to it has changed
When a formula is copied and pasted from one cell to another Excel automatically changes the cell addresses to reflect the destination location?
relative
When you link to data in a worksheet the data appears as a table in the Access database but is it maintained in its original form in Excel?
The data will be in its original form, but any changes in the data will be reflected in the Excel document, as will changing the Excel document affect the Access table. It is the same data when it is linked, not copied.
What is an object in excel?
Like a picture you have copied from another file
When copying or moving cells if data already exists in the destination cells Excel?
When copying cells in Excel to a destination where data already exists, you can choose to either replace the existing data with the copied data, keep the existing data and not copy over it, or merge the copied data with the existing data. When moving cells in Excel to a destination where data already exists, the original cells will be replaced by the moved cells.
When you paste text it is moved from what?
It comes from where you copied it.
What theme is applied to a chart when it is copied from Excel and pasted into Word?
by default what themes is applied to a chart when it is copies from excel and pasted into word
In Excel when cell references are copied each cell reference that Excel automatically adjusts for the new position is called what?
relative cell address
The place to which a selection is moved or copied?
It is usually referred to as the destination.
What cell reference tells Excel to substitute new cell references within the copied formulas as necessary?
A relative reference in a formula will change when it is copied.
How many cut or copied items can be stored in the Office Clipboard for an Excel worksheet?
24
What cell reference instructs excel to adjust the reference as it copies it to the destination area?
Cell references in a formula don't change if they are moved. Relative references will change if they are copied. Mixed references may change, depending on the type of mixed reference and which direction they are copied.
