How can you extract an intermediary step from a query and convert it into a separate query?

A. Convert the entire query into a record, then reference the desired step using its position in the record.

D. Use the promote headers function and then reference the desired step.

C. There is no way to extract intermediary steps in Power Query.

B. Edit the query by duplicating the desired step.

Which method avoids hardcoding column names when dynamically expanding tables using the table.combine function?

A. Convert all tables into a list before using table.combine.

B. Use the expand function multiple times.

C. Manually reference each table by name in the table.combine function.

D. Dynamically expanding tables is not possible in Power Query.

What is the purpose of using projections in Power Query?

A. To select specific columns from a table in a different way than using table.selectcolumns.

B. To promote headers in a table.

D. Projections are not a feature in Power Query.

Which data types can be checked using the is keyword in Power Query?

A. Numbers, Text, Lists, Records, and Tables.

D. The is keyword cannot be used for data type checks.

What does the & operator do in Power Query when used with lists?

A. Combines two lists into a single list.

B. Subtracts one list from another.

D. The & operator cannot be used with lists.

What does the & operator do in Power Query when used with tables?

A. Combines two tables into a single table, but may result in a haphazard combination if the tables are not structured similarly.

B. Subtracts one table from another.

D. The & operator cannot be used with tables.

C. Merges two tables based on a common column.

Which of the following statements is true about using the sections# keyword in Power BI?

A. It works in Excel but not in Power BI.

B. It can be used to dynamically reference all queries and load them into Power BI.

C. It can be used to edit existing queries in Power BI.

D. The sections# keyword is not available in Power BI.

What are two ways to extract an intermediary step from a query as mentioned in the video?

A. 1. Convert the entire query into a record, then reference the desired step using its position in the record. 2. Use the meta keyword to store the desired step as metadata and then reference it in another query.

C. By promoting the desired step using the promote headers function.

A. There is no way to extract intermediary steps in Power Query.

B. By duplicating the desired step in the query editor.

I Bet You Don't Know All These Power Query Tricks

A BAD CASE OF THE STRIPES By David Shannon Parts(18): Camilla Narrator 1 Narrator 2 Narrator 3 Narrator 4 Mr. Harms Mother Father Dr. Bumble Old Woman Environmental Therapist Dr. Grop Dr. Gourd Dr. Sponge Mr. Mellon Dr. Cricket Dr. Young <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Narrator 1: A BAD CASE OF THE STRIPES By David Shannon Narrator 2: Camilla Cream loved lima beans. But she never ate them. Narrator 3: All of her friends hated lima beans, and she wanted to fit in. Camilla always worried about what other people thought of her. Narrator 4: Today she was fretting even more than usual. It was the very first day of school, and she couldn't decide what to wear. There were so many people to impress! Narrator 1: She tried on forty-two outfits, but none seemed quite right. She put on a pretty red dress and looked in the mirror. Then she screamed. Narrator 2: Her mother ran into the room, and she screamed, too. Mother: "Oh my heavens! You're completely covered with stripes!" Narrator 3: she cried. This was certainly true. Camilla was striped from head to toe. She looked like a rainbow. Narrator 4: Mrs. Cream felt Camilla's forehead. Mother: "Do you feel all right?" Narrator 1: she asked. Camilla: "I feel fine, but just look at me!" Narrator 2: Camilla answered. Mother: "You get back in bed this instant. You're not going to school today." Narrator 3: her mother ordered. Camilla was relieved. She didn't want to miss the first day of school, but she was afraid of what the other kids would say. And she had no idea what to wear with those crazy stripes. Narrator 4: That afternoon, Dr. Bumble came to examine Camilla. Dr. Bumble: "Most extraordinary! I've never seen anything like it! Are you having any coughing, sneezing, runny nose, aches, pains, chills, hot flashes, dizziness, drowsiness, shortness of breath, or uncontrollable twitching?" Narrator 1: he asked. Camilla: "No, I feel fine." Narrator 2: Camilla told him. Dr. Bumble: "Well then, I don't see any reason why she shouldn't go to school tomorrow. Here's some ointment that should help clear up those stripes in a few days. If it doesn't, you know where to reach me." Narrator 3: Dr. Bumble said, turning to Mrs. Cream. And off he went. Narrator 4: The next day was a disaster. Everyone at school laughed at Camilla. They called her "Camilla Crayon" and "Night of the Living Lollipop." Narrator 1: She tried her best to act as if everything were normal, but when the class said the Pledge of Allegiance, her stripes turned red, white, and blue, and she broke out in stars! Narrator 2: The other kids thought this was great. One yelled out, Narrator 3: "Let's see some purple polka dots!" Narrator 4: Sure enough, Camilla turned all purple polka-dotty. Someone else shouted, Narrator 1: "Checkerboard!" Narrator 4: and a pattern of squares covered her skin. Soon everyone was calling out different shapes and colors, and poor Camilla was changing faster than you can change channels on a T.V. Narrator 2: That night, Mr. Harms, the school principal, called. Mr. Harms: "I'm sorry, Mrs. Cream, I'm going to have to ask you to keep Camilla home from school. She's just too much of a distraction, and I've been getting phone calls from the other parents. They're afraid those stripes may be contagious." Narrator 3: he said. Camilla was so embarrassed. She couldn't believe that two days ago everyone liked her. Now, nobody wanted to be in the same room with her. Narrator 1: Her father tried to make her feel better. Father: "Is there anything I can get you, sweetheart?" Narrator 2: he asked. Camilla: "No, thank you," Narrator 3: sighed Camilla. What she really wanted was a nice plate of lima beans, but she had been laughed at enough for one day. Dr. Bumble: "Hmm, well, yes, I see. I think I'd better bring in the Specialists. We'll be right over.” Narrator 4: said Dr. Bumble to Mr. Cream on the phone. About an hour later, Dr. Bumble arrived with four people in long white coats. He introduced them to the Creams. Dr. Bumble: "This is Dr. Grop, Dr. Sponge, Dr. Cricket, and Dr. Young." Narrator 1: Then the Specialists went to work on Camilla. They squeezed and jabbed, tapped and tested. It was very uncomfortable. Dr. Grop: "Well, it's not the mumps." Dr. Sponge: "Or the measles." Dr. Cricket:"Definitely not chicken pox." Dr. Young: "Or sunburn." Narrator 2: replied the Specialists. Specialists:"Try these. Take one of each before bed." Narrator 4: said the specialists. They each handed her a bottle filled with different colored pills. Then they filed out the front door followed by Dr. Bumble. Narrator 1: That night, Camilla took her medicine. It was awful. Narrator 2: When she woke up the next morning, she did feel different, but when she got dressed, her clothes didn't fit right. She looked in the mirror, and there, staring back at her, was a giant, multi-colored pill with a face on it. Narrator 3: Dr. Bumble rushed over as soon as Mrs. Cream called. But this time, instead of the Specialists, he brought the Experts. Narrator 4: Dr. Gourd and Mr. Mellon were the finest scientific minds in the land. Once again, Camilla was poked and prodded, looked at and listened to. Narrator 1: The Experts wrote down lots of numbers. Then they huddled together and whispered. Dr. Gourd finally spoke. Dr. Gourd: "It might be a virus," Narrator 2: he announced with authority. Suddenly, fuzzy little virus balls appeared all over Camilla. Mr. Mellon: "Or possibly some form of bacteria," Narrator 3: said Mr. Mellon. Out popped squiggly little bacteria tails. Dr. Gourd: "Or it could be a fungus," Narrator 4: added Dr. Gourd. Instantly, Camilla was covered with different colored fungus blotches. The experts looked at Camilla, then each other. Experts: "We need to go over these numbers again back at the lab. We’ll call you when we know something," Narrator 1: said the Experts. But the Experts didn't have a clue, much less a cure. Narrator 2: By now, the T.V. news had found out about Camilla. Reporters from every channel were outside her house, telling the story of "The Bizarre Case of the Incredible Changing Kid." Narrator 3: Soon a huge crowd was camped out on the front lawn. Narrator 4: The Creams were swamped with all kinds of remedies from psychologists, allergists, herbalists, nutritionists, psychics, an old medicine man, a guru, and even a veterinarian. Narrator 1: Each so-called cure only added to poor Camilla's strange appearance until it was hard to even recognize her. She sprouted roots and berries and crystals and feathers and a long furry tail. But nothing worked. Narrator 2: One day, a woman who called herself an Environmental Therapist claimed she could cure Camilla. She said, Environmental Therapist: "Close your eyes, breathe deeply, and become one with your room." Camilla: "I wish you hadn't said that," Narrator 3: Camilla groaned. Slowly, she started to melt into the walls of her room. Her bed became her mouth, her nose was a dresser, and two paintings were her eyes. The therapist screamed and ran from the house. Mother: "What are we going to do? It just keeps getting worse and worse!" Narrator 4: cried Mrs. Cream. She began to sob. Narrator 1: At that moment, Mr. Cream heard a quiet little knock at the front door. He opened it, and there stood an old woman who was just as plump and sweet as a strawberry. Old Woman: "Excuse me, but I think I can help." Narrator 2: she said brightly. Narrator 3: She went into Camilla's room and looked around. Old Woman: "My goodness, what we have here is a bad case of the stripes. One of the worst I've ever seen!" Narrator 4: she said with a shake of her head. She pulled a container of small green beans from her bag. She said, Old Woman: "Here. These might do the trick." Mother: "Are those magic beans?" Narrator 1: asked Mrs. Cream. The old woman replied, Old Woman: "Oh my, no, there's no such thing. These are just plain old lima beans. I'll bet you'd like some, wouldn't you?" Narrator 2: she asked Camilla. Camilla wanted a big, heaping plateful of lima beans more than just about anything, but she was still afraid to admit it. She said, Camilla: "Yuck! No one likes lima beans, especially me!" Old Woman: "Oh, dear, I guess I was wrong about you." Narrator 3: said the old woman sadly. She put the beans back in her bag and started toward the door. Narrator 4: Camilla watched the old woman walk away. Those beans would taste so good. And being laughed at for eating them was nothing, compared to what she'd been going through. She finally couldn't stand it. Camilla: "Wait! The truth is...I really love lima beans." Narrator 1: she cried. The old woman smiled, popping a handful of beans into Camilla's mouth, and said, Old Woman: "I thought so." Camilla: "Mmmmmmm," Narrator 2: said Camilla. Suddenly the branches, feathers, and squiggly tails began to disappear.Then the whole room swirled around. When it stopped, there stood Camilla, and everything was back to normal. Camilla: "I'm cured!" Narrator 3: she shouted. The old woman said, Old Woman: "Yes, I knew the real you was in there somewhere." Narrator 4: She patted Camilla on the head and went outside and vanished into the crowd. Narrator 1: Afterward, Camilla wasn't quite the same. Narrator 2: Some of the kids at school said she was weird, but she didn't care a bit. Narrator 3: She ate all the lima beans she wanted, and she never had even a touch of stripes again.

Write 5 multiple choice questions for the following transcript ...Setting goals and budgeting. [tranquil music] Getting where you want to be involves three important skills. Setting realistic goals, knowing your net worth, and budgeting. [energetic music] Setting goals is a way to get control of your life. A goal is not the same as a dream. It's not pie in the sky stuff. It's something that's achievable and it comes with a time frame. If you have a big goal, like buying a house in five years' time, you might need a plan that involves a whole series of mini goals to get you there in stages. The important is finding something you know you can do. Most people find longterm goals hard to stick to. Don't worry about it. If 10 years seems too far away, set your horizons a little closer. Give yourself a set sum of money to save in the next few years. You can use it as a springboard to get to your next goal and it'll get you in the savings habit. Changes in your life circumstances may also affect your goal, so use this opportunity to review them. Think about your financial goals when you have some quiet time. It may sound a little obsessive, but write down what they are and how you're going to achieve them. Be specific, be realistic, and always, always keep your goals within reach. Achieving a goal is a great excuse to celebrate, so don't forget to reward yourself for your achievement. [energetic music] Imagine if tomorrow you had to sell everything you own and pay off everything you owe the bank or anyone else, would you be left with much? Would you be left with anything? That figure is called your net worth. It's a measure of your actual financial wealth and growing it over time is what getting sorted is all about. Use Sorted's net work calculator to find out where you're at. Decide what you want your net worth to be in a year's time. Think about your cash and other assets and work out how you might get there. Monitoring and growing your net worth over time is the thing that will eventually get you to retirement in good shape. [energetic music] Budgeting is another one of those, I can't believe I didn't do something so basic, type of things. Do a budget. Stick to it and you're in control. There are two approaches to budgeting. The first is what we call cold turkey. Each time you get paid, you work out what you need to pay for all your essentials. Use Sorted's budget calculator to do this. You then take the rest and put it straight into savings. Going cold turkey on all those other things that you usually throw your money away on. Be realistic with your savings. Don't be too hard on yourself as it could take time for you to get into the saving habit. But if you remove the temptation to spend, you'll improve your financial position each month. If that seems a bit rigorous, try the alternative nip and tick approach. Do a budget using Sorted's budget calculator and then take a hard look at where your money's going. We're prepared to bet there's a nip here and a tuck there that will result in savings and every month you save, you increase your net worth. So go to it. ChatGPT What are the three important skills needed to achieve your financial goals? A) Budgeting, investing, and saving B) Setting realistic goals, knowing your net worth, and budgeting C) Planning, tracking, and monitoring How can you make a big goal more achievable? A) By dreaming about it often B) By breaking it down into a series of mini goals C) By setting a longer time frame What is net worth? A) The amount of money you have in savings B) The value of everything you own minus what you owe C) The amount of money you earn each year What are the two approaches to budgeting mentioned in the transcript? A) Cold turkey and warm turkey B) Nip and tuck and cold turkey C) Nip and tick and warm turkey How can you increase your net worth every month? A) By dreaming about your financial goals B) By sticking to a budget and removing the temptation to spend C) By investing in high-risk stocks

Make a vocabulary quiz with below.Crisis: a very difficult situation or emergency; “Investors are worried that continuing problems in the stock market might lead to another financial crisis.” Short-staffed: not having enough employees or workers; “We laid off dozens of employees to save money, but now we’re short-staffed and can’t fill orders quickly.” To drive someone nuts: to make someone upset or annoyed; “The autocorrect feature on my mobile phone really drives me nuts.” To arise: to happen or start to develop, especially for problems or situations; “Problems arose for the developers when local residents voted against construction of the new shopping mall.” To moan: to complain about something, especially in a way that bothers other people; “Every Monday morning my colleagues moan about having to come to the office so early.” Optimism: the feeling or belief that good things will happen; “Analysts are expressing optimism that the real estate market will bounce back quickly.” Pessimism: the tendancy or belief that the worst will happen. “Now is not the time for pessimism, we need to believe we can do this or we will fail.” Hurdle: a problem that must be overcome or dealt with in order to reach a goal or do something; “Lack of capital is a major hurdle for many young entrepreneurs with good business ideas.” © 2013 All rights reserved: www.businessenglishpod.com 2 To give up: to stop trying to do or achieve something; “After being rejected by over a dozen universities, Roger gave up on his plans to study for an MBA.” To keep your eye on the prize: to stay motivated and focused on your final goal or reward; “Okay folks, I know things have been really busy, but let’s keep our eye on the prize and we’ll get this done before Christmas.” Down the road: in the future; “Sales our good in our retail outlets, but 10 years down the road we’re going to have to be more competitive in the online market.” To overcome: to deal with a problem successfully; “You are going to have to overcome your lack of confidence if you want to be a good salesman.” Decisiveness: having the ability to make decisions and act firmly. “Decisiveness is a quality we look for in new managers.” Bumpy: we can use “bumpy” to describe a road or process that has many problems; “We had a pretty bumpy start-up phase, but we finally managed to turn a profit in our fifth year of operations.” To display: to show a feeling, emotion, or characteristic; “David displayed tremendous preparation and diplomacy during the negotiations.” On the fence: someone who is “on the fence” is having difficulty making a decision or taking a position; “While the executives support expansion wholeheartedly, the shareholders are still on the fence about it.” All-in: in poker, if you are “all-in” you put all your money on one bet, but we can use this expression more generally to say you are completely committed to something, especially a plan; “This sounds like a good idea, but before I go all-in I need to know more about the project partners.” To have what it takes: to have the ability or intelligence to do something; “I thought I’d enjoy law, but after a few years as a junior lawyer I realized I don’t really have what it takes.

Fall Forward, Spring Back It was the first Friday in November. Daylight Saving Time ended that Sunday. The fall parade was Sunday, too. "Remember to set your clocks back an hour on Saturday night," said Nola's teacher. "Spring forward, fall back," he added. Nola didn't pay much attention. She was always late for everything anyway. She figured she always would be. At dinner, though, she asked her mom if they could go to the parade. "I won't be here Sunday, but I'll bet Pablo could take you," Mom said. Nola looked at Pablo, her sleеру big brother. He nodded-and yawned. Saturday morning, their mom drove to the airport. Saturday night, Nola thought back to her teacher's words: "Spring forward, fall back." Or was it "Fall forward, spring back"? "Fall forward" sounded better, so she set her clock forward an hour. Just like that, it was past her bedtime. She was late again. "Time is not my friend," Nola sighed. The next morning when Nola woke, her clock said 10:15. The parade began at ten o'clock. Nola and Pablo ran to the parade route, but there was no parade. It seemed they'd missed the whole thing. They turned and headed home. On their way back, they spotted their neighbor Frank. He was climbing around next to an eight-foot pumpkin float. "The early bird gets the worm!" he shouted, then asked for their help. They worked on his float for more than an hour. Then Frank clapped his hands. "Let's get to that parade!" he cried. Nola and Pablo blinked in confusion. "Wait a minute," Nola said. "Wasn't the parade at ten o'clock today?" she asked. "Was at ten?" Frank asked. "Will be at ten is more like it!" he cried. He thrust his watch toward them. It said 9:30. Nola laughed for joy. She had jumped forward an hour when everybody else had jumped back. That meant she and Pablo were now two hours ahead of everybody else. For once in their lives, they were early! "The early bird gets the worm!" Nola cried. Frank nodded. "You've got it, missy," he said. Pablo yawned. It was all a big mistake, but it turned out to be a great mistake. It's why they rode in the parade that year, and every year since. It's also why, from that day on, Nola has been early for everything. Two minutes early, though-not two hours.

A Visit to the Desert Tim was looking forward to this vacation. Then his parents told him the family would be visiting Grandma in Nevada. Tim was unhappy. He wanted to be with his friends this summer. "Grandma is eager to see you," Mom said. "She can't wait to take you on a desert hike." The next morning Grandma met them at the airport. Then they drove to the desert. As they hiked, Grandma explained that animals enjoy the open desert space. It gives them the freedom to move from place to place. Tim learned that the animals find ways to adapt to the hot desert weather. He wondered if he could get used to the desert climate. "Wow," Tim said, "Look at that! The turtle carries its home on its back!" Grandma smiled at Tim's excitement. "Actually," she said. "That is a desert tortoise. It looks for the shade made by the shadows of rocks. That's how it cools off. He burrows underground to get away from the heat." The tortoise disappeared into its burrow. Tim leaned over the hole. He could not hear a sound. "I'll bet it likes the silence of its burrow," Tim whispered. "I think it likes its sense of safety too," Grandma added. "That's the same feeling I get at home," Tim sighed. Just then a large rabbit hopped by. Grandma explained that the jack rabbit's large ears help it stay cool. "These animals are so unlike the animals at home!" Tim said. He had forgotten about the desert heat. "Some animals stay cool by sleeping during the day. Then they hunt at night," said Grandma. A Great Horned Owl hooted above them. Grandma said, "It will soon be time for the owl to hunt." "Which means it's time for us to head back," Dad added. "Aw, this vacation is going by too fast," Tim said. They asked Tim about the heat. "What heat?" Tim asked. "I feel as fresh and cool as a new flower. I've adapted!" Everyone laughed.

Chip and Chet “I am the chess champ”. “Nobody plays chess better than me!” said Chet the champ. “I am better at chess than you. Let’s have a chess match”, said Chip. Chet bet Chip a chunk of change that he would win the chess match. Checkmate! “Checkmate! I won!” cheered Chip, the new champ. Chet was sad that he lost the match.

Chip and Chet “I am the chess champ”. “Nobody plays chess better than me!” said Chet the champ. “I am better at chess than you. Let’s have a chess match”, said Chip. Chip bet Chip a chunk of change that he would win the chess match. Checkmate! “Checkmate! I won!” cheered Chip, the new champ. Chet was sad that he lost the match. These are letters ch. Letters ch make the sound: Chet, chess, champ, chunk, Chip, change, checkmate, cheer

Un zoológico en casa

Related quizzes

Related quizzes