10 Questions
What is the shortcut to enter the same data into multiple cells?
CTRL+ENTER
How do you fill in data on adjacent cells in Excel?
By dragging the fill handle
What type of data can Microsoft Excel automatically continue in a series?
Number, dates, or time periods
What happens when you type the first few characters of an existing entry in a column?
Excel fills in the remaining characters
What is the result of pressing ENTER when Excel completes an entry?
The entry is accepted
How do you fill in a series of numbers in increasing order?
Drag the fill handle down
What happens when you leave the second cell blank in a series?
The series continues with the same value
What type of entries are not completed by Excel?
Entries with only numbers
What is the purpose of the fill handle?
To fill in a series of numbers or dates
What is the result of dragging the fill handle to the left?
The series is filled in decreasing order
Study Notes
Entering Data into Multiple Cells
- Select multiple non-adjacent cells using CTRL
- Type the data and press CTRL+ENTER to enter the same data into all selected cells
Filling in Data on Adjacent Cells
- Select the cell(s) containing the starting values
- Drag the fill handle over the range of cells to fill
- To fill in increasing order, drag down or to the right
- To fill in decreasing order, drag up or to the left
Examples of Filling in Series
- Enter 2 and 3 in the first two cells to fill in the series 2, 3, 4, 5, ...
- Enter 2 and 4 in the first two cells to fill in the series 2, 4, 6, 8, ...
- Enter 2 in the first cell and leave the second cell blank to fill in the series 2, 2, 2, ...
Automatically Filling in Repeated Entries
- If the first few characters typed in a cell match an existing entry in that column, Excel fills in the remaining characters
- Excel completes only entries that contain text or a combination of text and numbers
- Press ENTER to accept the completed entry
- The completed entry exactly matches the pattern of uppercase and lowercase letters of the existing entries
- Continue typing to replace the automatically entered characters
- Press BACKSPACE to delete the automatically entered characters
Learn about editing shortcuts in Microsoft Excel, including entering data into multiple cells and filling in series of numbers or dates. This quiz is ideal for Excel users looking to improve their productivity.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
