Question
Download Solution PDFIn Microsoft Excel, __________ key combination can be used to display the formulas entered in a cell.
This question was previously asked in
OSSC TGT Official Paper (Held On: 10 Mar, 2023 Shift 3)
Answer (Detailed Solution Below)
Option 3 : Ctrl key + ` symbol
Free Tests
View all Free tests >
OSSC TGT: Full Test 1
5.2 K Users
100 Questions
100 Marks
90 Mins
Detailed Solution
Download Solution PDFThe correct answer is Ctrl key + ` symbol
Key Points
- The "Ctrl key + ` symbol" combination is used to toggle the display of formulas in Excel.
- This feature helps in auditing and debugging formulas entered in the worksheet.
- The ` symbol is usually located on the same key as the ~ symbol, under the Esc key on most keyboards.
- When formulas are displayed, the cells show the actual formula instead of the resulting value.
Additional Information
- Ctrl key + ] symbol: This combination is used to select all cells that directly depend on the active cell's value.
- Ctrl key + * symbol: This combination is used to select the current region around the active cell, which is useful for working with large data sets.
Last updated on Oct 28, 2023
OSSC TGT selects list Out! OSSC TGA Mains results were out on 20th October 2023. The Mains Exam was held on 15th, 21st, 22nd, and 25th September 2023. The Odisha Staff Selection Commission had earlier released the notification for the recruitment of Trained Graduate Teachers (TGT) and Language Teachers in Government schools of Odisha. A total of 6699 vacancies were available. The OSSC TGT selection process will include the Prelims, Mains, and Certificate Verification stages. This is an excellent opportunity for candidates to be part of Government Teaching Jobs in Odisha. Candidates must attempt the OSSC TGT mock tests to check their performance.