please write diwn what cell functions i need to put in the yello blanks.
Reading Readiness, inc. has provided you its list of accounts and bulances as of January 31 . The Controller has asked you to prepare an income Statement for the month ended January 31 . Use the information included in the Excel Simulation and the Excel functions described below to complete the task. - Cell Reference: Allows you to refor to data from another cell in the workshoet. from she Excet Simulation below, if in a blank cell, "CII" was entered, the formula would output the result from cell Cil, or 6,050 in this example. - Besic Math functions. Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + fplus signto add? * (minus sign to subtract)" (asterisk sign to multiply), and/(forward slash to divido). From the ExceSimulation beiow, if in a blank cell " C11+C12" was entered, the formula would add the values from those cells and cutput the result, or 10,850 in this example. M using the other moth symbols the result would output an appropriate answer for its function. - SUM function: Allaws you to refer to multiple cels and adds all the values. You can add individual cell reforences or ranges to utilize this function. From the Excel Simulation beiow, if in a blank cea "=SUMiCtici2, Ci37" wos entered, the formula would output the result of adding those three separate cells, of 17732 in this example. Simiarly, if in a blank cell " suM(Cit C13)" was entered, the formula would output the same result of adding those colls, except they are expressed as a range in the formula. and the result would be 17,732 in this example. - IE function. Allows you to test a condision and return a spocific value is the resuat is true and different value if the result is false. when using this function. The test_condtion argument is an evaluation of the status of a cell, such as if the value of a cell is greater than, less than, or equal to another number or cell. The value. if irue and value if false arguments will raturn amy specific result for each optoon, such as another cell reference, a value, or text. Throughout the entire equation, 1 text is being Excel wil recognize the text as a "string of text" instead of snothor function. From the fxcel Simulation bejow, if in a blank cell test condeian would be result as true, or in this case the text "Cash is grear". Excel processes the If function by separating it out into separate parts. First the test condion- Excel thinks, find coll C6 and determine if the value is greafer than toood, Once Reading Readiness, inc. has provided you its list of accounts and bulances as of January 31 . The Controller has asked you to prepare an income Statement for the month ended January 31 . Use the information included in the Excel Simulation and the Excel functions described below to complete the task. - Cell Reference: Allows you to refor to data from another cell in the workshoet. from she Excet Simulation below, if in a blank cell, "CII" was entered, the formula would output the result from cell Cil, or 6,050 in this example. - Besic Math functions. Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + fplus signto add? * (minus sign to subtract)" (asterisk sign to multiply), and/(forward slash to divido). From the ExceSimulation beiow, if in a blank cell " C11+C12" was entered, the formula would add the values from those cells and cutput the result, or 10,850 in this example. M using the other moth symbols the result would output an appropriate answer for its function. - SUM function: Allaws you to refer to multiple cels and adds all the values. You can add individual cell reforences or ranges to utilize this function. From the Excel Simulation beiow, if in a blank cea "=SUMiCtici2, Ci37" wos entered, the formula would output the result of adding those three separate cells, of 17732 in this example. Simiarly, if in a blank cell " suM(Cit C13)" was entered, the formula would output the same result of adding those colls, except they are expressed as a range in the formula. and the result would be 17,732 in this example. - IE function. Allows you to test a condision and return a spocific value is the resuat is true and different value if the result is false. when using this function. The test_condtion argument is an evaluation of the status of a cell, such as if the value of a cell is greater than, less than, or equal to another number or cell. The value. if irue and value if false arguments will raturn amy specific result for each optoon, such as another cell reference, a value, or text. Throughout the entire equation, 1 text is being Excel wil recognize the text as a "string of text" instead of snothor function. From the fxcel Simulation bejow, if in a blank cell test condeian would be result as true, or in this case the text "Cash is grear". Excel processes the If function by separating it out into separate parts. First the test condion- Excel thinks, find coll C6 and determine if the value is greafer than toood, Once
