All categories

3 years ago

What does the “MIN” and “MAX” functions allow you to do when inserted in a spreadsheet?

Computers and Technology

1 answer:

Aleks04 [339]3 years ago

7 0

Answer:

Please see explanation

Explanation:

A spreadsheet is used to make calculations and payrolls etc. Different functions are used in spreadsheet. Two of them are MIN and MAX.

The MIN function gives the minimum value out of all the cells in the range.

It is written as:

= MIN(number1, number2..)

= MIN(Starting_cell_address:Last_cell_address)

Similarly, MAX function gives the maximum value from the selected range of cells.

= MAX(number1, number2..)

= MAX(Starting_cell_address:Last_cell_address)

You might be interested in

Anyone know how to fix this problem on Microsoft Team?

lesya [120]

Answer:

Wait for some time and reload the page

Fix the corrupted file

The file is deleted before finishing upload

Clear browser cache.

Explanation:

7 0

3 years ago

Read 2 more answers

write query for all products reutrn product name with its amounts due, paid, canceled, and refunded, order the result by product

spayn [35]

Answer:

SELECT product_name, amount_due, amount_paid,

cancelled, amount_refunded

FROM products

ORDER BY product_name ASC;

Explanation:

SQL (Structured Query Language ) was used above.

The SELECT command is used to list all the variables we want in our output.

The FROM command signifies the location.

ORDER BY command ensures that your result is ordered

ASC means Ascending Order.

; signifies the end of the query.

NOTE: Underscores were used because variables cannot be written with spaces between them

8 0

3 years ago

Web navigation gives the user a sense of control.

Leviafan [203]

1. a.
2. d
3. b
I hope this helps

6 0

3 years ago

Read 2 more answers

If Mike saves $160 each month, how much will he save in 12 months? Enter your answer in the box.

denis-greek [22]

Answer:

$1,920

Explanation:

i think its that bc 160 x 12=1,920

im sorry if wrong but if right can i get brainlest?

7 0

2 years ago

"In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas whe

Alex17521 [72]

Answer: Absolute cell referencing

Explanation:

The absolute cell referencing is one of the type of cell reference address that basically contain the dollar sign in the spreadsheet applications. It is one of the important element as it helps in referring the constant values in the spreadsheet programs.

The absolute cell referencing is copied and also moved from one cell to another in the new location.
The size and also the shape are also remain constant in the spreadsheet.

According to the given question, the absolute cell referencing is also known as the relative cell referencing as they use the formulas for copied the values in the microsoft office excel for find out the data.

Therefore, Absolute cell referencing is the correct answer.

8 0

3 years ago