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
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 14,934
Questions: 10 | Attempts: 110

SettingsSettingsSettings
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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.