When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the y-axis
What is stock prices?
100
chart that will BEST represent the decline of sales for a music company over the past five years
What is Line?
100
What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of the total merchandise cost
What is Sum?
100
A spreadsheet is created with drop down items that a user can select from
What is list?
100
Which function can a credit card company use to determine the time that has elapsed since a customers payment was received
What is Days360?
200
Jake wants to find out if the size of a fruit has any effect on the total sales for the week of that particular fruit
What is XY Scatter?
200
Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of
What is Primary?
200
Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179.
What is freeze?
200
A chart is created that compares the number of units of Product A sold against the number of units of Product B sold for a period of three months
What is units sold?
200
Purchase discounts are awarded as follows: 3% for sales of $300, 5% for sales of $500, and 9% for sales of $900 or more This function is used to determine which discount is allowed based on the purchase price
What is LookUp?
300
What is a formula that that divides a cell by a cell
What is =E5/E7? Not right without the equal sign.
300
What operation will Eve use to keep rows and columns visible so that they dont scroll off the screen as she moves around the worksheet
What is freeze?
300
chart that will BEST represent each spouses contribution to the total household budget over a period of six months
What is Stacked Bar?
300
When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x axis
What is oil prices?
300
Mrs. Jay uses a spreadsheet to keep track of student test scores and daily grades. Which function should she use to calculate a final grade for each student
What is Average?
400
chart that will BEST represent the effect of increasing the frequency of a companys radio advertisements on sales
What is XY Scatter?
400
followed to ensure that an object does NOT change in a word processing document when it is edited in the spreadsheet of its original creation
What is Embed?
400
In the formula =F10*$J$4, $J$4 is an example of a/an
What is absolute reference?
400
Ernie uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity
What is If?
400
In the formula =F10*$J$4, F10 is an example of a/an
What is relative reference?
500
A chart is created that compares the number units of Product A sold against the number of units of Product B sold for a period of three months
What is months?
500
function that will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise
What is If?
500
chart that will BEST represent a comparison of the average family income in three states, with emphasis on the states
What is Column?
500
chart that will BEST represent the percentage of expenses for office supplies, salaries, and travel for a companys total budget
What is Pie?
500
Which function can an accounting department use in Cell A2 that will result in the current date