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
igomit [66]
3 years ago
12

The second half to the Student Report will retrieve the specific fees for which the student whose ID is in cell B2 is responsibl

e. In cell E5, enter a VLOOKUP function that will retrieve the student's Uniform Size from the range A12:E36 on the StudentReport worksheet. Incorporate an IFERROR function so that if there is no Student ID in cell B2, a blank value ("") is returned instead of a___________.
Computers and Technology
1 answer:
viva [34]3 years ago
6 0

Answer:

The second half to the Student Report will retrieve the specific fees for which the student whose ID is in cell B2 is responsible. In cell E5, enter a VLOOKUP function that will retrieve the student's Uniform Size from the range A12:E36 on the Student Report worksheet. Incorporate an IFERROR function so that if there is no Student ID in cell B2, a blank value ("") is returned instead of an <u>Error</u>.

Explanation:

In MS Excel, IFERROR function is the the function the function that is used to check the error in the formula. If the error found in the formula or some other calculation, it show the output that we want in case of error.

For example, we want to show "There is an an error" in case of error in the formula or calculation. We mention this statement as an output of the IFERROR condition. we can make it empty instead of showing the error.

In Given Question, If the there is no student ID in the Cell B2, a blank value shown on the output instead of the error to incorporate the IFERROR function.

You might be interested in
int sequence[10] = { 3, 4, 5, 6, 7, 8, 9, 10, 1, 2 }; Write a C++ program to ask the user to enter a number, if the number can b
Inessa [10]

Answer:

The c++ program to implement search through an array is shown.

#include <iostream>

using namespace std;  

int main()  

{

   int sequence[10] = { 3, 4, 5, 6, 7, 8, 9, 10, 1, 2 };

   int input;

   int found = 0;

   cout << " This program confirms whether your element is present in the array. " << endl;

   cout << " Enter any number  " << endl;

   cin >> input;

   for( int k = 0; k < 10; k++ )

   {

       if( input == sequence[k] )

           found = found + 1;

   }

   if( found == 0 )

       cout << " Not Found " << endl;

   else

       cout << " Found " << endl;

   return 0;

}

OUTPUT

This program confirms whether your element is present in the array.  

Enter any number  

7

Found

Explanation:

The program uses the given integer array.

User is prompted to input any number. No validation is implemented for user input since it is not mentioned. The user input is taken in an integer variable, input.

int input;

cout << " Enter any number " << endl;

   cin >> input;

Another integer variable found is declared and initialized to 0.

int found = 0;

Inside for loop, each element is compared with the user input.

If the user input is present in the given array, variable found is incremented by 1.

for( int k = 0; k < 10; k++ )

   {

       if( input == sequence[k] )

           found = found + 1;

   }

If value of variable found is 0, program displays “ Not Found ”.

If the value of variable found is greater than 0, program displays “ Found ”.

if( found == 0 )

       cout << " Not Found " << endl;

   else

       cout << " Found " << endl;

This program can be tested for both positive and negative numbers.

7 0
3 years ago
Print "Censored" if userInput contains the word "darn", else print userInput. End with newline. Ex: If userInput is "That darn c
Alisiya [41]

Answer:

The Java code is given below

Explanation:

import java.util.*;

public class CensoredWords {

public static void main(String args[]) {

Scanner scnr=new Scanner(System.in);

String userInput;

System.out.println("Enter String: ");

userInput=scnr.nextLine();

int res=userInput.indexOf("darn");

if(res == - 1) {

System.out.println(userInput);

} else {

System.out.println("Censored");

}

}

}

8 0
3 years ago
Differences between analog computer and hybrid computer​
aleksandrvk [35]

Answer:

Analog computers only work with continuous numerical data in analog quantities, digital computers can process both non-numerical and numerical data and a hybrid computer is a combination of both analog and digital. A hybrid computer has the accuracy of a digital computer paired with speed of an analog one.

5 0
3 years ago
Read 2 more answers
Write a Python function that takes as input parameters base_cost (a float) and customer_type and prints a message with informati
PSYCHO15rus [73]

Answer:

Explanation:

Thanks for the question, here is the code in python

The 3rd example given in question is incorrect

inputs: check_amount = 26.99, customer_type = "generous" --> output: Total owed by stingy customer = $16.83 (with $1.53 tip)

the customer type in the above passed is generous but why the output is showing for stingy, I think this is incorrect

Here is the function, I have given explanatory names so that you can follow the code precisely and also used pretty formatting.

thank you !

===================================================================

def print_tip(base_cost, customer_type):

   TAX_PERCENTAGE = 1.07

   STINGY_PERCENTAGE = 0.1

   REGULAR_PERCENTAGE = 0.15

   GENEROUS_PERCENTAGE = 0.20

   check_amount = base_cost * TAX_PERCENTAGE

   tip_amount = 0.0

   if customer_type == 'regular':

       tip_amount = check_amount * REGULAR_PERCENTAGE

   elif customer_type == 'generous':

       tip_amount = check_amount * GENEROUS_PERCENTAGE

   elif customer_type == 'stingy':

       tip_amount = base_cost * STINGY_PERCENTAGE

   total_amount = tip_amount + check_amount

   print('Total owed by {} customer = ${} (with ${} tip)'.format(customer_type, '%.2f' % total_amount,'%.2f' % tip_amount))

print_tip(20, 'regular')

print_tip(26.99, 'generous')

print_tip(14.99, 'stingy')

8 0
3 years ago
Components Of Desktop System?<br><br><br><br><br><br><br>Thanku! :)<img src="https://tex.z-dn.net/?f=%20%5C%3A%20" id="TexFormul
trapecia [35]

components Of desktop system:

  • motherboard { backbone of the computer system controlling all tasks }
  • RAM { temporary random access memory }
  • ROM { stores huge amount of data ex - photos, videos }
  • CPU { central processing unit which processes data }
  • GPU {graphical processing unit for video editing, 3D graphics rendering}
6 0
3 years ago
Other questions:
  • A(n)…………is the interface used toconnect external devices to the computer.
    5·1 answer
  • The program needs a Frisbee Golfer class.
    15·1 answer
  • A small amount of memory stored on the central processor for easy access is called
    6·2 answers
  • Discuss why it is common for XML to be used in interchanging data over the Internet. What are the advantages of using XML in dat
    7·1 answer
  • Which of the following describes a potentially damaging computer program that affects, or infects, a computer negatively by alte
    9·2 answers
  • In order to create strong neural networks (connections) in your brain, you've got to __________ the learning process.
    14·1 answer
  • When would it be most beneficial to package a presentation on a CD? Check all that apply. when sending the file via email for di
    6·2 answers
  • ______allow you to select elements that are in a certain state, such as when the mouse if hovering over an element
    14·1 answer
  • Which statement is most likely to be true about a computer network?
    12·2 answers
  • Select the correct text in the passage.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!