Excel

1. What is a range of cells? Provide an example of how you would write a range of cells?
-A range of cells is a block of cells in an excel worksheet. For example, a range would be E12:E14.
2. How do change the name of a worksheet tab?
-You click on the tab until the name is highlighted and then you type the name you want.
3. What is the difference between contiguous and non-contiguous range of cells?
-Contiguous cells are cells that are next to or adjacent and non-contigous cells are cells in a worksheet that act as a block, but are not necessarily adjacent to each other.
4. What key do you need to select to highlight a range of non-contiguous range of cells?
-Control
5. What is a relative cell reference? Provide an example.
-A relative cell reference is a cell address expressed in relation to the cell containing the formula. For example, rather than naming a specific cell in a formula, a relative cell reference might identify a cell three comlumns to the left of the cell containin.
6. What is an absolute cell reference? Provide an example.
-An absolute cell reference is a cell address referenced in a formula that does not change based on the location of the cell that contains the formula. For example, an absolute cell reference would be $E$14.
7. Which function would display the highest value in a range of cells?
-Maximum
8. Which function would display the lowest value in a range of cells?
-Minimum
9. Which function returns the arithemetic mean of a range of values?
-Average
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?
12. What is the plot area in a chart?
-The position data points on a graph
13. What is an axis?
-an area which categories are plotted.
14. What is the data series?
-The data series is the information in a worksheet column. Each data series is represented by its own color bar, line, or column.
15. What is a function? Provide an example.
-A function is a built-in formula for performing calculations in a table. For example, addition.
16. What is an expression? Provide an example.
-An expression is a sort of equation that returns a value such as true or false. Excel uses expressions to identify cells to indicate cells to include in certain formulas. For example, B6>25
17. What is an argument? Provide an example.
-An argument is a variable used in a function, that can be a number, text, formula, or a cell reference. A comma seperates each argument in a function. For example, =IF(C3>92,"A",IF(C3>73,"C",IF(C3>65,"D","F"))))
18. What is nesting?
-Nesting is using a function as an argument within another function.
19. What is a conditional operator? Provide an example.
20. What is a chart legend?
-A key that identifies each of the data series in a chart.
21. What data is compared a line chart?
-A line chart connects points of data and show change over time effectively.
22. What data is compared in a column chart?
-A column chart compares individual or sets of values.
23. What data is compared in pie chart?
-A pie chart is a circular graph used to show the relationship of each value in a data range to the entire set of data.

Stock Market Questions
1. What is the ticker symbol?
-the abbreviated company name
2. Provide one stock exchange where stocks are traded in the United States.
-NASDAQ
3. What is the calculation to figure out the intial investment when purchasing a set amount of stocks?
-(B3*B5)
4. What is the calculation to figure out your gain or loss on the the stock for each company?
- the current value for that day minus the current value from the day before
5. What is the difference between a public and privately held company?
-Public companies sell stocks to everyone while privately held companies only sell stocks to their employees