COMPUTERS AND TECHNOLOGY COLLEGE

In cell B13, create a formula without a function using absolute references that subtracts the values of cells B5 andB7 from cell B6 and then multiples the result by cell B8. please help with excel!! I'm so lost

Answers

Answer 1
Answer:

Answer:

The formula in Excel is:

=($B$6 - $B$5 - $B$7)* $B$8

Explanation:

Required

Use of absolute reference

To reference a cell using absolute reference, we have to include that $ sign. i.e. cell B5 will be written as: $B$5; B6 as $B$6; B7 as $B$7; and B8 as $B$8;

Having explained that, the formula in cell B13 is:

=($B$6 - $B$5 - $B$7)* $B$8

Related Questions

C programmig : Output all combinations of character variables a, b, and c, using this ordering:abc acb bac bca cab cbaSo if a = 'x', b = 'y', and c = 'z', then the output is: xyz xzy yxz yzx zxy zyxYour code will be tested in three different programs, with a, b, c assigned with 'x', 'y', 'z', then with '#', '$', '%', then with '1', '2', '3'.
________________________ is an information system that stores user data in many different geographical locations and makes that data available on demand.
Challenge: Tic-Tac-Toe (Report a problem) Detecting mouse clicks For this step of the challenge you will complete Tile's handleMouseClick method. The handleMouseClick method has two parameters: x and y which represent the coordinates of where the user clicked the mouse. When a user clicks inside a tile, that tile's handleMouseClick method should call that tile's onClick method. To check if the mouse click is inside of the tile, you will need an if statement that checks if: - the mouse click is on, or right of, the left edge of the tile - the mouse click is on, or left of, the right edge of the tile - the mouse click is on, or below, the upper edge of the tile - the mouse click is on, or above, the lower edge of the tile
_ is an important management tool that is used to monitor and manage that contract and/or project
Write a function in Matlab which takes as input an integer x and as output returns the biggest prime number that is less than or equal to x. For example, if the input is 7, the output would be 7. If the input is 40, the output would be 37. (Reminder: isprime.)

The section on the Publisher screen that allows you to quickly move from one page another in a publication is the _____. View tabPage pane

Page Design tab

Zoom bar

Answers

Answer:

Page pane

Explanation:

This pane is present under the navigation pane, it allow to hop easily from one page to other.  Moreover pages can be added using Add Page button.

Page pane makes the view and navigation from on page to another easier and quicker.

Which of the following people was a member of FFA?O Kenny Chesney
O Tim McGraw
O Alan Jackson
O Billy Currington

Answers

Answer: Tim McGraw

Explanation:

The National FFA Organization is a youth organization that originally aimed to encourage the youth to venture into agriculture by offering agriculture education to youth in high schools and middle schools. In recent years they started offering education in other areas such as business and technology.

The FFA is quite famous and has had and still has a lot of members. It is of no surprise therefore that some of their alumni are now stars. Famous Country musician Tim McGraw is one such alumni and he was a member of the FFA in his hometown of Start, Louisiana.

Other stars who were part of the FFA include; Taylor Swift and Sterling Martin.

Jenae helps maintain her school web site and needs to create a web site poll for students. Which tool will she use?

Answers

She needs to use a web browser

Answer:

web browser

Explanation:

the other three will not let her excess her page at all

Is there a point where preto distribution really takes over?

Answers

Answer:

Yes Preto distribution takes over when we apply 80/20 rule.

Explanation:

The Pareto distribution is derived from pareto principle which is based on 80/20 rule. This is main idea behind the Pareto distribution that  percent of wealth is owned by 20% of population. This 80/20 rule is gaining significance in business world. There it becomes easy to understand the input and output ratio. The input ratio helps to analyse the potential output using Pareto distribution.

What is the analysis and complexity of a shell sortalgorithms?

Answers

Answer: The shell sort is based on insertion sort. Here the list of elements are divided into smaller sub list which are sorted based on insertion sort.

Its best case time complexity is O(n* logn) and worst case is O(n* log^2 n)

Explanation:

Shell sort is an inplace sorting here we begin by dividing the list into sublist and sorting the list with insertion sort. We create interval for dividing the list into sub list until we reach the smallest interval of 1.

The best case is O(n* logn).

A constructor (check all that apply): Group of answer choices will always result in a run time error and program crash if it fails to test a parameter's value for validity before assigning the parameter's value to member. This will happen the first time we run a program, and alert us to the fact that there is a problem. must use mutators to initialize class data. must use assignment statements to initialize class data. may use assignment statements to initialize class data. may use mutators to initialize class data. will receive a compiler error if it fails to test a parameter's value for validity before assigning the parameter's value to member.

Answers

Answer:

Must use mutators to initialize class data.

May use assignment statements to initialize class data.

Explanation:

These are the two characteristics that are present in constructors. A constructor is an instance method of a class or structure that creates an object of the class to which it belongs. This is mostly used in object-oriented programming. These constructors usually have the same name as the actual class, and can be used in order to set the values of the members of an object.
Other Questions
Whichof following can be thrown using the throw statement?ErrorThrowableExceptionRuntimeExceptionAll of Given
Which wireless technology does the fire alarm system use? ​
Which file is used to configure the various mounting options of a filesystem upon boot?a. /etc/mountb. /etc/fstabc. /var/filesystemd. /boot/config
/* ELEN 1301 Programming Assignment #5. Name : Your name. Student ID : Your student ID #. Due date : Due date Purpose of the program : Finding the average, minimum and maximum values of seven entered numbers. Use iomanip library to show 3 digits below decimal point. Section 1 : Enter the first number. Set min and max variables to the entered number. Section 2 : Enter the next number. If it is smaller than min, replace the min with the entered number. If it is bigger than max, replace the max with the entered number. Section 3 : Repeat section 2 five more times, so that you have seven numbers. Section 4 : Calculate the average of the seven numbers and show the result with 3 digits below decimal point. (2 points) Section 5 : Show the minimum number. (2 points) Section 6 : Show the maximum number. (2 points) */ #include #include using namespace std; int main() { int n1, n2, n3, n4, n5, n6, n7, min, max; double sum = 0; // Write the rest of the program. return 0; } // main