Which of the following shortcuts is used to create a new workbook in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + S
D) Ctrl + P
What does the “Freeze Panes” feature in Excel do?
A) Locks rows and columns to keep them visible while scrolling B) Protects the worksheet from changes C) Hides rows and columns D) Copies the worksheet to another location
In Excel, how can you rename a worksheet tab?
A) Double-click the tab name B) Right-click the tab and select “Rename” C) Press F2 while the tab is selected D) All of the above
Which of the following functions is used to sum a range of cells in Excel?
A) =AVERAGE() B) =SUM() C) =COUNT() D) =MAX()
How can you protect a worksheet from being modified by others?
A) Use the “Protect Sheet” feature in the Review tab B) Save the workbook as read-only C) Hide the worksheet D) Delete the worksheet
What is the purpose of the “VLOOKUP” function in Excel?
A) To search for a value in the leftmost column and return a value in the same row from a specified column B) To calculate the average of a range of cells C) To count the number of cells that contain numbers D) To find the highest value in a range
How do you select an entire column in Excel?
A) Click on the column header B) Press Ctrl + Shift + Arrow Key C) Press Shift + Spacebar D) Right-click on a cell and choose “Select Column” Answer: A) Click on the column header
Which of the following actions will insert a new row above the selected row?
A) Press Ctrl + Shift + + B) Right-click on the row number and select “Insert” C) Press Ctrl + R D) Click the “Insert” button on the Home tab
What happens when you double-click the boundary line between column headers in Excel?
A) The column is hidden B) The column is resized to fit the longest cell content C) The column is deleted D) The cell formatting is reset
How can you adjust the width of multiple columns at once?
A) Drag the boundary line of one column header while holding Shift B) Double-click the boundary line of one column header while holding Ctrl C) Select the columns and drag any boundary line between column headers D) Use the Format option in the Home tab to set the width for multiple columns
To merge two or more cells into a single cell, you should use which feature?
A) Format Cells B) Merge & Center C) Split Cells D) Autofit
How can you quickly navigate to the first cell of a worksheet?
A) Press Ctrl + Home B) Press Ctrl + End C) Click the “Go To” button on the Home tab D) Press Home
How can you start editing the content of a cell?
A) Double-click the cell B) Press F2 C) Select the cell and type D) Right-click the cell and choose “Edit”
What happens when you press Enter after typing data into a cell?
A) The data is saved and the selection moves down one cell B) The data is saved and the selection moves right one cell C) The cell enters edit mode D) The data is cleared
How can you quickly copy data from one cell to another?
A) Drag the Fill Handle from the original cell to the target cell B) Press Ctrl + C to copy and Ctrl + V to paste C) Use the Copy and Paste options from the Home tab D) All of the above
How do you undo the last action in Excel?
A) Press Ctrl + Z B) Press Ctrl + Y C) Press Esc D) Right-click and select “Undo”
What does pressing Ctrl + X do in Excel?
A) Cuts the selected data B) Copies the selected data C) Pastes the copied data D) Deletes the selected data
How can you paste data without formatting in Excel?
A) Use Paste Special and select “Values” B) Use the Format Painter C) Use the Clear Formats option D) Paste the data and then use the “Clear All” option
To enter the same data into multiple cells at once, you should:
A) Select all the cells and type the data, then press Ctrl + Enter B) Type the data into the first cell, then use the Fill Handle C) Use Copy and Paste for each cell D) Type the data into each cell individually
What is the purpose of the “Find and Replace” feature in Excel?
A) To search for specific data and replace it with new data B) To copy data from one cell to another C) To sort data in a range D) To delete data in a range
