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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Data And Information Quality Dimensions, Principles And Techniques
Authors: Carlo Batini, Monica Scannapieco
1st Edition
3319241060, 9783319241067
