The amount in Cell F9 is the result of which operation?

The amount in Cell C10 is the result of which function?

The amount in Cell F6 is the result of which operation?

The automatic completion of the numbers in Cells A5:A8 is the result of:

The alignment of the main heading in Row 1 is the result of which of which formatting?

The size of Column B is the result of what formatting?

What formatting resulted in the placement of data in Cells C4 and D4?

The formatting applied to the data in Cell F9 is an example of:

In the Corner Bistro spreadsheet, if the Bonus is calculated using the date in Figure A, what function is used?

Figure A

In the Corner Bistro spreadsheet, which function will result in the total number of employees when applied to Cells B5:B22?

In the Corner Bistro spreadsheet, if the dairy manage wishes to view the data for her/his department only, she/he should use:

In the Corner Bistro spreadsheet, the format applied to Rows 1-7 is an example of which operation?

In the Corner Bistro spreadsheet, the data has been sorted by which column?

The number of hours worked is record in Cell D7.  Hourly rate is recorded in Cell E7.  Overtime hours occur anytime the number of hours worked is greather than 40.  Which formula correctly determines how many (if any) overtime hours have occured?

Purchase discounts are awarded as follows:  3% for sales of $300, 5% for sales of $500, and 9% for sales of $900 or more.  What funtion is used to determine which discount is allowed based on the purchase price?

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.  This is an example of which operation?

If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he use?

What procedure should be 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?

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.  Which function should he use?

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.  Which data appears on the y-axis?

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.  Which data appears on the x-axis?

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?

Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom.  GPA is an example of which part of the sort operation?

What operation will Eve use to keep rows and columns visible so that  they don't scroll off the screen as she moves around the worksheet?

What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?

Which function can a credit card company use to determine the time that has elapsed since a customer's payment was received?

What function will calculate the total cost of merchandise plus the tax calculated at a rate of 7.5% of total merchandise cost?

What function will display the word"Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise?

What function shold Eva use to calculate her final grade if her exam count 25%, her test grades count 25%, and her daily work counts 50%?

A spreadsheet is created with drop down items that a user can select from.  This is an example of which funtion?

When createing a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the y-axis?

When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x-axis?

Which chart will BEST represent a comparison of the average family income in three states, with emphasis on the states?

Which chart will BEST represent each spouse's contribution to the total household budget over a period of six months?

Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?

Which chart will BEST represent the effect of increasing the frequency of a company's radio advertisements on sales?

If 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 chart should he use?

Which function can an accounting department use in Cell A2 that will result in the current date?

What formula will divide the value in Cell E5 by the value in Cell E6?

Which chart will BEST represent the decline of sales for a music company over the past five years?

In the EZ Credit spreadsheet, the customer numbers listed in Column A are the result of which operation?

In the EZ Credit spreadsheet, which function will result in the total number of entries in the cell range B5:B14?

In the EZ Credit spreadsheet, the date in Column F is the result of which function?

In the EZ Credit spreadsheet, the data in Column G is the result of which formula?

In the EZ Credit spreadsheet, the data in Cell B15 is the result of which function?

In the EZ Credit spreadsheet, the data in Cell B17 is the result

of which function?

In the above figure, the placement of the individual income items in Cells A3:A6 and the expense items in Cells A8:A15 is the result of which formatting?

In the above figure, the Net Income/Loss value in Cell C16 is the result of which operation?

In the above figure, which operation was used to calculate the value in Cell C6?

In the above figure, which operatio was used to calculate in the value in Cell C15?

In the above figure, what formatting was applied to result in the appearance of Cell C6?