Question

Which of the following formulas properly produces the string “Income Statement”?​

Answer 1

="Income"&" "&"Statement" properly produces the string "Income Statement".

(B) ="Income"&" "&"Statement"

Let's complete the question

Which of the following formulas properly produces the string “Income Statement”?​

(A) ="Income"+"Statement"

(B) ="Income"&" "&"Statement"

(C) =Income&Statement

(D) ="Income"&"Statement"

Explanation

& symbol or the ampersand symbol is used to join or concatenate two or more strings. It is also called a concatenation operator.

" " is used to add a space between the joined strings so, that we can easily read it.

(A) ="Income"+"Statement"

This will not produce any value

(B) ="Income"&" "&"Statement"

This will produce value Income Statement

(C) =Income&Statement

This will not produce any value.

(D) ="Income"&"Statement"

This will produce value IncomeStatement

Extra Information

Function is a predefined formula that allows users to perform mathematical, statistical, and logical operations.

There are various functions in Microsoft Excel some of them are:

1. SUM

2. AVERAGE

3. COUNT

4. IF

5. MAX

6. MIN

Format of writing a function in a cell of Excel Spreadsheet:

= Name of Function (Range of Cells)

Example:

Suppose you want to add values present in cells from A1 to A5 and display the sum in A6.

First, write the values in A1 to A5 and then click on A6 cell and type =SUM(A1:A5)

After that press "Enter"

In the A6 cell, you will get the sum of values present in cells from A1 to A5.

In case you have typed the wrong formula or want to modify it then you can click on the cell where you have written the formula and there will be a Formula Bar available above the worksheet area which will show the formula which you have written in the cell and you can edit it.