Which function should we use when we want to count the number of cells that are not blank? ? COUNT function ? SUM function ? ABS function ? COUNTA function ? CONCATENATE function
Added by Katherine P.
Close
Step 1
Step 1: The COUNTA function counts the number of cells that are not empty. Show more…
Show all steps
Your feedback will help us improve your experience
Lucas Finney and 66 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Lucas F.
How does Excel represent internally the values we see on a spreadsheet? a) Some values are represented as numbers and others as letters and symbols. b) Each digit is represented as a specific alphanumeric code. c) All of the values, regardless of type, are represented as numbers. d) All of the values are represented according to their particular types. What is the symbol in Excel that indicates that what follows it is an expression? a) "" b) @ c) = d) -> Which of the following Excel functions will return the number of cells in a range by adding the values that match specified criteria? COUNTIF AVERAGEIF SUBTOTAL SUMIF
Aparna S.
Complete this statement: To be able to create an automatic outline in a table, that table must contain ______________ (sum, average, count, etc)
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD