Question 1

What shortcut key inserts a new row above the current row?

Accepted Answer

Ctrl+Insert

Answer

Enter

Answer

Tab

Answer

Up arrow

Question 2

How do you format a cell as a number with two decimal places?

Accepted Answer

Ctrl+Shift+'. (period)'

Answer

Click the Increase Decimal button repeatedly

Answer

Use the number format dropdown in the Home tab

Answer

Right-click and select "Format Cells..."

Question 3

What shortcut key copies the formatting from one cell to another?

Accepted Answer

Ctrl+Alt+C, Ctrl+V

Answer

Drag and drop the border of the formatted cell

Answer

Use the Format Painter tool

Answer

Right-click, copy, then right-click and paste formatting

Question 4

How can you quickly delete the entire contents of a cell?

Accepted Answer

Delete or Backspace

Answer

Ctrl+X

Answer

Right-click and select "Clear Contents"

Answer

Esc

Question 5

Which shortcut key fills the contents of a cell across a range?

Accepted Answer

Ctrl+R (fill right)

Answer

Shift+Enter

Answer

Use the copy and paste function

Answer

Double-click the border of the cell

Question 6

How do you sum the values in a range of cells?

Accepted Answer

Alt+= (equal sign) or use the formula =SUM(range)

Answer

Drag and drop the sum function from the formula bar

Answer

Click the AutoSum button

Answer

Use the multiplication function

Question 7

What shortcut key inserts the current date into a cell?

Accepted Answer

Ctrl+; (semi-colon)

Answer

F4

Answer

Right-click and select "Insert Special"

Answer

Today function in the formula bar

Question 8

How can you quickly navigate to a specific sheet in your workbook?

Accepted Answer

Ctrl+Page Up/Down or use the sheet tabs at the bottom

Answer

Right-click on a sheet tab and select "Go To"

Answer

Use the sheet name dropdown in the top left corner

Answer

F12

Question 9

Which shortcut key bolds the selected text?

Accepted Answer

Ctrl+B

Answer

Highlight button

Answer

Italicizes the text

Answer

Formatting menu

Question 10

How do you undo the last action you performed?

Accepted Answer

Ctrl+Z

Answer

Right-click and select "Undo"

Answer

Cannot be undone

Answer

Delete key

Related quizzes

Related quizzes