Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
- 3rd side (hint)
|
What are functions? |
Functions are built in formulas in Excel that allow user to easily perform common calculations on data. |
|
|
|
What are the three ways fictions can be entered in a worksheet? |
Functions can be entered in a worksheet using keyboard, Insert Function command or AutoSum drop-down menu. |
|
|
|
List three functions in Excel. |
Average Max Min |
|
|
|
What are the steps for finding AVERAGE using keyboard? |
1. Select cell E5 where the results will appear. 2. Type =av to display the Formula AutoComplete list. 3. Point to AVERAGE function and Double-click. 4. Select the range B5:D5 to insert it as argument to the AVERAGE function. 5. Press Enter key. |
5 steps |
|
|
What are the steps for using Insert Function command to Find the Highest Value? |
1. Select cell B11 where the answers will appear. 2. Click Insert Function command. Insert Function dialog box will be displayed. 3. Select MAX in the function list and click OK. 4. Type B5:B8 in the Number 1 text box of Function Arguments dialog box and click OK. |
4 steps |
|
|
What are the steps of using AutoSum Drop-down menu to Find the Lowest Value? |
1. Select cell B11 where the answer will appear. 2. Click Formulas tab. 3. Open the AutoSum drop-down menu in the Function Library group and select Min. 4. Type the range B5:B8 and press Enter. |
4 steps |
|
|
What are formulas? |
A formula is an expression that performs calculations. It consists of operators, constants and cell addresses. |
|
|
|
What, are the Standard operators used in Excel formulas for the following? Addition Subtraction Multiplication Division Exponent |
Addition + Subtraction - Multiplication * Division / Exponent ^ |
|
|
|
Explain how formulas in Excel work. |
All Excel formulas begin with the equal sign (=) just like functions. For example, to multiply two number 4 and 7, the formula will be =4*7. User can also use cell addresses in formulas such as =(A4+B4) /5. This formula will first add the contents of cell A4 and B4 and then divide the sum by 5. |
|
|
|
How can we find the sum of the contents of cell addresses? |
There are two ways, either you enter the formula =B4+C4+D4 or go to the Formulas tab and double click on AutoSum commend in the Function Library group then select Sum. |
|
|
|
What is meant by automatic recalculation? |
Excel automatically recalculated formula results. Whenever the user changes the value in a cell, the result of the formula in which that value is used will be automatically updated. This feature is known as automatic recalculation. |
|
|
|
What is the biggest advantage spreadsheets have over calculators? |
Automatic recalculation |
|
