Which key combination inputs today's date directly into Excel?
Show answer Hide answer
Answer: B. Ctrl+;
Explanation
Keyboard shortcuts simplify data entry by automating repetitive tasks like inserting dates. Pressing the control key along with the semicolon instantly inserts the current date. Excel recognizes this specific combination as a command to output static date values. Microsoft Excel provides numerous keyboard shortcuts to accelerate spreadsheet management. Static dates do not change automatically when the system clock updates later. Function keys and modifier combinations form the backbone of efficient spreadsheet navigation.
Financial analysts use date shortcuts constantly when logging daily transaction records. Quick data entry reduces manual typing errors during extensive ledger updates. Knowing quick shortcuts improves overall productivity during professional office work. Ctrl plus colon typically inserts the current system time rather than the date. Adding the shift key alters the shortcut behavior to insert dynamic timestamps instead. Ctrl plus shift plus semicolon serves a different function within Excel formatting.
- Subject
- Computer Science
- Category
- Computer Science
- Topic
- —
- Difficulty
- medium
Related questions
Q1. Which key removes the character located immediately to the right of the cursor in Ms Word?
Show answer Hide answer
Answer: D. Delete
The Delete key explicitly targets and removes characters situated to the right cursor side. Pressing Delete pulls subsequent text backward to fill the newly created empty space. Word processing shortcuts consistently ass...
Q2. Which of the following represents a type of port?
Show answer Hide answer
Answer: D. All of these
Serial, parallel, and AGP are all historical examples of computer hardware ports or connection interfaces. Each of these specialized sockets enabled computers to communicate with external peripherals or expansion cards....
Q3. What is considered a primary drawback of high-level languages?
Show answer Hide answer
Answer: A. Lower efficiency
High-level programming languages often introduce abstraction layers that reduce execution speed. Interpreters or compilers must translate high-level code, which can add overhead. Optimized low-level machine code runs fas...
Q4. Which key is positioned directly between the Ctrl and Alt keys?
Show answer Hide answer
Answer: C. Window
Standard PC keyboard layouts place the Windows logo key right between Ctrl and Alt. Physical key positioning remains standardized across most modern desktop keyboards. The Windows key opens the Start menu when pressed in...
Q5. Which menu contains options for shading text and paragraphs?
Show answer Hide answer
Answer: A. format, borders and shading
Traditional Microsoft Office menu layouts house paragraph background options under Format, Borders and Shading. This comprehensive dialog menu allows users to apply background colors and decorative border lines to text b...
Q6. Which key activates cell editing mode in Excel?
Show answer Hide answer
Answer: C. F2
Microsoft Excel assigns the F2 function key to activate active cell editing mode. Pressing F2 places the text cursor directly inside the selected spreadsheet cell. This shortcut allows users to modify existing cell conte...