In Microsoft Excel, what is the purpose of the "AutoFill" feature?
2023
In Microsoft Excel, what is the purpose of the "AutoFill" feature?
- A.
To automatically correct spelling mistakes as you type
- B.
To insert common formulas and functions based on the data in adjacent cells
- C.
To apply a consistent style and formatting to the entire worksheet
- D.
To create hyperlinks between cells and worksheets
Attempted by 641 students.
Show answer & explanation
Correct answer: B
The "AutoFill" feature in Microsoft Excel allows you to quickly fill a series of cells with data or insert common formulas and functions based on the data in adjacent cells. For example, you can use AutoFill to quickly fill a column with a series of dates or to copy a formula across multiple cells.