Selecting, Moving & Copying Cells

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Nsurani

Nsurani

Community Contributor

Quizzes Created: 14 | Total Attempts: 15,347

Questions: 10 | Attempts: 110 | Updated: Mar 7, 2024

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Selecting, Moving & Copying Cells - Quiz

Selecting, moving & coplying Cells.

Questions and Answers

1.

what is the shortcut key for cut the text for past on other place ?
- A.
  
  Crt-X
- B.
  
  Crt-Y
- C.
  
  Crt-S
Correct Answer
A. Crt-X

Explanation
The correct answer is Crt-X. This keyboard shortcut is used to cut selected text or objects from a document or file. Once the text or object is cut, it can be pasted in another location using the Ctrl-V shortcut.

Rate this question:
2.

You can select the current Row by pressing
- A.
  
  Control + spacebar
- B.
  
  Shift + spacebar
- C.
  
  Alt spacebar
- D.
  
  Alt spacebar
Correct Answer
B. Shift + spacebar

Explanation
To select the current row, you need to press the Shift + spacebar keys. This combination of keys allows you to highlight the entire row that the cursor is currently on. The Control + spacebar combination is used to select the entire column, while the Alt + spacebar combination opens the context menu for the selected item. Therefore, the correct answer is Shift + spacebar.

Rate this question:
3.

A _____________ is the intersection point of a column and a row.
- A.
  
  Row
- B.
  
  Cell
- C.
  
  Column
Correct Answer
B. Cell

Explanation
A cell is the intersection point of a column and a row. In a table or grid structure, columns run vertically and rows run horizontally. Each cell represents a unique intersection point where a column and a row meet. Cells are used to input or display data in a structured manner, making it easier to organize and analyze information.

Rate this question:
4.

To join a group of cells together to form one big cell. You have to highlight these cells and select the ---------------------------------------.
- A.
  
  Borders command.
- B.
  
  Merge command.
- C.
  
  Page Beak Preview.
- D.
  
  None of the above.
Correct Answer
B. Merge command.

Explanation
To join a group of cells together to form one big cell, you have to highlight these cells and select the "Merge command." This command combines the selected cells into a single cell, allowing you to treat them as one unit and format them accordingly. The Borders command is used to add or remove cell borders, while Page Break Preview is a feature that allows you to view and adjust page breaks in your worksheet.

Rate this question:
5.

You can copy a formula saved inside a cell to another cell or group of cells by highlighting the cell that contains the fomula together with the empty ones and selecting the_____________.
- A.
  
  Autosum command
- B.
  
  Fill Down command
- C.
  
  Format Painter
- D.
  
  Nonn of the above.
Correct Answer
B. Fill Down command

Explanation
To copy a formula from one cell to another, including any empty cells, you can use the Fill Down command. This command allows you to automatically fill the selected cells with the formula from the original cell. It is a quick and efficient way to replicate formulas across multiple cells without manually typing them in each cell. The Autosum command is used to quickly add up a range of cells, while the Format Painter is used to copy formatting from one cell to another. None of these options allow you to copy a formula to multiple cells.

Rate this question:
6.

The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called:
- A.
  
  Freezing
- B.
  
  Locking
- C.
  
  Selecting
- D.
  
  Fixing
Correct Answer
A. Freezing

Explanation
Freezing refers to the process of keeping certain rows and columns visible on the screen while scrolling through a large dataset. This allows the user to easily reference important information while navigating through the rest of the data. Locking, selecting, and fixing do not accurately describe this process.

Rate this question:
7.

Where can be seen the cell Address ?
- A.
  
  Formula bar
- B.
  
  Cell Bar
- C.
  
  Name box
Correct Answer
C. Name box

Explanation
The cell address can be seen in the Name box. The Name box is located next to the Formula bar in Microsoft Excel and displays the reference of the currently selected cell or range. It allows users to easily identify and navigate to specific cells by entering the cell address directly into the Name box.

Rate this question:
8.

What is the shortcut key for selecting the whole sheet ?
- A.
  
  Crt+S
- B.
  
  Crt+E
- C.
  
  Crt+A
Correct Answer
C. Crt+A

Explanation
The shortcut key for selecting the whole sheet is Ctrl+A. This keyboard shortcut allows users to quickly select all the cells in the current sheet or workbook.

Rate this question:
9.

What is the Shortcut key for Copy the Text or number from Excel sheet ?
- A.
  
  Crt+C
- B.
  
  Crt+V
- C.
  
  Crt+P
Correct Answer
A. Crt+C

Explanation
The shortcut key for copying text or numbers from an Excel sheet is Ctrl+C. This combination of keys allows the user to quickly duplicate selected content and place it on the clipboard for later use.

Rate this question:
10.

What can we do with the Four head Arrow ?
- A.
  
  Move the Cell
- B.
  
  Cut the Cell
- C.
  
  Drag the Cell
Correct Answer
A. Move the Cell

Explanation
The Four head Arrow can be used to move the cell.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 07, 2024

Quiz Edited by
ProProfs Editorial Team
Apr 07, 2011

Quiz Created by
Nsurani

Selecting, Moving & Copying Cells

what is the shortcut key for cut the text for past on other place ?

You can select the current Row by pressing

A _____________ is the intersection point of a column and a row.

To join a group of cells together to form one big cell. You have to highlight these cells and select the ---------------------------------------.

You can copy a formula saved inside a cell to another cell or group of cells by highlighting the cell that contains the fomula together with the empty ones and selecting the_____________.

The process of identifying specific rows and columns so that certain columns and rows are always visible on the screen is called:

Where can be seen the cell Address ?

What is the shortcut key for selecting the whole sheet ?

What is the Shortcut key for Copy the Text or number from Excel sheet ?

What can we do with the Four head Arrow ?