0
0
Excelspreadsheet~20 mins

Keyboard shortcuts for efficiency in Excel - Practice Problems & Coding Challenges

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Challenge - 5 Problems
🎖️
Excel Keyboard Shortcut Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate
1:00remaining
What is the result of pressing Ctrl + ; in Excel?
In an Excel worksheet, you press Ctrl + ; in a selected cell. What happens?
AThe current date is entered into the selected cell.
BThe entire row of the selected cell is deleted.
CThe formula bar is cleared.
DThe current time is entered into the selected cell.
Attempts:
2 left
💡 Hint
Think about shortcuts that quickly insert date or time.
❓ Function Choice
intermediate
1:30remaining
Which shortcut quickly selects the entire data region around the active cell?
You want to select all adjacent cells with data around your current cell without dragging. Which keyboard shortcut do you use?
ACtrl + A
BCtrl + Shift + Space
CCtrl + Shift + Arrow key
DCtrl + Shift + *
Attempts:
2 left
💡 Hint
This shortcut selects the current region of data.
🎯 Scenario
advanced
1:30remaining
You want to quickly copy the value from the cell above without using the mouse. Which shortcut do you use?
In Excel, you want to fill the current cell with the value from the cell directly above it using only the keyboard. Which shortcut achieves this?
AAlt + Enter
BCtrl + R
CCtrl + D
DCtrl + Shift + V
Attempts:
2 left
💡 Hint
This shortcut fills down the value from above.
📊 Formula Result
advanced
1:00remaining
What happens when you press Ctrl + Shift + L in Excel?
You press Ctrl + Shift + L in an Excel worksheet. What is the effect?
AIt toggles filters on or off for the selected data range.
BIt locks the selected cells to prevent editing.
CIt opens the 'Find and Replace' dialog box.
DIt inserts a new worksheet.
Attempts:
2 left
💡 Hint
Think about filtering data quickly.
❓ data_analysis
expert
2:00remaining
How many cells are selected after pressing Ctrl + Shift + End from cell A1 in a worksheet with data up to cell D10?
Starting from cell A1, you press Ctrl + Shift + End. The worksheet has data filled from A1 to D10. How many cells are selected after this shortcut?
A36 cells
B40 cells
C50 cells
D44 cells
Attempts:
2 left
💡 Hint
Count all cells from A1 to D10 inclusive.