LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
119 views
in General by (54.3k points)
closed by

In MS Excel, ______ text function is useful for combining values from different cells into a single cell.


1. ADD
2. SUM
3. CONCATENATE 
4. MERGE

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 3 : CONCATENATE 

The correct answer is CONCATENATE .

CONCATENATE:

  • This function joins two or more text strings into one text string.

its syntax is :

  • CONCATENATE (text1, text2,...).
  • The text items can be text strings, numbers, or single-cell references.

Some important mathematical functions used in MS Excel are:

  • SUM
  • AVERAGE
  • AVERAGEIF
  • COUNTA
  • COUNTIF
  • MOD
  • ROUND 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...