Answer:
The orientation option
Explanation:
Orientation in excel allows you to rotate text in several different ways. We can used this option to spice things up a bit. There are several kinds of orientation. There is one where the orientation can be rotated and the other one where the text can be either be put in a vertical or diagonal fashion.
Data is the fundamental reason AI succeeds or fails.
This statement is true regarding Artificial Intelligence (AI)
Answer:
1. =CONCATENATE(" John"," ","Smith")
2. =(" John"&" "&"Smith")
Explanation:
Given
Two separate strings; "John" and "Smith"
Required
2 separate formulas to concatenate both strings to form " John Smith"
There are several ways to concatenate strings in Microsoft Office Excel; one of the methods is using the concatenate function while the another method is using the traditional & operator.
Using the concatenate function, the formula is as follows
=CONCATENATE(" John"," ","Smith")
This function will combine the " John", " " and "Smith" to give a new string " John Smith" (without the quotes).
Using the traditional & operator may be a little bit difficult (and not frequently used) but the formula is as follows;
=(" John"&" "&"Smith")
The result will be the same as (1) above
The AUTO FORMATTING ONLY is an auto fill option that fills the destination area using the format of the source area; no content is filled. This is opposite from auto without formatting on which it fills the destination area without formatting.
