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
liberstina [14]
2 years ago
9

On the attendance worksheet, in cell l5, enter an if function to determine if the percentage in cell k5 is greater than or equal

to the goal in cell h18. the function should return the text goal met if true and review if false. set the reference to cell h18 as an absolute reference
Computers and Technology
2 answers:
KatRina [158]2 years ago
8 0

=if(c5≥h18,(c5),(k5))

we will use if function to check the validity of function

we will first write the condition and then we will write the value if condition goes true otherwise if condition does not go true we will write false and function will return value in  k5 cell which we have provided in the formula.

vlabodo [156]2 years ago
4 0
You have tot do these steps:
Ribbon
1.Click cell L5. On the FORMULAS tab, in the Function Library group, clickthe Logical, and then click IF.
2.In the Function Arguments dialog box, with the insertion point in the Logical_test box, type K5>=$H$18.
3.Press TAB to select the Value_if_true box.
4.Type Goal Met.
5.Press TAB to select the Value_if_false box.
6.Type Review.
7.Click OK.

Keyboard
1.Click cell L5, and type =IF(K5>=$H$18,"Goal Met","Review") (or =if(k5>=$h$18,"Goal Met","Review") or =IF($H$18=0.8,"Goal Met","Review") or =if(k5>=.80,"Goal Met","Review") or =IF(0.80
2.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the leftof the Formula Bar).

Keyboard (2)
1.Click in the Name box, type l5 (or L5), and then press ENTER. type =if( (or =IF( or =If().
2.Click cell K5, and then type >=.
3.Click cell H18, press F4, and then type ,"Goal Met","Review".
4.Press ENTER (or TAB or CTRL+ENTER or click the Enter button to the left of the Formula Bar).
You might be interested in
"Simon Says" is a memory game where "Simon" outputs a sequence of 10 characters (R, G, B, Y) and the user must repeat the sequen
m_a_m_a [10]

Answer:

#include <iostream>  // includes input output functions

#include <string> // used for string functions

using namespace std;   // identifies objects like cout , cin

int main() {  // body of the main function

int index;   // index position of the elements

simonPattern = "RRGBRYYBGY";   //stores simon pattern

userPattern = "RRGBBRYBGY";   //stores user pattern

int userScore = 0;  // used to store the user score

// loop compares characters of user and simon patterns

for ( index = 0; userPattern[index] == simonPattern[index]; ++index) {

     userScore = userScore +1; // adds to the user score

     if (userPattern[index] != simonPattern[index]){

//if user and simon pattern do not match

        break;      }   } // breaks the loop

cout << "userScore is  " << userScore; // prints the user score

Explanation:

The program compares the user pattern to simon pattern character by character and keeps adding one to the user score if the characters of both simon and user patterns match. The loop breaks if the character of user pattern does not match with that of simon matter. At the end the calculated user score is displayed in the output.

3 0
2 years ago
Which of the following is considered technology?
nevsk [136]
A. computer
computer because computer is technology and pencil is not and spoon.
8 0
2 years ago
How can we make our programs behave differently each time they are run?
tensa zangetsu [6.8K]

Answer:

By given the right speech as much as the answers must be

Explanation:

By given the right speech as much as the answers must be

7 0
1 year ago
Cloud-based services can open doors to leveraging Artificial Intelligence (AI) without dramatically increasing risk. Which clien
vladimir1956 [14]

Answer:

Explanation:

The clients that would be best suited for this opportunity would be small business or business' that do not have the hardware/space resources necessary to create the computing power that they need. Instead, they can simply pay for these cloud-based services which provide all of the necessary computing/hardware power and resources necessary so that the company can easily fulfill all of their tasks without any problems. Bigger companies can easily pay for and implement their own hardware to solve their problems which may benefit them even more in the long-term.

7 0
1 year ago
Explain why the cost of ownership may be lower with a cloud database than with a traditional, company database.
geniusboy [140]

Answer:

Cloud database eliminates the need for establishing and maintaining data centres.

Explanation:

Cloud computing provides an organisation with the infrastructure they need but can not afford. A large online storage with access control policies is available based to subscription.

For a company to establish a data centre, they would need a team of skilled network engineers, fleet of high speed server systems and large storage devices.

The daily power supply and management, coupled with the needed skills and items, can be overwhelming for a company whose main objective is not to deliver database services. So cloud computing is adopted to reduce the cost.

4 0
2 years ago
Other questions:
  • The adjusted cell references in a copied and pasted formula are called ____ cell references.
    7·1 answer
  • Exercise 6.3 consider memory storage of a 32-bit word stored at memory word 42 in a byte-addressable memory. (a) what is the byt
    14·1 answer
  • Zander is beginning to take college courses to prepare for a career in computer science, which is the study of using logic to cr
    5·1 answer
  • Write a function that computes the average and standard deviation of four scores. The standard deviation is defined to be the sq
    15·1 answer
  • Write a function so that the main program below can be replaced by the simpler code that calls function mph_and_minutes_to_miles
    5·1 answer
  • Which of the following statements is true? Using existing exceptions makes the program less robust. Always create your own excep
    15·1 answer
  • Write the definition of a function power_to, which receives two parameters. The first is a float and the second is an integer. T
    5·1 answer
  • reAay ouyay aay hizway ithway igPay atin?Lay? (Translated: "Are you a whiz with Pig Latin?") Write a program that converts an En
    6·1 answer
  • Write a cout statement that prints the value of a conditional expression. The conditional expression should determine whether th
    6·1 answer
  • Mary has been locked out of her account after failing to correctly enter her password three times. As the system administrator,
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!