In 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)
View all OSSC TGT Papers >
  1. Ctrl key + ) symbol
  2. Ctrl key + ] symbol
  3. Ctrl key + ` symbol 
  4. Ctrl key + * symbol

Answer (Detailed Solution Below)

Option 3 : Ctrl key + ` symbol 
Free
OSSC TGT: Full Test 1
5.2 K Users
100 Questions 100 Marks 90 Mins

Detailed Solution

Download Solution PDF

The 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.
Latest OSSC TGT Updates

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.
Get Free Access Now
Hot Links: teen patti gold apk download all teen patti master teen patti online teen patti 500 bonus teen patti gold downloadable content