Selecting, Moving & Copying Cells
-
what is the shortcut key for cut the text for past on other place ?
-
Crt-X
-
Crt-Y
-
Crt-S
-
This quiz assesses key skills in managing spreadsheet operations such as cutting, copying, and merging cells. It covers shortcuts and functions essential for efficient data manipulation, making it highly relevant for learners looking to enhance their productivity tool proficiency.
(22).webp "Selecting, Moving & Copying Cells - Quiz")
Quiz Preview
- 2.
You can select the current Row by pressing
-
Control + spacebar
-
Shift + spacebar
-
Alt spacebar
-
Alt spacebar
Correct Answer
A. Shift + spacebarExplanation
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.
-
Row
-
Cell
-
Column
Correct Answer
A. CellExplanation
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 ---------------------------------------.
-
Borders command.
-
Merge command.
-
Page Beak Preview.
-
None of the above.
Correct Answer
A. 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_____________.
-
Autosum command
-
Fill Down command
-
Format Painter
-
Nonn of the above.
Correct Answer
A. Fill Down commandExplanation
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:
-
Freezing
-
Locking
-
Selecting
-
Fixing
Correct Answer
A. FreezingExplanation
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 ?
-
Formula bar
-
Cell Bar
-
Name box
Correct Answer
A. Name boxExplanation
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 ?
-
Crt+S
-
Crt+E
-
Crt+A
Correct Answer
A. Crt+AExplanation
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 ?
-
Crt+C
-
Crt+V
-
Crt+P
Correct Answer
A. Crt+CExplanation
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 ?
-
Move the Cell
-
Cut the Cell
-
Drag the Cell
Correct Answer
A. Move the CellExplanation
The Four head Arrow can be used to move the cell.Rate this question:
-
Quiz Review Timeline (Updated): Mar 7, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 07, 2024Quiz Edited by
ProProfs Editorial Team -
Apr 07, 2011Quiz Created by
Nsurani
Back to top