Question:
Which of the following is not contained on formula tab on Excel ribbon?
Which of the following is not contained on formula tab on Excel ribbon?
Show Hint
The Formula tab holds Function Library, Defined Names, Formula Auditing and Calculation. Page Layout is a separate tab.
Updated On: Oct 26, 2026
- Page layout
- Function library
- Defined names
- Calculations
Show Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
Step 1: Recall the Excel ribbon:
The Excel ribbon is divided into tabs such as Home, Insert, Page Layout, Formulas, Data, Review and View.
Each tab is divided into groups of related commands.
Step 2: List the groups on the Formulas tab:
Function Library: holds AutoSum, Financial, Logical, Text, Date and Time functions.
Defined Names: holds Name Manager and Define Name.
Formula Auditing: holds Trace Precedents, Show Formulas and Error Checking.
Calculation: holds Calculation Options and Calculate Now.
Step 3: Find the odd one out:
Function library, Defined names and Calculation are all groups of the Formulas tab.
Page layout is not a group of this tab. It is a separate tab with Themes, Margins, Orientation and Size.
Step 4: Explain each option:
(A) Page layout is a tab by itself, so it is not on the Formulas tab. This is the answer.
(B) Function library is a group on the Formulas tab, so it is contained there.
(C) Defined names is a group on the Formulas tab, so it is contained there.
(D) Calculations (the Calculation group) is on the Formulas tab, so it is contained there.
Final Answer:
Page layout is not on the Formulas tab, so the answer is option (A).
The Excel ribbon is divided into tabs such as Home, Insert, Page Layout, Formulas, Data, Review and View.
Each tab is divided into groups of related commands.
Step 2: List the groups on the Formulas tab:
Function Library: holds AutoSum, Financial, Logical, Text, Date and Time functions.
Defined Names: holds Name Manager and Define Name.
Formula Auditing: holds Trace Precedents, Show Formulas and Error Checking.
Calculation: holds Calculation Options and Calculate Now.
Step 3: Find the odd one out:
Function library, Defined names and Calculation are all groups of the Formulas tab.
Page layout is not a group of this tab. It is a separate tab with Themes, Margins, Orientation and Size.
Step 4: Explain each option:
(A) Page layout is a tab by itself, so it is not on the Formulas tab. This is the answer.
(B) Function library is a group on the Formulas tab, so it is contained there.
(C) Defined names is a group on the Formulas tab, so it is contained there.
(D) Calculations (the Calculation group) is on the Formulas tab, so it is contained there.
Final Answer:
Page layout is not on the Formulas tab, so the answer is option (A).
Was this answer helpful?
0
0
Top CBSE CLASS XII Accountancy Questions
From the following Balance Sheet of Hira Ltd. as at 31st March, 2023, prepare Comparative Balance Sheet:
- On 1st May, 2023, Amrit Ltd. issued 10,000, 10% debentures of ₹100 each at a premium of 10%, redeemable at a premium of 10%. Loss on issue of debentures will be:
- Gupta and Sharma are partners in a firm sharing profit in the ratio of 4:1. They admitted Preeti as a new partner for \( \frac{1}{4} \) share in the profits, which she acquired wholly from Gupta. The new profit sharing ratio of Gupta, Sharma, and Preeti will be:
- On the dissolution of a partnership firm, there were debtors of ₹34,000. Debtors of ₹1,000 became bad, and 60% was realized from the remaining debtors. Which account will be debited and by how much amount on the realization from debtors?
- If vendors are issued fully paid shares of ₹1,25,000 in purchase consideration of net assets of ₹1,50,000, the balance of ₹25,000 will be credited to:
View More Questions
Top CBSE CLASS XII Computerised Accounting Questions
- Computerised Accounting System rests on Five Pillars: Data, People, Procedure and _____, _____.
Identify the blank pillars from the following: Which of the following is not a limitation of Computerised Accounting System?
- MS Excel considers which of the following group of mathematical operations to be of equal importance?
- How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between?
- Individual values represented by bars, columns, lines, pie or various forms plotted on a chart are known as:
View More Questions
Top CBSE CLASS XII Questions
- 2, b, c are in A.P. and the range of determinant $\begin{vmatrix}1&1&1\\ 2&b&c\\ 4&b^{2}&c^{2}\end{vmatrix}$ is [2, 16]. Then find range of c is
- A boy of mass 50 kg is standing at one end of a, boat of length 9 m and mass 400 kg. He runs to the other, end. The distance through which the centre of mass of the boat boy system moves is
- A capillary tube of radius r is dipped inside a large vessel of water. The mass of water raised above water level is M. If the radius of capillary is doubled, the mass of water inside capillary will be
- A circular disc is rotating about its own axis. An external opposing torque 0.02 Nm is applied on the disc by which it comes rest in 5 seconds. The initial angular momentum of disc is
- A circular disc is rotating about its own axis at uniform angular velocity \(\omega.\) The disc is subjected to uniform angular retardation by which its angular velocity is decreased to \(\frac {\omega}{2}\) during 120 rotations. The number of rotations further made by it before coming to rest is
View More Questions