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
m_a_m_a [10]
3 years ago
13

If the student does not have a skill level entered in the Student_Data named range, the VLOOKUP will return a value of 0. Incorp

orate an IF function in the formula so that if the value returned is a 0, display a blank value ("") instead, otherwise display the value returned by the VLOOKUP function.
Computers and Technology
1 answer:
NikAS [45]3 years ago
6 0

Answer:

Formula explained below

Explanation:

You have not mentioned what the Student_Data range is. But from the context, I think it's =StudentData!A3:H34.

So, use the following formula in '$F$3' of LessonData:

=IF(VLOOKUP(B3,Student_Data,8)=0,"",VLOOKUP(B3,Student_Data,8))

Then copy the above formula up to F29.

<u>NOTE:</u>

8 means 8th column of the 'Student_Data' table which is the 'Skilllevel' column.

You might be interested in
Raj’s computer just crashed and he lost most of his files. What should he do to avoid this problem in the future?
Elanso [62]
He should back up his data regularly
3 0
4 years ago
Read 2 more answers
When network traffic is encrypted, it is invisible and its content and purpose are masked.
Olenka [21]

Answer:

true

Explanation:

encryption is when you scramble the contents of information

4 0
3 years ago
In the given switch statement, what will be displayed if the value of var is 3? switch(var) { case 1: System.out.println("Apple"
olga_2 [115]

Answer:

The output of the given program is  

Peach Pear Pineapple.

Explanation:

since the value of var is so control will move to the case 3 directly and executed the statement inside the case 3 so it will print "Peach" in window after that their is no break statement in the case 3 the control moves the case 4 and executed the statement inside the case 4 so it will print "Pear" in window again there is no break statement in the case 4 the control moves the case 5 and executed the statement inside the case 5 so it will print "Pineapple".Finally, the break statement is reached the execution of the program is stopped.

3 0
3 years ago
Write a program that takes a point (x,y) from theuser and find where does the point lies. The pointcan
agasfer [191]

Answer:

C++ Program .

#include<bits/stdc++.h>

using namespace std;

int main()

{

int x,y;//declaring two variables x and y.

string s;//declaring string s..

cout<<"enter x and y"<<endl;

cin>>x>>y;//taking input of x and y..

if(x>=0 &&y>=0) //condition for 1st quadrant..

cout<<"the point lies in 1st Quadrant"<<endl;

else if(x<=0 &&y>=0)//condition for 2nd quadrant..

cout<<"the point lies in 2nd Quadrant"<<endl;

else if(x>=0 &&y<=0)//condition for 3rd quadrant..

cout<<"the point lies in 3rd Quadrant"<<endl;

else //else it is in  4th quadrant..

cout<<"the point lies in 4th Quadrant"<<endl;

cout<<"enter n to terminate the program"<<endl;

while(cin>>s)//if the user has not entered n the program will not terminate..

{

   if(s=="n")

   {

       cout<<"the program is terminated"<<endl;

       exit(0);

   }

   cout<<"you have not entered n please enter n to terminate the program<<endl;

}

}

Explanation:

The above written program is for telling the point lies in which quadrant.I am first declaring two variables x and y.Then after that taking input of x and y after that checking in which quadrant the point lies.

Taking input of the string s declared earlier for program termination the program will keep running until the user enters n.

4 0
3 years ago
Which type of VBA code is common for grouping statements that perform a certain task?
svet-max [94.6K]

Answer:

Module

Explanation:

Don’t listen to this answer it’s probably not rt

8 0
3 years ago
Other questions:
  • An employee believes there is an imminent danger situation at her workplace. She contacts OSHA to report the safety hazard. Her
    8·1 answer
  • Whats your favorite sport between these options?
    12·2 answers
  • Why is it a good idea to understand what you are good at and what you enjoy
    11·2 answers
  • Which of the following is true regarding a class and interface types? Group of answer choices You can convert from a class type
    9·1 answer
  • I NEED answers for these qu plz
    5·1 answer
  • Click this link to view O*NET's Skills section for Biomedical Engineers. Note that common skills are listed toward the top and l
    8·2 answers
  • so i am on a Chromebook with headphones , and I am wondering if you can make it that a tab only play sound on one side of the he
    12·1 answer
  • Please help with question
    14·1 answer
  • Mencione 2ejemplos de procesos manuales
    11·2 answers
  • What is a closed system?​
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!