Which function is used to merge text from different cells?COUNT CONCATENATE SUM IF
Added by Nicole B.
Step 1
The goal is to merge text from different cells. Show more…
Show all steps
Your feedback will help us improve your experience
Aparna Shakti and 81 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
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.
Modified True or False: Write TRUE if the statement is correct. If the statement is false, change the underlined word or phrase to make the whole statement correct. Write your answer on a separate sheet of paper. 1. Microsoft Excel can perform mathematical equations. 2. Range, criteria, and logical test are part of the AVERAGEIF syntax. 3. Excel formulas always begin with a sign. 4. Excel can be used to create a database. 5. Column J and row 9 is also referred to as cell 9J. 6. AVERAGE function used to get the average of a certain range of cells if a condition is met. 7. SUMIF function adds all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell. 8. Both IF and AVERAGEIF can perform a logical test. 9. Asterisk (*) symbol is used to multiply items in Excel. 10. SUMIF function adds values that meet a given criteria. 11. IF function can have two results. 12. Functions are mathematical equations that calculates the value of a cell. 13. The intersection of rows and columns is called cell reference. 14. AVERAGEIF function returns the arithmetic mean of all the cells in a range that meet a given criteria. 15. In Excel, the active cell is indicated by an underline.
Shu N.
D. Multiple Choice Questions: 1. To use the Sheet reference, which address is appropriate out of the following options? a. D4! Sheet1 b. Sheet1, D4 c. Sheet1! D4 2. Which key combination is used to get the sum of the values of adjacent cells? a. Shift + S b. Ctrl + C c. Alt + = 3. Which function finds the largest number in a range? a. AVERAGE() b. COUNT() c. MAX() 4. Which of the given cell references can be used in a relative reference? a. $D6 b. A3 c. A$1 5. Which function is used to count the number of numeric values in a range? a. COUNT() b. SUM() c. COUNTNUMBERS()
Tanvi G.
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