The use of excel functions and examples
The following are some examples of how to use the Excel functions: ** 1. XLOOkUP Function ** 1. ** Function **: Search for matching items in a certain range or array, and return the corresponding items through the second range or array. By default, it is an exact match. 2. ** Syntactic structure **:=XLOOkUP(Find Value, Find Array, Return Array, No Value Found, Match Mode, Search Mode). The fourth, fifth, and sixth parameters can be omitted. Usually, you only need to set the first three functions. 3. ** Instance **: If you want to inquire about the basic salary of someone (such as Zhao Fei), assume that the name is in the A2:A8 cell area and the basic salary is in the D2:D8 cell area. Enter the formula in the target cell: =XLOOkUP(G3,A2:A8,D2:D8)(assume that the name you want to find is in the G3 cell), and then enter. ** 2. Filterer Function ** 1. ** Function **: Screen a series of data based on the defined conditions. 2. ** Syntactic structure **:= PROCESER (Array, Including, Empty Value), where "Array" is the filter area,"Including" is the filter condition (for example, filter column = filter condition), and "Empty Value" can be ignored. It is used to set the return information when an error value appears. 3. ** Instance **: Search for the corresponding assessment score, grade, and department information in the table on the right according to the data in the table on the left. If the name is in column A, and the assessment results, grade, and department information are in column B:D, enter the formula in the target cell: = Filterer (B:D,A:A=F3)(Assuming the name is in cell F3), and then enter. ** 3. TEXTSPILL Function ** 1. ** Function **: Use the Separator to split the text into rows and columns. 2. ** Syntactic structure **:=TEXtsplit (text to be split, split by column, split by row, ignore empty cells, case-sensitive, exception return value). The parameters "Text to be split" refer to the object to be split;"Split by column" refers to the separation character used to split the text into rows and display it;"Split by row" refers to the separation character used to split the text into columns and display it;"Ignore empty cells" refers to ignoring empty values after splitting;"Match case" refers to "exception return value" refers to the return result of splitting exceptions. 3. ** Instance **: If the customer name on the left is in cell B3 and is separated by commas, and you want to split the text into lines by using the separating character, enter the formula in the target cell: = TEXTSPILL (B3,","), then enter and fill in the fields. ** 4. TEXTJoin Function ** 1. ** Function **: A text link function that links lists or text string areas with a terminator. 2. ** Syntactic structure **:=TEXTJoin(Separator, ignore blank cells, string 1…). The "Separator" is a text string, or empty, or one or more characters enclosed in double quote marks, or a reference to a valid text string;"Ignore blank cells" is TRUE to ignore blank cells, and False to not ignore them;"String 1..." is 1 to 253 text items to be joined, which can be a text string or a string array (such as a cell area). 3. ** Instance **: To combine all the names in the A2:A8 cell area and separate them with commas, enter the formula in the target cell: =TEXTJoin(",",True,A2:A8), and then enter. ** 5. IFS Function ** 1. ** Function **: Check whether one or more conditions are met and return the value corresponding to the first True condition. It can replace multiple nesting IFs. 2. ** Syntactic structure **:=IFS(Test Condition 1, Truth Value 1, Test Condition 2, Truth Value 2…Test Condition N, Truth Value N). 3. ** Instance **: According to the assessment results, the employees are divided into assessment grades. Assuming that the assessment results are in cell B67, if the assessment results are greater than or equal to 90, the grade is Good; if the assessment results are greater than or equal to 80 and less than 90, the grade is Excellent; if the assessment results are greater than or equal to 60 and less than 80, the grade is Pass; if the assessment results are less than 60, the grade is Failed. Enter the formula in the target cell: =IFS(B67<60,"Failed", B67<80,"Passed",B67<90,"Excellent",B67>=90,"Good"), then enter. ** 6. SUM Function ** 1. [** Function **: Mainly used for simple and unconditional sum, calculating the sum of all values in the cell area.] 2. ** Syntactic structure **:=SUM(Number1,[Number2],...). 3. ** Instance **: To sum the salaries of all employees in the C4:C12 cells, enter the formula: =SUM(C4:C12) in the target cell, and then enter. ** 7. Sumifs Function ** 1. ** Function **: Multi-condition sum function. 2. ** Syntactic structure **:=SUMIFS(Summation Region, Condition Region 1, Condition 1, Condition Region 2, Condition 2…). Excel function input method: 1. ** Use the [Automatic Summon] button to insert a function **: First select a cell (such as cell B7), then switch to the [Formula tab], click the [Automatic Summon] button, and finally press the enter key to end the process. For example, calculating the sales amount of all the salespeople. 2. ** Using the function library to insert a function **: click the [Common Function] button on the [Formula] tab, select a sum formula (such as SUM), and the [Function parameters] dialog box will pop up. Then, click the left mouse button to select the corresponding cell area (such as the cell area from B2 to B6), and press the enter key to end the process. 3. ** Manual input of function formula **: This is a common method. For example, if you directly enter a function in a cell, the function must start with the equal sign "=". If you know the function you want to use, you can enter "=" and then enter the first letter of the function (such as "S"). The function starting with S will be listed below the cell. If the function you want to use does not appear, continue to enter the second letter (such as "U"). After the function you want to use appears, double-click the function with the mouse and it will automatically enter the cell. "Choose" was equally exciting. Everyone was welcome to read it!
What grade is Zhongshan Biology's middle school entrance examination with 66 points?
Zhongshan's 2024 biology high school entrance examination was divided into five levels: A+, A, B+, B, and C. With the examinees of the whole city as the overall sample, the corresponding proportions of the lowest scores of each level were less than 10%, 35%, 60%, 80%, and above 80%. However, there was no clear score limit, so it was impossible to determine the corresponding level of 66 points. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Scientific diet and nutrition recipes for kindergarten
The following is an example of a scientific diet for kindergarten based on the characteristics of the season: ** 1. Spring ** 1. ** Breakfast * - ** Staple food **: vegetable juice roll (made with spinach juice and flour, about 37.5 kcal energy, rich in nutrients such as vitamin A). - ** Side dishes **: Hot mixed with two colors (rich in nutrition, color matching can increase appetite), nutritious egg custard (rich in protein and other nutrients), cucumber, seaweed and willow leaf soup (containing a variety of vitamins and minerals). 2. ** Lunch ** - ** Staple Food **: Golden Fragments Rice (such as rice with millet and other coarse grains, providing rich carbs). - ** Meat dishes **: Steamed Dragon Li Fish (tender meat, rich in calcium, energy about 34.02 kcal). - ** Vegetarian dishes **: Barbequed potatoes with meat (potatoes are rich in carbs, and meat provides protein), garlic and chrysanthemum (rich in vitamins and nutritional fiber), zucchini and fungus (a variety of nutrients complement each other), seaweed, coriander and loofah soup (rich in a variety of minerals). 3. ** Noon ** - Apple (rich in vitamins and other nutrients), cherry tomatoes (nutritious), pear, hawthorn and lily water (nourishing the lungs, appetizing the spleen, energy about 27.97 kcal). ** 2. Summer ** 1. ** Breakfast * - [** Staple food **: Can be colorful steamed buns (for example, made with pumpkin paste, purple sweet potato paste, etc.)] - ** Side dishes **: Salad cucumber (refreshing and delicious, rich in vitamins C, etc.), boiled egg (a high-quality source of protein), green bean soup (clearing heat, replenishing water and nutrients). 2. ** Lunch ** - ** Staple food **: Mung bean rice (Mung bean and rice match, suitable for summer heat). - ** Meat dishes **: Fried onions with pig liver (pig liver is rich in iron and other nutrients, which can prevent iron-deficiency leukemia), egg soup (rich in protein, etc.). - ** Vegetables **: Winter melon meatball soup (Winter melon can clear away heat, and meatballs can provide protein), stir-fried tomatoes (rich in vitamins C). 3. ** Noon ** - Watermelon (a fruit that can cool off the summer heat, but you must pay attention to the right amount), banana (rich in nutrients such as potassium), sour plum soup (appetizing and cooling off). ** 3. Autumn ** 1. ** Breakfast * - ** Staple food **: tortillas (rich in fiber). - ** Side dishes **: Steamed sweet potatoes (rich in various nutrients), boiled eggs, millet porridge (nutritious and easy to digest). 2. ** Lunch ** - ** Staple food **: Brown rice (rich in various nutrients such as diet fiber). - ** Meat dishes **: Stewed beef with carrots (Beef is rich in protein, carrots are rich in vitamins, etc.). - ** Vegetables **: Stir-fried loofah (rich in vitamins, etc.), cold green beans (pay attention to cooking, rich in various nutrients), apple and white fungus soup (moisten the lungs and cough). 3. ** Noon ** - Grape (rich in vitamins and minerals), pear (moistens the lungs), honey pomelo tea (moistens the lungs and stops coughing). ** IV. Winter ** 1. ** Breakfast * - ** Staples **: Oatmeal (rich in fiber, warm and nutritious), meat buns (provides protein and carbs). - ** Side dishes **: Cold shredded carrots (rich in vitamins A, etc.), hot milk (rich in nutrients such as calcium). 2. ** Lunch ** - ** Staple food **: Red date rice (Red dates nourish blood, rice provides energy). - ** Meat dish **: Stewed mutton with radish (Radish is good for qi, mutton is warm and rich in protein and other nutrients). - ** Vegetables **: Stir-fried cabbage (rich in vitamins, etc.), braised pork ribs with seaweed (rich in calcium and other nutrients). 3. ** Noon ** - Roasted sweet potatoes (sweet and delicious, rich in various nutrients), oranges (rich in vitamins C, etc.), walnut milk (providing nutrients and energy). When formulating the kindergarten menu, it was necessary to do fine grain matching, dry and wet matching, meat and vegetable matching, acid and base matching, color matching, etc. to meet the needs of children's growth and development stage for various nutrients. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
The kindergarten corridor corridor created an interaction wall
The design of Huanchuang's interaction wall in the kindergarten corridor could be considered from the following aspects: * * 1. Show content ** 1. * * Children's work display ** - The works in the art design area could be displayed and the corridor could be decorated into a small gallery. In addition to the wall exhibition, there were booths set up in the spacious space to display handmade works, such as hanging plates on the corridor windows, which were both works of art exhibition and window decoration. 2. * * Rules and regulations and daily activities ** - The teachers 'rules and regulations, the daily activities of the children in the kindergarten, the honorary events of the kindergarten, the outstanding deeds of the graduating children, and the daily diet of the children were displayed to the parents. 3. * * Themed content display ** - * * Picture book theme **: If you use a picture book as the theme, you can integrate the picture book you want to read in the semester into the environment. The grand scene in the picture book would be shown, and the protagonist would be scattered around the corners of the corridor to guide the direction, or the corridor would become a fairytale town. - * * Science theme **: The large wall is suitable for designing large-scale scientific diagrams, such as water cycle diagrams, biological cycle diagrams, etc., in the form of a museum, photos, information, etc. will be displayed according to specific scientific topics. - [24 solar terms theme: design related wall decorations that will make people's eyes light up.] * * 2. Interactivity Design ** 1. * * Free Creation Zone ** - A large blackboard was hung on the corridor wall to form a free creative area for the children to participate in the interaction. 2. * * Mechanical power interaction ** - Tubes, slide rails, and rollers could be placed on the wall, and children could learn basic physics knowledge by watching the ball slide down. 3. * * The environment creates a wall ** - Setting up an environment creation wall, giving children the opportunity to create their own, let them put their beautiful ideas about the environment into practice, so that children can integrate into the environment and feel the joy of success. * * 3. Other design points ** 1. * * Color Selection ** - The colors should be close to the child's life, suitable for simple colors such as blue, pink, and green. These colors can remind the child of the sea, the forest, etc. When the teacher asks questions, it can enhance the child's sensory experience, while preventing the child from losing his attention due to the rich colors. 2. * * Styling and Space ** - The style should allow the child to interact with each other. The style should be in line with the child's aesthetics and leave space for the child to participate in the activities. For example, setting up interesting spaces such as wooden corners and game corners. At the same time, the corridor design should be coherent and smooth. The width of the single-sided corridor should be guaranteed to be 1.8m, and the width of the middle corridor should be 2.4m. The fence on the side should be sealed, and the height should not be lower than 1.3m. The shape of the fence should be diverse and have the characteristics of the kindergarten. It can break the traditional flat and closed form. There can also be concave and concave changes. It can also be designed into a transparent upper part and a closed lower part, but it must prevent children from climbing the walls on both sides. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
How much is the salary of the primary school teachers in Xin County?
The salary of a teacher with 1 - 3 years of experience in Xin County Primary School was 100% of the salary. The salary was 3,000 - 6,000 yuan per month, with an annual salary of 40,000 - 70,000 yuan. The average salary was about 3.9 thousand yuan per month. However, there were many sources of teachers 'salaries, including basic salary, living allowance, performance (reward performance and government performance), class teacher allowance, etc. Together, the average monthly salary could reach about 4140 yuan. Different regions, different years of service, and other factors would also cause differences in income. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
Is there any bacteria in the black secretion of the cat's ear? What medicine does it take?
The black secretion in the cat's ears could be caused by ear mites or inflammation of the ear canal. If it was ear mites, their secretions were mainly composed of ear oil, blood, inflammation secretions, and ear mites themselves. They were not infected by bacteria. Selamection + sarolana insect repellent could be used to deworm the cats. Selamection, Aiwalker (containing Moximecin), Helemiao (containing Milbemicin), Ivermentin, avermentin, domestic Imidacloprid Moxidectin, etc. could also be used to deworm and treat ear mites. Ear Skin Spirit was effective against mites, bacteria, and fungi in the ear. It could be used to treat symptoms caused by ear mites. If the ear canal is inflamed (there may be a bacteria infection), it may need to be treated with drugs such as antibiotics. However, the specific use of drugs needs to be determined according to the actual situation after seeing a doctor. It is not recommended to use drugs on their own. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
The novel recommended twin sisters every day
Among the reference materials, there was a novel about twin sisters," After the Twin Sister's Substitute Marriage ". In the book, the female protagonist, Niao, and her sister, Wen Feng, were twins. The sister was the most beautiful woman in the city and was carefully nurtured by the family. Other than her appearance, the female protagonist was completely different from her sister in other aspects. Her sister was betrothed to the Third Prince by the Emperor, but she admired the Crown Prince, so the family let the female lead marry her sister into the Cold Palace. Later, the Cold Palace was turned into a paradise by the female protagonist, and her husband became the emperor. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
What does the moon never set in the west imply?
The moon was not setting in the west. It was used to describe a person who had a beautiful dream on a good night. He hoped that he could sleep longer in the beautiful dream and that the beautiful dream would accompany him for more time.
Is Ya Fei the first person to know about Yao Lao?
In 'Battle Through the Heavens', Ya Fei was the first person to discover the relationship between Xiao Yan and Yao Lao. Hurry up and click on the link below to return to the original classic, Battle Through the Heavens!
What nutritional diseases do kindergarten children have?
The common nutritional diseases of kindergarten children were as follows: 1. ** Nutritional rickets **: Usually caused by a lack of vitamins D and/or calcium, which can lead to muscle malfunction and skeletal development disorder. It could be diagnosed through medical history, biochemical tests, and X-rays. Replenishment of vitamins D and calcium can be treated, and assurance of intake of vitamins D and calcium can be prevented. 2. [Obese]: It can be divided into simple obese and secondary obese. Simple obese was mostly caused by excessive nutrition in the body caused by eating too much and moving too little. Common causes included excessive intake, low activity, genetic factors, etc. Secondary Obese refers to the obese caused by other health problems, such as hypochondriac Obese, Pituitary-Obese, and Obese due to Hypothyreosis. 3. ** protein-energy malnutrition **: referred to as "malnutrition", also known as "insufficient protein intake". 4. ** Nutritional problems related to spleen deficiency **: The symptoms are that the child does not grow up, does not gain weight, has a poor appetite, is picky with food, has anorexia, often has yellow, white, thick and greasy tongue coating, often has constipation, sleeps at night and often sweats, and often gets sick. This will affect the child's growth and development, resulting in poor physical fitness and slow growth in height. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
How did the English of the ark become Chinese mode
If it was the Steam platform, he could right-click the game in the game library, select the attributes, select the language in the attributes, and then change it to Chinese. If it was the Epic platform, open the Epic platform, click on the settings in the lower left corner, and find the ARK Ark Survival Evolution in the settings. After expanding, click to check the additional command parameters, enter-culture= zh-Hans-GN in the command box, and then open the game, it will become Chinese. You can also use the OurPlay accelerator to play Ark Survival Evolution. OurPlay will automatically allocate the relevant services, or use the Odd Tour acceleration tool. First, make sure that you have installed and found " Ark: Survival Evolution ". Then click " Acceleration " to optimize the network environment. In the acceleration interface of Odd Tour, find the " game settings " or similar options, click to enter and look for " language settings " or " one-click translation " and other related functions. According to the prompt, choose Chinese as the game language. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>