top of page

Which of the following tabs is NOT available in Excel's Ribbon by default?

Home
Insert
Tools
View

How can you quickly apply the same formatting from one cell to another?

Use the Format Painter
Manually copy the formatting
Press Ctrl + C
Use Conditional Formatting

Which shortcut key allows you to navigate to the next sheet in a workbook?

Ctrl + Tab
Ctrl + Page Down
Ctrl + Arrow Down
Ctrl + N

What is the default alignment for text in an Excel cell?

Center
Left
Right
Justify

Which feature in Excel allows you to freeze specific rows or columns while scrolling?

Freeze Panes
Split View
Hide Rows
Zoom

How do you insert a new row in Excel?

Right-click a row number
Press Ctrl + R
Use the Insert Tab
Double-click on a cell

Which of the following is used to merge multiple cells into one?

Format Cells
Merge & Center
AutoSum
Wrap Text

If you want to quickly move to cell A1 from anywhere in the sheet, what should you press?

Ctrl + Home
Ctrl + End
Ctrl + A
Ctrl + G

What is the first step to create an Excel Table?

Select the range of data
Go to the Insert Tab
Click on "Table"
All of the above

Which of the following is NOT a feature of Excel Tables?

Automatic filtering
Automatic sorting
Automatic calculation
Automatic formatting

How do you add a new column to an existing table?

Right-click and choose "Insert"
Click on the last column and press Tab
Drag the table edge
Click the Insert tab

What is the shortcut key to select an entire table?

Ctrl + T
Ctrl + A
Ctrl + Shift + Space
Ctrl + Alt + Space
bottom of page