Quiz: Module 5


Module 5Online version Module 5 quiz by zahra 1 Which command should you use to combine multiple selected cells into one single, larger cell? a Group Cells b Merge & Center c Consolidate d Join Cells 2 What happens when you use the "Merge Cells" option on a range that contains data in multiple cells? a All data is combined into the new cell. b Only the data from the upper-left cell is kept. c The data is deleted entirely. d Excel moves the extra data to the next row. 3 When moving a cell, what is the keyboard shortcut to "Cut" the selection before pasting it elsewhere? a Ctrl + C b Ctrl + V c Ctrl + X d Ctrl + E 4 Which "Paste Special" option would you choose if you want to flip a vertical list of data into a horizontal row? a Values b Formulas c Transpose d Formats 5 If you want to copy the results of a formula but not the formula itself, which "Paste Special" command should you use? a Paste Link b Paste Values c Paste Validation d Paste Comments 6 Which feature allows you to change every instance of the word "January" to "Jan" throughout an entire worksheet instantly? a Go To Special b Conditional Formatting c Filter d Find and Replace 7 In the "Find and Replace" dialog box, which button allows you to change all occurrences of a specific term at once? a Replace b Find Next c Replace All d Update All 8 When you "Hide" a column in Excel, what happens to the data inside those cells? a The data is deleted until the column is unhidden. b The data remains but is not visible or printable. c The data is moved to a hidden worksheet. d The formulas in those cells stop working. 9 How can you "Unhide" a hidden row (for example, Row 5) that is between Row 4 and Row 6? a Double-click the line between Row 4 and Row 6. b Select Rows 4 and 6, right-click, and select "Unhide." c Press Ctrl + Z. d Both A and B are correct. 10 Which keyboard shortcut allows you to quickly open the 'Find and Replace' dialog box with the 'Replace' tab active? a Ctrl + C b Ctrl + H c Ctrl + V d Ctrl + S

1

Which command should you use to combine multiple selected cells into one single, larger cell?

a

Group Cells

b

Merge & Center

c

Consolidate

d

Join Cells

2

What happens when you use the "Merge Cells" option on a range that contains data in multiple cells?

a

All data is combined into the new cell.

b

Only the data from the upper-left cell is kept.

c

The data is deleted entirely.

d

Excel moves the extra data to the next row.

3

When moving a cell, what is the keyboard shortcut to "Cut" the selection before pasting it elsewhere?

a

Ctrl + C

b

Ctrl + V

c

Ctrl + X

d

Ctrl + E

4

Which "Paste Special" option would you choose if you want to flip a vertical list of data into a horizontal row?

a

Values

b

Formulas

c

Transpose

d

Formats

5

If you want to copy the results of a formula but not the formula itself, which "Paste Special" command should you use?

a

Paste Link

b

Paste Values

c

Paste Validation

d

Paste Comments

6

Which feature allows you to change every instance of the word "January" to "Jan" throughout an entire worksheet instantly?

a

Go To Special

b

Conditional Formatting

c

Filter

d

Find and Replace

7

In the "Find and Replace" dialog box, which button allows you to change all occurrences of a specific term at once?

a

Replace

b

Find Next

c

Replace All

d

Update All

8

When you "Hide" a column in Excel, what happens to the data inside those cells?

a

The data is deleted until the column is unhidden.

b

The data remains but is not visible or printable.

c

The data is moved to a hidden worksheet.

d

The formulas in those cells stop working.

9

How can you "Unhide" a hidden row (for example, Row 5) that is between Row 4 and Row 6?

a

Double-click the line between Row 4 and Row 6.

b

Select Rows 4 and 6, right-click, and select "Unhide."

c

Press Ctrl + Z.

d

Both A and B are correct.

10

Which keyboard shortcut allows you to quickly open the 'Find and Replace' dialog box with the 'Replace' tab active?

a

Ctrl + C

b

Ctrl + H

c

Ctrl + V

d

Ctrl + S

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Module 5

Quiz

About this activity

Created by

Download the paper version to play

Top Games

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Spanish Alphabet Listening

Quiz

Tissues - Practice Quiz

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

UPS 5 Seeing Habits Quiz

Module 5Online version

by zahra

Which command should you use to combine multiple selected cells into one single, larger cell?

What happens when you use the "Merge Cells" option on a range that contains data in multiple cells?

When moving a cell, what is the keyboard shortcut to "Cut" the selection before pasting it elsewhere?

Which "Paste Special" option would you choose if you want to flip a vertical list of data into a horizontal row?

If you want to copy the results of a formula but not the formula itself, which "Paste Special" command should you use?

Which feature allows you to change every instance of the word "January" to "Jan" throughout an entire worksheet instantly?

In the "Find and Replace" dialog box, which button allows you to change all occurrences of a specific term at once?

When you "Hide" a column in Excel, what happens to the data inside those cells?

How can you "Unhide" a hidden row (for example, Row 5) that is between Row 4 and Row 6?

Which keyboard shortcut allows you to quickly open the 'Find and Replace' dialog box with the 'Replace' tab active?

		%
	Anonymous	%
		%
		%