1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
blondinia [14]
2 years ago
9

Write two separate formulas using different commands that concatenate " john and "smith" together to form " John Smith"

Computers and Technology
1 answer:
VladimirAG [237]2 years ago
5 0

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

You might be interested in
A sql-6-5.sql file has been opened for you. Write each of the following tasks as a SQL statement in a new line (remember that yo
Ghella [55]

Answer:

The query is as follows:

select sum(stock) as total_stock from products

Explanation:

Required

Return total stock using the alias total_stock from the product table.

The explanation of the query is as follows:

select ----> This implies that data is to be selected from the table

sum(stock) ----> This adds up entries in stock column

as total_stock ---> This represents the alias used for sum(stock)column where

from products  ----> The table being queried

Take for instance, the content of the table is:

SN  Product Stock

1      Apple     5

2     Orange   3

3      Banana   8

The query will return the following table:

total_stock

16

5 0
2 years ago
"in a ________ network, a dedicated communications path is established between two stations through the nodes of the network. th
hammer [34]
<span>"in a point to point network, a dedicated communications path is established between two stations through the nodes of the network. the telephone network is the most common example."</span>
4 0
3 years ago
Declare Integer values[SIZE] = 1, 2, 3, 4, Debugging Exercises 1. What is the error in the following pseudocode? // This program
Nimfa-mama [501]

Answer:

In "Declare String names [SIZE] =", Meg and Jack are done correctly, however for Steve and Bill, there is no ending quote after Steve, and no comma separating the two. More of a common problem than one would think

it should look more like

Declare String names [SIZE] = "Meg", "Jack", "Steve", "Bill", "Lisa"

3 0
3 years ago
g (15 points) Write an SQL statement to list all of the names of students who have not taken a classwith an instructorwho is a f
Blizzard [7]

Answer:

<em>SQL Query</em>

//////////////////////////////////////////////////////////////////////////////////////////////////

select student_name from Student

INNER JOIN Class ON Student.id = Class.student_id

LEFT JOIN Instructor ON Class.instructor_id = Instructor.id

WHERE Instructor.school <> 'Computer Science'

Explanation:

First thing is to select the student_name from <em>Student</em> table.

Next we need to connect with the <em>Class</em> table to get all Students currently taking classes.

Next we need to connect the <em>Class</em> table with the <em>Instructor</em> table, to get all of the Instructors currently teaching class(s).

Finally, we place the Where condition for the acquired instructors to not be from the Computer Science department.

3 0
3 years ago
What term is used for a row of table data in access 2016
enot [183]

Answer:

In Access, table rows are referred to as records. A record is a unit of data that includes every piece of information in a given row.

5 0
3 years ago
Other questions:
  • A private local network, accessible only to an organization's staff, is known as an:
    12·2 answers
  • A digital footprint is all of the information on-line about a person posted by that person or others, ____________. intentionall
    14·1 answer
  • In the software development life cycle, what is the role of participants in the planning phase? The participants’ role in the pl
    6·1 answer
  • are designed to locate information based on the nature and meaning of Web content, not simple keyword matches Select one: a. Cra
    14·1 answer
  • What should be included in the closing portion of your letter or e-mail?
    12·2 answers
  • When searching the web software programs called fetch a few web pages and then they follow the links on those pages and fetch th
    9·2 answers
  • Susan works for a company that values their employees me and deadlines in finding ways to keep the cost of doing business low wh
    12·1 answer
  • Sites on the surface web are _____.
    10·2 answers
  • 4
    12·2 answers
  • Write an algorithm to sum to values
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!