Excel Shortcuts and Features Quiz

You are working on a dataset with thousands of rows. You need to quickly move to the last column that contains data while keeping the selection active. Which of the following shortcuts is the most efficient?

• CTRL + Home

• CTRL + End

• CTRL + Shift + End

• ALT + End

You accidentally deleted an entire row in Excel but need to restore it without using the mouse. Which shortcut should you use immediately?

• CTRL + Z

• CTRL + Y

• ALT + Z

• SHIFT + CTRL + Z

A worksheet has multiple columns, some of which are hidden. You need to select all visible and hidden cells in the worksheet in one step. What is the best method?

• Press CTRL + A

• Click the whole sheet button at the top-left corner

• Drag the mouse from A1 to the last cell

• Use SHIFT + Left Arrow

Which of the following best describes the behavior of the clipboard when using CTRL + X to cut a cell's content?

• The content is immediately deleted and cannot be recovered

• The content remains visible in the original cell until pasted elsewhere

• The content is copied and duplicated in another cell

• The content is permanently moved to the clipboard

You need to select only every other row in a dataset without manually clicking each row. Which method would be the most efficient?

• Hold CTRL and click each row manually

• Use the SHIFT key and arrow keys to select

• Use conditional formatting to highlight every other row, then filter

• Press CTRL + A and adjust row selection afterward

While working with formulas, you need to ensure a reference remains constant when copied across multiple cells. Which of the following should be used?

• Relative references (A1, B2)

• Absolute references ($A$1, $B$2)

• Mixed references (A$1, $B2)

• Dynamic references using named ranges

You need to move the cursor to a specific cell without using the arrow keys or mouse. What is the best way to do this?

• Use CTRL + Home to return to A1

• Use CTRL + End to move to the last data cell

• Enter the cell address directly into the Name Box

• Press ALT + G and navigate manually

You have a dataset where you frequently copy and paste data from multiple locations. Which feature would be most efficient in reducing redundant copying and pasting?

• Using the Office Clipboard to store multiple copied items

• Using the 'Cut' command instead of 'Copy'

• Manually copying each selection multiple times

• Using CTRL + X and CTRL + V repeatedly

You want to quickly resize multiple columns so that they fit their content exactly. Which method will accomplish this in the least number of steps?

• Drag each column manually to adjust width

• Double-click the boundary between column headers

• Use the Format option in the Home Ribbon

• Select all columns, then choose AutoFit Column Width

A colleague asks why their worksheet cursor is skipping several rows when they press the down arrow. What is the most likely explanation?

• Scroll Lock is enabled, causing unintended movement

• The worksheet has frozen panes restricting movement

• The data has merged cells that affect navigation

• The arrow keys have been remapped in Excel settings