NEW
Font size
WorksheetsEvaluation
Total questions: 20
Worksheet time: 10mins
You are working on a date set with thousand 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?
A.) CTRL+ Home
B.) CTRL+ End
C.) CTRL+ Shift+ End
D.) ALT+ End
You accidentally deleted an entire row in Excel but need to restore it without using mouse. Which shortcut should you use immediately?
A.) CTRL+ Z
B.) CTRL+ Y
C.) ALT+ Z
D.) SHIFT+ CTRL+ Z
A worksheet has multiple columns, some of each are hidden. You need to select all visible and hidden cells in the worksheet in one step. What is the best method?
A.) Press CTRL+ A
B.) Click the whole sheet button at the top-left corner
C.) Drag the mouse from A1 to the last cell
D.) Use SHIFT+ Left Arrow
Which the following best describes the behavior of the clipboard when using CTRL + X to cut a cell's content?
A.) The content is immediately deleted and cannot be recovered
The content remains visible in the original cell until pasted elsewhere
C.) The content is compied and duplicated in another cell
D.) The content is permanently moved to the clipboard
You need to select only every other row in a data set without manually clicking each row. Which method would be the most efficient?
A.) Hold CTRL and click each row manually
B.) Use the shift key and arrow keys to select
C.) Use conditional formatting to highlight every other row, then filter
D.) 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?
A) Relative references (A1, B2)
B) Absolute references ($A$1, $B$2)
C) Mixed references (A$1, $B2)
D) 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?
A) Use CTRL + Home to return to A1
B) Use CTRL + End to move to the last data cell
C) Enter the cell address directly into the Name Box
D) Press ALT + G and navigate manually
You have a data set where you frequently copy and paste data from multiple locations. Which feature would be most efficient in reducing redundant copying and pasting?
A) Using the Office Clipboard to store multiple copied items
B) Using the "Cut" command instead of "Copy"
C) Manually copying each selection multiple times
D) 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?
A) Drag each column manually to adjust width
B) Double-click the boundary between column headers
C) Use the Format option in the Home Ribbon
D) 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?
A) Scroll Lock is enabled, causing unintended movement
B) The worksheet has frozen panes restricting movement
C) The data has merged cells that affect navigation
D) 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?
A.) To the left of the selected column
B.) To the right of the selected column
C.)Above the selected column
D.) Below the selected column
Which of the following best describes the purpose of the AutoFit feature in Excel?
A.)Automatically resizes rows and columns based on cell contents
B.) Automatically formats numbers as currency
C.) Applies a default font size to all cells
D.) 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?
A.) The entire worksheet becomes frozen
B.) The row above and the column to the left of the
C.) Only the selected cell remains frozen
D.) Excel automatically locks all data in the sheet
A formula such as =A1+$B$1 is an example of which type of cell referencing?
A.) Relative referencing
B.) Absolute referencing
C.) Mixed referencing
D.) Dynamic referencing
If you want to use AutoSum to total multiple non-adjacent cell ranges, which of the following is the best method?
A.) Use =SUM(A1:A5, C1:C5)
B.) Select all the cells and click the AutoSum button
C.) Press CTRL + A and then click AutoSum
D.) 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?
A.) The formula will remain the same in all cells
B.) The formula will update, referencing new row numbers in each copied cell
C.) The value in the first cell will be copied, but the formula will not update
D.) 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?
A.) =TODAY()
B.) =DATE()
C.) =NOW()
D.) =CURRENTDATE()
If you resize a column by double-clicking the border between column headers, what will happen?
A.) The column will shrink to its minimum size
B.) The column will automatically adjust to fit the widest content in the column
C.) The column width will increase by 10 pixels
D.) The column will expand to match the width of the next column
What is the main advantage of using Named Ranges in Excel formulas?
A.) It allows users to reference a group of cells with a meaningful name instead of cell coordinates
B.) It automatically creates a pivot table
C.) It prevents any modifications to the selected range
D.) It speeds up calculations in large datasets
In Excel, what is the main difference between =COUNT(A1:A10) and =COUNTA(A1:A10)?
A.) COUNT only counts numeric values, while COUNTA counts both numbers and text
B.) COUNTA only counts numeric values, while COUNT counts both numbers and text
C.) Both functions count all non-empty cells
D.) COUNT can count only text values, while COUNTA counts numbers
