K. Remove . and , from the sentences in built-in sentences vector. Print the total number of words whose length is greater than 5 and less than or equal to 5. You should split all sentences and count the number of words having more than 5 and less than or equal to 5 letters in each sentence. The result will be 818 words having more than 5 letters and 4923 words having less than or equal to 5 words. l. Replace the first and the last letters of each word in the built-in words vector. For instance, “about” should be “tboua”. m. Show all occurrences of word “the” (or “The”) in the first 20 sentences of the built-in sentences vector as shown below

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter2: Formatting Workbook Text And Data
Section: Chapter Questions
Problem 3.21CP
icon
Related questions
Question

K. Remove . and , from the sentences in built-in sentences vector. Print the total
number of words whose length is greater than 5 and less than or equal to 5. You should
split all sentences and count the number of words having more than 5 and less than or
equal to 5 letters in each sentence. The result will be 818 words having more than 5
letters and 4923 words having less than or equal to 5 words.
l. Replace the first and the last letters of each word in the built-in words vector.
For instance, “about” should be “tboua”.
m. Show all occurrences of word “the” (or “The”) in the first 20 sentences of the
built-in sentences vector as shown below

 

Files Plots Packages Help Viewer
Export
Zoom
The birch canoe slid on the smooth planks.
Glue the sheet to the dark blue background.
It's easy to tell the depth of a well.
These days a chicken leg is a rare dish.
Rice is often served in round bowls.
The juice of lemons makes fine punch.
The box was thrown beside the parked truck.
The hogs were fed chopped corn and garbage.
Four hours of steady work faced us.
Large size in stockings is hard to sell.
The boy was there when the sun rose.
A rod is used to catch pink salmon.
The source of the huge river is the clear spring.
Kick the ball straight and follow through.
Help the woman get back to her feet.
A pot of tea helps to pass the evening.
Smoky fires lack flame and heat.
The soft cushion broke the man's fall.
The salt breeze came across from the sea.
The girl at the booth sold fifty bonds.
Transcribed Image Text:Files Plots Packages Help Viewer Export Zoom The birch canoe slid on the smooth planks. Glue the sheet to the dark blue background. It's easy to tell the depth of a well. These days a chicken leg is a rare dish. Rice is often served in round bowls. The juice of lemons makes fine punch. The box was thrown beside the parked truck. The hogs were fed chopped corn and garbage. Four hours of steady work faced us. Large size in stockings is hard to sell. The boy was there when the sun rose. A rod is used to catch pink salmon. The source of the huge river is the clear spring. Kick the ball straight and follow through. Help the woman get back to her feet. A pot of tea helps to pass the evening. Smoky fires lack flame and heat. The soft cushion broke the man's fall. The salt breeze came across from the sea. The girl at the booth sold fifty bonds.
Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Knowledge Booster
Randomized Select Algorithm
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage