WorksheetsExcel Shortcuts and Features Quiz
Total questions: 20
Worksheet time: 10mins
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
When inserting a new column into an existing worksheet, where will the new column be placed?
To the left of the selected column
To the right of the selected column
Above the selected column
Below the selected column
Which of the following best describes the purpose of the AutoFit feature in Excel?
Automatically resizes rows and columns based on cell contents
Automatically formats numbers as currency
Applies a default font size to all cells
Ensures that all text in a column fits within the width of the screen
When using Freeze Panes, what happens if you select a cell in the middle of the worksheet before freezing?
The entire worksheet becomes frozen
The row above and the column to the left of the selected cell remain visible when scrolling
Only the selected cell remains frozen
Excel automatically locks all data in the sheet
A formula such as =A1+$B$1 is an example of which type of cell referencing?
Relative referencing
Absolute referencing
Mixed referencing
Dynamic referencing
If you want to use AutoSum to total multiple non-adjacent cell ranges, which of the following is the best method?
Use =SUM(A1:A5, C1:C5)
Select all the cells and click the AutoSum button
Press CTRL + A and then click AutoSum
Use the =COUNTIF function instead
What will happen if you drag the fill handle of a cell containing the formula =B1*2 down a column?
The formula will remain the same in all cells
The formula will update, referencing new row numbers in each copied cell
The value in the first cell will be copied, but the formula will not update
The formula will turn into an absolute reference automatically
If you want to insert today’s date in a cell, which function should you use?
=TODAY()
=DATE()
=NOW()
=CURRENTDATE()
If you resize a column by double-clicking the border between column headers, what will happen?
The column will shrink to its minimum size
The column will automatically adjust to fit the widest content in the column
The column width will increase by 10 pixels
The column will expand to match the width of the next column
What is the main advantage of using Named Ranges in Excel formulas?
It allows users to reference a group of cells with a meaningful name instead of cell coordinates
It automatically creates a pivot table
It prevents any modifications to the selected range
It speeds up calculations in large datasets
In Excel, what is the main difference between =COUNT(A1:A10) and =COUNTA(A1:A10)?
COUNT only counts numeric values, while COUNTA counts both numbers and text
COUNTA only counts numeric values, while COUNT counts both numbers and text
Both functions count all non-empty cells
COUNT can count only text values, while COUNTA counts numbers
