EXCEL
1. What is a range of cells? Provide an example of how you would write a range of cells?
A block of cells in excel.
2. How do change the name of a worksheet tab? You would click the tab and type in the name you want to put.
3. What is the difference between contiguous and non-contiguous range of cells?
Continous range are adjacent ranges and noncontinous are non-adjacent ranges.
4. What key do you need to select to highlight a range of non-contiguous range of cells?
You need to use the control key.
5. What is a relative cell reference? Provide an example.
A cell adress expressed in relation to the cell containing the formula. For example, rather than naming a specific cell in a formula, a realtive cell reference might identify a cell three columns to the left of the cell containing the formula.
6. What is an absolute cell reference? Provide an example.
A cell address referenced in a formula that does not change based on the location of the cell that contains the formula. For example $E$14
7. Which function would display the highest value in a range of cells?
MAX
8. Which function would display the lowest value in a range of cells?
MIN
9. Which function returns the arithemetic mean of a range of values?
Range
10. Which function adds the value in a range of cells?
SUM
11. What feature in Excel can you add that will allow you to sort and filter the records in a spreadsheet?Sort and Filter
12. What is the plot area in a chart?
The area in excel defined by the x and y axis.
13. What is an axis?
Straight line through a body or figure that sastifies certain conditions.
14. What is the data series?
The information in a worksheet column. If you select multiple columns of data for a chart, you'll create a multiple data series.
15. What is a function? Provide an example.
A function is a predefined formula that uses the values in the cells you select to calculate its answer. Ex. =SUM( )
16. What is an expression? Provide an example.
An expression is a sort of equation ( such as B6>25) that returns a value, such as TRUE or FALSE. Excel uses expressions to identify cells to include in certain formulas, such as IF and SUMIF.
17. What is an argument? Provide an example.
An argument is a variable used in a function. An argument can be a number, text, formula, or a cell reference. A comma seperates each argument in a function. Ex-
18. What is nesting?
Nesting-Using a function as an argument within another function.
19. What is a conditional operator? Provide an example.
Assigns a value to a variable based on some condition. Ex-
20. What is a chart legend?
It is the table at the bottom of a chart that shows a label for each chart object and indicates which line or set of bars in the chart display that object's values. Ex-
21. What data is compared in a line chart?
A trend in data over intervals of time, thus the line is often drawn chronologically. Ex-
22. What data is compared in a column chart?
Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items.
23. What data is compared in pie c
hart? Relative magnitudes or frequencies.
A function is a predefined formula that uses the values in the cells you select to calculate its answer. Ex. =SUM( )
16. What is an expression? Provide an example.
An expression is a sort of equation ( such as B6>25) that returns a value, such as TRUE or FALSE. Excel uses expressions to identify cells to include in certain formulas, such as IF and SUMIF.
17. What is an argument? Provide an example.
An argument is a variable used in a function. An argument can be a number, text, formula, or a cell reference. A comma seperates each argument in a function. Ex-
18. What is nesting?
Nesting-Using a function as an argument within another function.
19. What is a conditional operator? Provide an example.
Assigns a value to a variable based on some condition. Ex-
20. What is a chart legend?
It is the table at the bottom of a chart that shows a label for each chart object and indicates which line or set of bars in the chart display that object's values. Ex-
21. What data is compared in a line chart?
A trend in data over intervals of time, thus the line is often drawn chronologically. Ex-
22. What data is compared in a column chart?
Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items.
23. What data is compared in pie c
hart? Relative magnitudes or frequencies. 
