Podcast
Questions and Answers
Which of the following steps should be followed to use Excel's Autofill capability to add formulas to a range of cells?
Which of the following steps should be followed to use Excel's Autofill capability to add formulas to a range of cells?
- 1) Click the cell with the desired formula, 2) Copy the cell, 3) Select the desired range and paste
- 1) Click the cell with the desired formula, 2) Click the fill handle and double-click the last cell in the desired range
- 1) Click the cell with the desired formula, 2) Click the fill handle and drag it to the desired range, 3) Release the mouse button (correct)
- 1) Select the entire range of cells, 2) Type the desired formula in the formula bar, 3) Press Enter
What is the purpose of the fill handle in Excel?
What is the purpose of the fill handle in Excel?
- To automatically fill a range of cells with a pattern or series (correct)
- To delete the contents of a cell
- To copy and paste the contents of a cell
- To insert a new row or column
In the formula =SUM(number1, number2,...)
, what does the ...
represent?
In the formula =SUM(number1, number2,...)
, what does the ...
represent?
- A syntax error in the formula
- A placeholder for a range of cells
- An optional argument that can be included or omitted
- Additional arguments that can be added to the function (correct)
What is the purpose of the SUM
function in Excel?
What is the purpose of the SUM
function in Excel?
Which of the following statements about Excel functions is true?
Which of the following statements about Excel functions is true?