1. Which of the following is correct syntax for writing out the following expression in Excel?...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Which of the following is correct syntax for writing out the following expression in Excel? Assume that the variable x has been named "x" in the Name Manager or Name Box. 5. (1+73) 5*(1+3)/(7+x) O=5*(1+3/(7+x)) (5*1)+3/(7+x) =5*1+3/(7+x) 2. What value will be displayed in cell A6 when the Enter key is pressed? Enter your answer as an integer (counting number, no decimals). 1 2 hi 23 4 A Enter answer here B 7 hello 4 12 3 yo C 1 D 5 6 =COUNTBLANK(A1:C4) *COUNTA(A1:C4) 3. We would like to set up a simple Excel worksheet to calculate the number of 24-packs of tiles that we need for a certain tiling job. Tiles are only sold in packs of 24, and we must round up to the nearest multiple of 24 tiles. For example, if we need 155 tiles, then we'd need to round up and purchase 7 x 24-packs (6 x 24-packs would only be 144 tiles, so we need 7 of them). C 155 tiles 7 packs Which of the following formulas (multiple answers possible, and all must be selected for credit) could we place into cell B2 such that the formula would automatically recalculate total number of 24-packs if we were to change the tile number in cell B17 HINT: 2 of these are correct! U A 1 Tiles needed: 2 Packs of 24 needed: =MROUND(B1,24)/24 ROUNDUP(B1/24.0) =CEILING(B1.24)/24 CEILING(B1.24) B 1 point 4. What will the value in cell B4 be when the Enter key is pressed? Leave your answer as an integer (counting number) with no decimals. 123 ti 4 Enter answer here A 2 4 B 12 3 C 1 7 =ROW()*LARGE(A1:C2,3) 1 poi 5. Whose name will appear in cell A1 when Enter is pressed? The name "dwarves" refers to cells A3:46. C 1 =CHOOSE(MOD(11,COUNTA(dwarves)),A3,A4,A5,A6) 2 3 Doc 4 Grumpy 5 Happy 6 Sleepy Doc Happy Sleepy Grumpy A B D E 1 point 1. Which of the following is correct syntax for writing out the following expression in Excel? Assume that the variable x has been named "x" in the Name Manager or Name Box. 5. (1+73) 5*(1+3)/(7+x) O=5*(1+3/(7+x)) (5*1)+3/(7+x) =5*1+3/(7+x) 2. What value will be displayed in cell A6 when the Enter key is pressed? Enter your answer as an integer (counting number, no decimals). 1 2 hi 23 4 A Enter answer here B 7 hello 4 12 3 yo C 1 D 5 6 =COUNTBLANK(A1:C4) *COUNTA(A1:C4) 3. We would like to set up a simple Excel worksheet to calculate the number of 24-packs of tiles that we need for a certain tiling job. Tiles are only sold in packs of 24, and we must round up to the nearest multiple of 24 tiles. For example, if we need 155 tiles, then we'd need to round up and purchase 7 x 24-packs (6 x 24-packs would only be 144 tiles, so we need 7 of them). C 155 tiles 7 packs Which of the following formulas (multiple answers possible, and all must be selected for credit) could we place into cell B2 such that the formula would automatically recalculate total number of 24-packs if we were to change the tile number in cell B17 HINT: 2 of these are correct! U A 1 Tiles needed: 2 Packs of 24 needed: =MROUND(B1,24)/24 ROUNDUP(B1/24.0) =CEILING(B1.24)/24 CEILING(B1.24) B 1 point 4. What will the value in cell B4 be when the Enter key is pressed? Leave your answer as an integer (counting number) with no decimals. 123 ti 4 Enter answer here A 2 4 B 12 3 C 1 7 =ROW()*LARGE(A1:C2,3) 1 poi 5. Whose name will appear in cell A1 when Enter is pressed? The name "dwarves" refers to cells A3:46. C 1 =CHOOSE(MOD(11,COUNTA(dwarves)),A3,A4,A5,A6) 2 3 Doc 4 Grumpy 5 Happy 6 Sleepy Doc Happy Sleepy Grumpy A B D E 1 point
Expert Answer:
Answer rating: 100% (QA)
Question 1 To get an output in excel we need to have symbol at the beginning of the comman... View the full answer
Related Book For
Income Tax Fundamentals 2015
ISBN: 9781305177772
33rd Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven Gill
Posted Date:
Students also viewed these accounting questions
-
Which of the following is not required by generally accepted auditing standards? a. Written representations. b. Attorney letter. c. Management letter. d. Engagement letter.
-
Which of the following is excluded from gross income on an individual's 2017 tax return? a. January 2018 rent received in December 2017. b. Value arising from personal use of company vehicle in 2017....
-
Which of the following is excluded from gross income on an individual's 2016 tax return? a. January 2017 rent received in December 2016 b. Value arising from personal use of company vehicle in 2016...
-
Please complete the Web case that covers material discussed in this chapter at www.cengage.com/accounting/Gibson. Youll be using Thomson ONE Business School Edition, a powerful tool that combines a...
-
Bread & Butter, Inc., is authorized to issue 120,000 shares of common stock and 7,000 shares of preferred stock. During its first year, the business completed the following stock issuance...
-
Type the correct answer in the box. Spell all words correctly. Monica and her team have implemented IS successfully in an organization. What factor leads to successful IS implementation? Good between...
-
Recall, a lis pendens is a notice of pending action. Research where you would record a lis pendens in California. Are there any special requirements for filing a lis pendens? Does a lis pendens...
-
Refer to the information pertaining to Endless Mountain Company that is provided in Integration Exercise 16. In addition to the budget schedules that you prepared in Integration Exercise 16, insert a...
-
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's...
-
Use truth tables to determine whether the following pairs of symbolized statements are logically equivalent, contradictory, consistent, or inconsistent. First, determine whether the pairs of...
-
A manager has the option of purchasing one, two, or three machines. Fixed costs and potential volumes are as follows: Number of Machines 1 2 3 Total Annual Fixed Costs $ 9,600 15,000 20,000...
-
An industrial complex with a small financial budget uses two transformers to supply their internal power system. The transformers are connected to a switch board as shown in the SLD below and...
-
The following transactions occurred for the month of May. Date Units Cost Total Sales Price 1-May Beginning Balance 80 12 $960 2-May Purchase 85 15 $1,275 3-May Purchase 65 11 $715 10-May Sale 90 $30...
-
6. The painting known as "The School of Athens" was painted by Raphael between 1510 and 1511. It is rectangular in shape, with a perimeter of approximately 26.4 m and an area of 42.35 m. Find the...
-
7 5 Solve - +4 for x. X
-
Find the number of x-intercepts of without changing the form of the right-hand side. There is/are i x-intercept(s). y = 1.7(x - 40)
-
You have been asked to advise a city council on a policy decision. They are considering hosting a regional symphony and paying for the cost with tax revenues. The cost of the symphony is $6,000, and...
-
Reduction in sales All of the above 29. Belt of an electric motor is broken, it needs a. Corrective maintenance b. Scheduled maintenance c. Preventive maintenance d. Timely maintenance. 30. The...
-
Carrie loaned her friend $4,500 to buy a used car. She had her friend sign a note with repayment terms and set a reasonable interest rate on the note because the $4,500 was most of her savings. Her...
-
Calculate the amount of the child and dependent care credit allowed for 2014 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...
-
Sam owns an insurance agency and makes the following business gifts during the year. Calculate Sams deduction for business gifts. Amount Donee Ms. Sears (a client) Mr. Williams (a tennis partner, not...
-
A car is modeled as shown in Fig. 6.23. Derive the equations of motion using Newton's second law of motion. Figure 6.23:- x(t) F(t) 21 31 Rigid bar, mass- 2m A G X3(1) F3(t) 5m x2(1) F(t) FIGURE 6.20...
-
Derive the equations of motion, using Newton's second law of motion, for each of the systems shown in Figs. 6.19. 8(t) 2k 2m k 4 M,(t) 000 3k Free Rigid bar, mass = 2m T x(1) F(t) m I X2(1) t F(1)...
-
The equations of motion derived using the displacements of the masses, \(x_{1}, x_{2}\), and \(x_{3}\) as degrees of freedom in Fig. 6.12 (Example 6.10) lead to symmetric mass and stiffness matrices...
Study smarter with the SolutionInn App