78 % (933 Review)

Please review the following questions and answers for me and if possible give me correct answers I need to submit this assignment as soon as possible

Question 1 of 20 5.0 Points Excel uses the __________ symbol in formulas requiring the division of one cell into another.

A. \

B. *

C. /

D. ` Reset Selection

Mark for Review What's This?

Question 2 of 20 5.0 Points You are inputting data into the cells of an Excel Worksheet. The AutoComplete can assist you with:

A. words that are used as common business terms.

B. words that have been used in prior cells.

C. numbers and figures that have been used in prior cells.

D. words and numbers that have been used in prior cells. Reset Selection

Mark for Review What's This?

Question 3 of 20 5.0 Points You have applied a multiplication formula to cells C7:C18. In Cell C19 there is an entry that looks like ########. Why is this?

A. One of the entries in the C column is not a number.

B. One of the entries in the C column has too many 0 s after the decimal.

C. The formula was not entered correctly when created.

D. The column is too narrow to display the number in C19. Reset Selection

Mark for Review What's This?

Question 4 of 20 5.0 Points What do the buttons do in Excel 2007?

A. Increase and decrease the number of decimal places for inputted cell values

B. Apply a formula in the clipboard to the left or right of the active cell

C. Convert the numbers in highlighted cells to currency entries with or without the $ symbol

D. Expand or decrease the range for a formula within the row holding the active cell Reset Selection

Mark for Review What's This?

Question 5 of 20 5.0 Points A dollar sign ($) in a formula indicates that:

A. a financial formula is being referenced.

B. you want to display the Formula Auditing toolbar.

C. a cell reference will not change when copied.

D. the values in all rows and columns will retain their absolute values when copied. Reset Selection

Mark for Review What's This?

Question 6 of 20 5.0 Points You type in the value, 56.4235, into the active cell. You then click the Percentage Style button. What will the cell show when complete?

A. 56.4235%

B. 56.4235%

C. 56.42%

D. 56% Reset Selection

Mark for Review What's This?

Question 7 of 20 5.0 Points You want to create a chart sheet for the bar chart you have created in your Excel 2007 worksheet. What must you do to accomplish this?

A. Click the Chart Sheet button on the Design Tab Ribbon.

B. Click the New Sheet button on the Design Tab Ribbon.

C. Click the Move Chart button on the Design Tab Ribbon.

D. Click the Copy Chart button on the Design Tab Ribbon. Reset Selection

Mark for Review What's This?

Question 8 of 20 5.0 Points You have created a chart in your Excel 2007 Worksheet. To enhance the look you decide to make it three-dimensional. How do you accomplish this?

A. Click the Format tab Shape Effects 3-D Effects.

B. Click the Format tab Shape Effects Bevel - 3-D Options.

C. Click the Design tab Shape Effects 3-D Options.

D. Click the Design tab Shape Effects 3-D Effects. Reset Selection

Mark for Review What's This?

Question 9 of 20 5.0 Points You are creating a pie chart showing the various divisions and their profit contribution to the company. You want to make your division stand out from the rest. What is the best way to do this?

A. Make your division s slice red.

B. Make your division s slice 3-D.

C. Format your division s slice with a shadow.

D. Explode your division s slice. Reset Selection

Mark for Review What's This?

Question 10 of 20 5.0 Points Your boss has asked you to create a basic spreadsheet that will show the Gross Profit Margin of the company. Cell F5 has the total sales figure, G5 has the total cost figure, and H5 has the total taxes paid. What formula below would calculate the Gross Profit Margin?

A. =F5-G5

B. =F5-G5-H5

C. =F5-(G5+H5)

D. SUM=F5-G5-H5 Reset Selection

Mark for Review What's This?

Question 11 of 20 5.0 Points You want to create a Headline Title for your chart and format it with graphic-like effects such as 3-D Rotations or Shadows. How do you accomplish this?

A. Type out the headline, select it, and click the Text Effects button on the Format tab Ribbon.

B. Type out the headline, select it, and click the Text Effects button on the Design tab Ribbon.

C. Click the WordArt button on the Insert tab, type out the headline, and the select the desired text effects.

D. Type out the headline, select it, and right-click and select the text effects option to select the desired text effects Reset Selection

Mark for Review What's This?

Question 12 of 20 5.0 Points Before printing an Excel 2007 worksheet that uses multiple data or chart sheets, you should use __________ to see how it looks.

A. Normal Layout

B. Page Layout

C. Presentation Layout

D. Chart Sheet Layout Reset Selection

Mark for Review What's This?

Question 13 of 20 5.0 Points You have created an extensive Excel file consisting of numerous worksheets. You want to print all of your work. What option would you click under Print in order to ensure that the entire file is printed?

A. Active sheets

B. All sheets

C. Selected sheets

D. Entire workbook Reset Selection

Mark for Review What's This?

Question 14 of 20 5.0 Points You are creating an Excel worksheet to do some forecasting for next year. Your company has a contract with its suppliers and employees for next year so your costs are known. You need to figure out how much you need to charge for your products in order to obtain a profit margin of 8 percent. This would be an ideal situation to use the __________ of Excel 2007.

A. PMT Function

B. Gross Profit Margin

C. Goal Seek

D. Forecast Function Reset Selection

Mark for Review What's This?

Question 15 of 20 5.0 Points Your business buys a shipment of gasoline every week for your fleet of delivery vans. You want to find the average cost for each weekly order over the past year. To accomplish this, you would use a __________ in Excel 2007.

A. Logical function

B. Statistical function

C. Financial function

D. Lookup and Reference function Reset Selection

Mark for Review What's This?

Question 16 of 20 5.0 Points How does the Median function result in a more accurate calculation than the Average function?

A. The AVERAGE function can be distorted by a single value greatly different than the others.

B. The AVERAGE function utilizes the standard deviation of the values in its calculations.

C. The MEDIAN function utilizes the MIN function as a subcalculation to make its calculations.

D. The MEDIAN function simply divides the sum total by the number values in the group. Reset Selection

Mark for Review What's This?

Question 17 of 20 5.0 Points You have a function in your Excel worksheet that consists of 850 cell values. To determine the highest value that was used in the formula, you would need to use the __________ function.

A. >

B. MEDIAN

C. LARGEST

D. MAX Reset Selection

Mark for Review What's This?

Question 18 of 20 5.0 Points In order to learn more about your customers, you have asked each customer to give you his or her age when making a purchase, and you have inputted all the ages into an Excel worksheet. You want to find out how many customers are between the ages of 35 and 44. You would need to use the __________ function.

A. MEDIAN

B. MIN

C. SEARCH

D. CONTIF Reset Selection

Mark for Review What's This?

Question 19 of 20 5.0 Points What does the <> operator mean within an Excel 2007 function?

A. Mean

B. Not equal to

C. Not included

D. Average Reset Selection

Mark for Review What's This?

Question 20 of 20 5.0 Points When you want to __________ in an Excel 2007 worksheet, you would utilize the data bars.

A. include a comment for each cell within a formula

B. add a visual effect and create a bar graph to illustrate the data

C. add visual cues to denote the value of each cell

D. use graphics instead of functions to create data points Reset Selection

The answers are as follows please verify and if possible give me the correct ones 1.C 2.B 3.C 4.A 5.D 6.C 7.B 8.D 9.B 10.C 11.D 12.B 13.D 14.B 15.A 16.A 17.D 18.C 19.D

Your answer will be ready within 2-4 hrs. Meanwhile, check out other millions of Q&As and Solutions Manual we have in our catalog.