Question 1

How do you quickly navigate to the last filled cell in a column in Excel?

Accepted Answer

Press Ctrl + Down Arrow

Answer

Press Alt + Down Arrow

Answer

Press Shift + Down Arrow

Answer

Press Ctrl + Up Arrow

Question 2

What happens if you press Ctrl + Home in Excel?

Accepted Answer

It navigates to the first cell (A1) of the sheet

Answer

It navigates to the last filled cell in the sheet

Answer

It opens a new sheet

Answer

It highlights all cells in the sheet

Question 3

How can you bold text in Excel using keyboard shortcuts?

Accepted Answer

Highlight the text and press Ctrl + B

Answer

Highlight the text and press Ctrl + U

Answer

Highlight the text and press Ctrl + I

Answer

Highlight the text and press Alt + B

Question 4

What does pressing Alt + Shift + 5 do in Excel?

Accepted Answer

Applies strikethrough to the selected text

Answer

Italicizes the selected text

Answer

Highlights the selected text

Answer

Underlines the selected text

Question 5

How do you navigate between sheets using keyboard shortcuts?

Accepted Answer

Press Alt + Down Arrow or Alt + Up Arrow

Answer

Press Shift + Down Arrow or Shift + Up Arrow

Answer

Press Ctrl + Down Arrow or Ctrl + Up Arrow

Answer

Press Ctrl + Tab or Ctrl + Shift + Tab

Question 6

How can you concatenate two cells with a space in between?

Accepted Answer

Use =A1 & " " & B1

Answer

Use =A1 JOIN B1

Answer

Use =A1 + " " + B1

Answer

Use =A1 CONCAT B1

Question 7

Which function can join multiple text strings with a specified delimiter?

Accepted Answer

TEXTJOIN

Answer

CONCATENATE

Answer

SPLIT

Answer

JOIN

Question 8

How do you navigate to the last filled cell in a row in Excel?

Accepted Answer

Press Ctrl + Right Arrow

Answer

Press Shift + Right Arrow

Answer

Press Ctrl + Left Arrow

Answer

Press Alt + Right Arrow

Question 9

What is the keyboard shortcut to navigate to the next sheet in Excel?

Accepted Answer

Press Ctrl + Page Down

Answer

Press Shift + Page Down

Answer

Press Alt + Page Down

Answer

Press Ctrl + Page Up

Question 10

How do you escape from a broken formula entry in Excel?

Accepted Answer

Press the Esc key

Answer

Press the Enter key

Answer

Press Ctrl + Z

Answer

Press the Tab key

Question 11

How do you underline text in Excel using keyboard shortcuts?

Accepted Answer

Highlight the text and press Ctrl + U

Answer

Highlight the text and press Ctrl + B

Answer

Highlight the text and press Ctrl + I

Answer

Highlight the text and press Alt + U

Question 12

Which keyboard shortcut allows you to toggle between bold and normal text in Excel?

Accepted Answer

Highlight the text and press Ctrl + B

Answer

Highlight the text and press Ctrl + I

Answer

Highlight the text and press Ctrl + U

Answer

Highlight the text and press Alt + B

Question 13

What function allows you to combine text strings and specify a delimiter in Excel?

Accepted Answer

TEXTJOIN

Answer

CONCATENATE

Answer

JOIN

Answer

SPLIT

Question 14

How do you select an entire column from a specific cell downwards in Excel?

Accepted Answer

Press Ctrl + Shift + Down Arrow

Answer

Press Ctrl + Down Arrow

Answer

Press Alt + Down Arrow

Answer

Press Shift + Down Arrow

Question 15

How do you remove spaces at the beginning or end of a text string in Excel?

Accepted Answer

Use the TRIM function

Answer

Use the CONCATENATE function

Answer

Use the SPLIT function

Answer

Use the JOIN function

Question 16

How do you navigate to the first cell in a row in Excel?

Accepted Answer

Press Ctrl + Left Arrow

Answer

Press Alt + Left Arrow

Answer

Press Shift + Left Arrow

Answer

Press Ctrl + Right Arrow

Question 17

How do you switch between open workbooks in Excel?

Accepted Answer

Press Ctrl + Tab

Answer

Press Alt + Tab

Answer

Press Shift + Tab

Answer

Press Ctrl + Page Down

Question 18

How do you underline a cell's content in Excel using a keyboard shortcut?

Accepted Answer

Press Ctrl + U

Answer

Press Alt + U

Answer

Press Ctrl + I

Answer

Press Ctrl + B

Question 19

Which function checks if a cell contains text in Excel?

Accepted Answer

ISTEXT

Answer

ISNUMBER

Answer

ISBLANK

Answer

ISLOGICAL

Question 20

How do you check if a cell is empty in Excel?

Accepted Answer

Use the ISBLANK function

Answer

Use the ISURL function

Answer

Use the ISTEXT function

Answer

Use the ISNUMBER function

Related quizzes

Related quizzes