click below
click below
Normal Size Small Size show me how
Module 6 Chapter 2
Excel Assement
Question | Answer |
---|---|
Start every formula by typing this | = |
The order in which Excel calculates operations is called | Order of operations |
You can enter this in a formula and it will tell Excel what to calculate | Numbers, cell reference, or range reference |
Cell C27 contains the value 10. What is the result when Excel evaluates the formula =2*3+C27/5 | 8 |
The following are true | Functions are grouped by category, Functions can be entered directly into a cell, Functions can be entered as the result of a search |
Which formula will ass the values in B3, C3, and D3 | =B3+C3+D3,=SUM(B3/C3/D3/),=SUM(B3-D3) |
This group in the home tab contains the tools for copying and pasting | Clipboard |
Most functions require one or more what that specify what to calculate | Arguments |
When you want to have a reference remain unchanged when you copy a formula, use this type of reference | Absolute |
Press this key to remove the contents of a selected cell range | Delete |