In Excel, to copy a formula without changing relative references, you can: MCQ with Answer and Explanation

In Excel, to copy a formula without changing relative references, you can:
A. Use Ctrl + R
B. Use Ctrl + ' to copy formula from above
C. Paste exact formula by editing in formula bar, copy, or use absolute references
D. Use Ctrl + D
Answer: Option C
Solution (By JKSSB Mock Tests)
To copy exact formula text, edit cell, select all text, copy. Or use absolute references.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In Excel, the function =MID("EXAMINATION",4,3) returns:
A. INA
B. AMI
C. MIN
D. EXA

Correct Answer: Option C


Explanation:
MID starting at position 4 for length 3: characters 4='A',5='I',6='N'? Wait, EXAMINATION: 1 E,2 X,3 A,4 M,5 I,6 N,7 A,8 T,9 I,10 O,11 N. So position 4 is M, so string M, I, N -> MIN. Yes.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, the 'Row Source' property of a combo box determines:
A. The field where the selected value is stored
B. The default value
C. The SQL query to update records
D. The list of values displayed for selection

Correct Answer: Option D


Explanation:
Row Source provides the data for the list.

This question belongs to: Computer Microsoft Office
Question #3
Which of the following is NOT a valid Excel number format category?
A. Scientific
B. Phone Number
C. Fraction
D. General

Correct Answer: Option B


Explanation:
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.

This question belongs to: Computer Microsoft Office