answer.
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
Luba_88 [7]
2 years ago
4

Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the

number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Computers and Technology
1 answer:
alexandr1967 [171]2 years ago
4 0

Answer:

The vlookup formula is given below

(Vlookup,I5,A17:G20,9,1)

Please mark brainliest

Explanation:

In cell I6 write this formula (=Vlookup,I5,A17:G20,9,1)

While writing the formula press tab to select vlookup then select the value you want to look then add a comma then select the range of the data you want to look in then add comma then write the number of the column number you want the data from then add comma then there will be a choice of approximate or exact, select 1 or 2 accordingly and press enter.

You might be interested in
add is a method that accepts two int arguments and returns their sum. Two int variables, euroSales and asiaSales, have already b
Oduvanchick [21]

Answer:

// here is code in Java.

// package

import java.util.*;

// class definition

class Main

{

   // method that return sum of two sale value

   public static int Add(int euroSales,int asiaSales)

   {

       // return the sum

       return euroSales+asiaSales;

   }

   //main method of the class

public static void main (String[] args) throws java.lang.Exception

{

   try{

    // variables

       int euroSales=100;

       int asiaSales=150;

       int eurasiaSales;

        // call the function

       eurasiaSales=Add(euroSales,asiaSales);

        // print the sum

       System.out.println("total sale is:"+eurasiaSales);

   }catch(Exception ex){

       return;}

}

}

Explanation:

Declare and initialize two variables "euroSales=100" and "asiaSales=150". Declare another variable eurasiaSales. Call the method Add() with euroSales and asiaSales as parameter. This method will add both the value and return the sum.This sum will be assigned to variable eurasiaSales.Then print the sum.

Output:

total sale is:250  

8 0
2 years ago
GJAUDRO: A member of a team. Question 2 with 1 blankARBCUE: Activity that is practiced under the water. Question 3 with 1 blankE
kramer

Answer:

1 jugador

2 bucear

3 equipo

4 ciclismo

5 pasear

6 tenis

Explanation:

ur welcome

6 0
2 years ago
Write an if-else statement with multiple branches. If givenYear is 2101 or greater, print "Distant future" (without quotes). Els
kherson [118]

Answer:

// here is code in c.

#include <stdio.h>

// main function

int main()

{

// variable to store year

int year;

printf("enter year:");

// read the year

scanf("%d",&year);

// if year>=2101

if(year>=2101)

{

printf("Distant future");

}

//if year in 2001-2100

else if(year>=2001&&year<=2100)

{

   printf("21st century");

}

//if year in 19011-2000

else if(year>=1901&&year<=2000)

{

  printf("20th century");

}

// if year<=1900

else if(year<=1900)

{

  printf("Long ago");  

}

return 0;

}

Explanation:

Read the year from user.After this, check if year is greater or equal to 2101 then print "Distant future".If year is in between 2001-2100 then print "21st century".If year is in between 1901-2000 then print "20th century".Else if year is less or equal to 1900 then print "Long ago".

Output:

enter year:2018                                                                                                            

21st century

7 0
2 years ago
Read 2 more answers
9. A __________ gateway sets up two TCP connections, one between itself and a TCP user on an inner host and one between itself a
aev [14]

Answer:

Stateful inspection

Explanation:

Stateful inspection: This is also known as dynamic packet filtering, it is a type firewall technology that monitors the state of active connections and uses this information to determine which network packets will be allowed through the firewall.

3 0
2 years ago
Read 2 more answers
A small company is moving towards sharing printers to reduce the number of printers used within the company. The technician has
Misha Larkins [42]

Answer:

Security risk associated with sharing a printer are

  1. Printer Attacks
  2. Theft
  3. Breach of data
  4. Vulnerable Network

Explanation:

Printer Attacks

A network printer can be used for a DDoS attack.As printer are not very secured and are a weak link in network these can be easily exploited by the hackers for any kind of malicious activities and even lanching a DDoS attack.

DDoS attack is denial of service attack in which network is flooded with malicious traffic which cause it to choke and make it inaccessible for users.

Theft

Physical theft of document can be an issue.Anyone can just took printed pages from printer tray by any one.

Breach of Data

The documents which are printed are usually stored in printer cache for some time which can be accessed by any one connected to the network. Any document containing confidential information which are printed on network printer can fall in wrong hands.

Vulnerable Network

As mentioned a single unsecured network printer can pose great threat to entire network as it can provide a way into the network.

8 0
2 years ago
Other questions:
  • What type of hardware enables users to interact with a computer? Check all that apply. the CPU the hard disk drive the keyboard
    9·2 answers
  • To determine why a computer program started to function differently, Mel should most likely use data to
    5·2 answers
  • Your license can be canceled if you __________
    14·2 answers
  • Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value
    12·1 answer
  • If Mark is developing a website to be optimized for mobile devices, what would be the top-level domain?
    10·1 answer
  • Consider the following classes:
    8·1 answer
  • How can a signature be added to an email message? Check all that apply.
    10·2 answers
  • Write a function that takes a string like 'one five two' and returns the corresponding integer (in this case, 152). A function j
    11·2 answers
  • Describe a strategy for avoiding nested conditionals. Give your own example of a nested conditional that can be modified to beco
    15·1 answer
  • A video game character can face toward one of four directions: north, south, east, and west. Each direction is stored in memory
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!