In Excel, to copy a formula without changing relative references, you can: MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In MS Access, which of the following is a valid data type for a field that will store an employee's photo?
Correct Answer: Option D
Explanation:
Both Attachment and OLE Object can store images, but Attachment is newer.
Both Attachment and OLE Object can store images, but Attachment is newer.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In Excel, a cell reference that changes when a formula is copied to another cell is called:
Correct Answer: Option C
Explanation:
Relative references (e.g., A1) adjust based on position. Absolute references ($A$1) stay fixed. Mixed references ($A1 or A$1) are partly fixed.
Relative references (e.g., A1) adjust based on position. Absolute references ($A$1) stay fixed. Mixed references ($A1 or A$1) are partly fixed.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In MS Excel, what is the default keyboard shortcut used to insert a brand-new, empty chart sheet based on the currently highlighted data cells?
Correct Answer: Option D
Explanation:
Pressing F11 creates a new, dedicated Chart Sheet containing a chart generated from the selected cell range. Alt + F1 inserts the chart on the current worksheet.
Pressing F11 creates a new, dedicated Chart Sheet containing a chart generated from the selected cell range. Alt + F1 inserts the chart on the current worksheet.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!