Which of the following shortcut key is used to repeat the last command or action, if possible, in MS-Excel 365?
- A.Ctrl + Z
- B.Shift + Z
- C.Ctrl + Y
- D.Shift + Y
Correct answer
Explanation
The correct answer is C, Ctrl + Y. In MS Excel 365, Ctrl + Y repeats the last command or action wherever repeating it is possible, so if you have just made a cell bold or inserted a row, pressing Ctrl + Y does the same thing again at the new position. It also works as Redo, undoing an undo, because Excel treats the two as one key. The function key F4 does the same repeat job in Excel, which is why it is popular for copying formatting down a sheet. A is wrong because Ctrl + Z is Undo, which cancels the last action instead of repeating it. B is wrong because Shift + Z is not a command shortcut in Excel; it simply types a capital Z. D is wrong because Shift + Y likewise only types a capital Y. Exam tip: Ctrl + Z undo, Ctrl + Y redo or repeat, Ctrl + C copy, Ctrl + V paste, and F4 also repeats in Excel.
Practice Questions
View allWhich language uses the symbolic representation of machine codes needed to program a particular processor or processor family?
- A.Machine Language
- B.Assembly Language
- C.High-Level Language
- D.All of the above
Show answer
Assembly language replaces the binary machine codes of a processor with short symbols called mnemonics, such as MOV, ADD and JMP.
Read the full explanation →Which one of the following is the characteristic of Artificial Intelligence ?
- A.Replicates human decision making
- B.Stores relevant information
- C.Stores similar kind of data for a specific purpose
- D.Allows user to interact with media
Show answer
Artificial Intelligence is the ability of a machine to perform tasks that normally need human intelligence, such as reasoning, learning and taking decisions.
Read the full explanation →What is an interactive combination of text, graphics, video, audio and images termed as ?
- A.JPEG
- B.Multimedia
- C.AVA
- D.PNG
Show answer
Multimedia means using several forms of media, such as text, graphics, audio, video, images and animation, together, often in a way the user can interact with.
Read the full explanation →Which among the following is a malicious software?
- A.Hacking
- B.Password Cracking
- C.Trojan Horse
- D.Firewall
Show answer
A Trojan is a program that looks useful or harmless but secretly carries harmful code, so it is a piece of malicious software, or malware.
Read the full explanation →Which one of the following is not an application software?
- A.Spreadsheet
- B.AutoCAD
- C.MS PowerPoint
- D.Linker
Show answer
A linker is system software, a programming tool that joins compiled pieces of code into one program that can run; it does not do a task for the end user.
Read the full explanation →