DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?
|
|
Type the first letters in a cell
|
|
|
Click Formula AutoComplete on the Ribbon
|
|
|
Open the AutoComplete Wizard by right-clicking on the active cell
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-2: -Relative Cell References This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.
There is 1 question to complete.