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
Answer:
Excel file formats
Format Extension
Excel Workbook .xlsx
Excel Macro-Enabled Workbook (code) .xlsm
Excel Binary Workbook .xlsb
Template .xltx
Answer:
This is an Ethernet port operating at half duplex.
Explanation:
Modern Ethernet networks built with switches and full-duplex connections no longer utilize CSMA/CD. CSMA/CD is only used in obsolete shared media Ethernet (which uses repeater or hub).
Try resending it isn't there a button to resend the email? and look in spam
Answer:
numMugs=input(); #take input from the user and store it on a numMugs variable.
print ('Number of mugs:'+numMugs) #print the numMugs variable value with the Number of mugs: line.
Output:
- If the input is 8 then the program is print Number of mugs: 8.
- If the input is 'Harry' then the program is print Number of mugs: Harry.
Explanation:
- The above program is in python language with the two statements one in input and the other is output.
- The first line takes input and stores it into a variable named "numMugs".
- The second line print the value as Number of mugs: value_of_numMugs.
- The above program works for any type of input. It can work for the string data type or integer data type or character data type or any other data type.
