ZuoTi.Pro
Question

Microsoft Excel Question Which of the following 4 options is the correct answer for this question...

Microsoft Excel Question

Which of the following 4 options is the correct answer for this question ?
How does the SUM function handle cells that do not contain a number?

  • Excel treats text cell values as 1. If there are no numbers in the SUM range, Excel displays an error message.

  • Excel doesn't let you enter a SUM function if the range contains any nonnumerical values.

  • Excel displays an error if any of the cells in the SUM range contain text data.

  • Excel treats text cell values as 0. If there are no numbers in the SUM range, Excel displays an error message.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

How does the SUM function handle cells that do not contain a number?

Ans:  

When i try to execute a SUM function in a Microsoft Excel that do not contain a number i get that SUM function treated cell values are 0 so answer is....

Excel treats text cell values as 0. If there are no numbers in the SUM range, Excel displays an error message.

0 0
Add a comment
Know the answer?
Add Answer to:
Microsoft Excel Question Which of the following 4 options is the correct answer for this question...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please Answer all these. Those questions are from New Perspectives Microsoft Office 365 & Excel 2016...

    Please Answer all these. Those questions are from New Perspectives Microsoft Office 365 & Excel 2016 . Need answers from Excel concern : 1. What formula would you enter to add the values in cells C1, C2, and C3? What function would you enter to achieve the same result? 2. What formula would you enter to count how many numeric values are in the range D21:D72? 3. If you insert cells into the range C1:D10, shifting the cells to the...

  • For those unfamiliar with Microsoft Excel, this introduction will be very useful. Those familiar with Microsoft...

    For those unfamiliar with Microsoft Excel, this introduction will be very useful. Those familiar with Microsoft Excel may skim this section. This lab will use Excel, as you will have a lot of data and calculations to keep organized and Excel is excellent for that. If you wish to perform a calculation, you must begin the calculation with an equals sign (). This is Excel's magic "we're doing math, now" button. For example, if you wished to multiply 6 times...

  • All questions are multi answer (choose two or more options). 6.When formatting cells, which of the...

    All questions are multi answer (choose two or more options). 6.When formatting cells, which of the following are true about the number category? a. can have up to 5 decimal places b. formats without an asterisk are not affected by operating system settings c. can include general d. can include number e. can have up to 255 decimal places 7.In Excel, which of the following are not true about the IF function? a. It can have two results b. It...

  • Which of the following statements about Excel is Correct? We should copy numbers rather than formulas...

    Which of the following statements about Excel is Correct? We should copy numbers rather than formulas It's a good idea to put actual numbers in the cells Check cell references before copying It's useless to check the copied cells to make sure formulas are correctly setup. Question 5 (1 point) Which of the following copies formulas to all the cells below till the last cell? Drag None Ctri+C and Ctri+V Drop down Question 6 (1 point) In Excel spreadsheet, the...

  • Chapter 9 Excel - Managerial ACC Need formulas! Budgets

    Required informationSkip to question  The Chapter 9 Form worksheet is to be used to create your own worksheet version of the Review Problem example in the text.Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B30 enter the formula "= B20". Notes: In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell C31 would be "=ABS(E31−B31)". Cells...

  • Only show me the Answers. No steps. QUESTION 41 By default, Microsoft Excel 2016 displays pages...

    Only show me the Answers. No steps. QUESTION 41 By default, Microsoft Excel 2016 displays pages ready to print in the landscape orientation. True False 1.5 points    QUESTION 42 Which of the following can you do to edit cell contents directly in a cell? a. ?Right-click the cell, and select format. b. ?Select the cell, and press the F1 key. c. ?Double-click the cell. d. ?Drag the cell down to the sheet tab. 1.5 points    QUESTION 43 Which...

  • Please answer the questions in yellow using an Excel Formula Answers must be written using an...

    Please answer the questions in yellow using an Excel Formula Answers must be written using an Excel Formula Thank You 4 111 A B D F G H 1 J K 107 Basic Functions 108 The AVERAGE function averages the cells that have numeric values. 109 Write a formula in the yellow cell immediately below that sets the value of cell equal to the average of the eight grey cells in the range F110:1111. 110 4 5 2 9 text...

  • Managerial Accounting - Flexible Budgets/Performance Analysis Excel NEED FORMULAS

    <p><p class="question"><br/></p><p><strong>Download the Applying Excel form and enter formulas in all cells that contain question marks.</strong></p><p> </p><p>For example, in cell B30 enter the formula "= B20".</p><p> </p><p>Notes:</p><p> </p><p>In the text, variances are always displayed as positive numbers. To accomplish this, you can use the ABS() function in Excel. For example, the formula in cell C31 would be "=ABS(E31−B31)".</p><p> </p><p>Cells D31 through D39 and G31 through G39 already contain formulas to compute and display whether variances are Favorable or Unfavorable. Do not enter data or...

  • 1. Given the following peptide, which of the following statements is true? Question options: a) The...

    1. Given the following peptide, which of the following statements is true? Question options: a) The N-terminal residue is leucine. b)This peptide contains 4 amino acid residues. c) The peptide contains a total of 6 ionizable groups. d) The net charge of this peptide at pH 7 is +1 Locate any peptide bond along the backbone of the given peptide. e) The bond between the C (of the C=O) and the N (of the N-H) of a peptide bond has...

  • QUESTION 3 In the following image, appropriate the EXCEL formula-cOUNTIFIA"5" Locationx r. x..r, and .r: appropriate...

    QUESTION 3 In the following image, appropriate the EXCEL formula-cOUNTIFIA"5" Locationx r. x..r, and .r: appropriate row values are named·A·"B", "G-, what is the result from a. None of the other answers O b. Some other number QUESTION 4 In EXCEL, if cell A3 contains the value SO, then the calculated result for the EXCEL formula -IFA3-50,1.p is. O a. an error message. C. FALSE Od.1 Chiek Save and Submit to save and submit.Click Save All Ansuwers to save all...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT