1. What is a range of cells? Provide an example of how you would write a range of cells?
- A block of cells in an Excel worksheet

2. How do change the name of a worksheet tab?
-Right click and hit rename

3. What is the difference between contiguous and non-contiguous range of cells?
contigous range of cells is a block of adjacent cells in a worksheet, and a non-contiguous 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?
You need

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 to formula. For example: rather than naming a specific cell in a formula, a relative cell reference might identify a cell three columns to the left of the cell containing the formula. When such a formula is copied, the relative cell references are adjusted to reflect the new location of the formula cell.

6. What is an absolute cell reference? Provide an example.
An absolute cell reference is a cell address, such as $E$14, referenced in a formula that does not change based on the location of the cell that c0ontains the formula.

7. Which function would display the highest value in a range of cells?
MAX Function is the highest fuction value in a range of cells.

8. Which function would display the lowest value in a range of cells?
MIN Function is the lowest function value in a range of cells.

9. Which function returns the arithemetic mean of a range of values?
AVERAGE function returns the arithemetic mean of a range of values.

10. Which function adds the value in a range of cells?
SUM function adds all the values in a range of cells.


11. What feature in Excel can you add that will allow you to sort and filter the records in a spreadsheet?
The feature called Excel table feature, will allow you to sort and fillter the records in a spread sheet

12. What is the plot area in a chart?
The plot area in a chart is the area defined by the x and y axes.

13. What is an axis?
An axis is a horizontal or vertical scale of a chart on which categories and values of categories are plotted.

14. What is the data series?
Is the information in a worksheet column. If you select muliple columns of data for a chart, you'll create multiple data series. Each data series is then represented by its own color bar, line , or column.

15. What is a function? Provide an example.
A built in formula for performing calculations, such as addition, in a table.

16. What is an expression? Provide an example.
An expression is a sort of equation that returns a value. Example: TRUE or FALSE

17. What is an argument? Provide an example.
An argument is the parts of a formula that are variable such as a number.

18. What is nesting?
Nesting means to use a function as an argument within another function.

19. What is a conditional operator? Provide an example.
A conditional operator is a function such as greater than, or less than that determines the numerical value of an item.

20. What is a chart legend?
A chart legend is a guide on a chart that labels parts of it.

21. What data is compared a line chart?
A line chart is most useful in displaying data or information (specifically numerical data) that changes continuously over time

22. What data is compared in a column chart?
A column chart is used to compare the amounts or frequency of occurrence of different characteristics of data.

23. What data is compared in pie chart?
A pie chart is a particularly good illustration when considering how many parts of a whole is inception.

Stock Market Questions

1. What is the ticker symbol?
A ticker symbol is a mnemonic used to uniquely identify publicly-traded shares of a corporation on a particular stock market.
2. Provide one stock exchange where stocks are traded in the United States.
One stock exchange is the New York Stock Exchange.
3. What is the calculation to figure out the initial investment when purchasing a set amount of stocks?
=Amount of stocks purchased x Price of stock
4. What is the calculation to figure out your gain or loss on the stock for each company?
=Current Value – Initial Cost
5. What is the difference between a public and privately held company?
A publicly held company sells stock to the general public and the stock is traded on an exchange. A privately held company does not sell stock to the general public, and the stock is not traded on an exchange. In private firms, the stockholders are usually the principals in the company.