Question

Objective Type
Multiple Choice Cestions (MCO)
1. Tick (/) the right choice.hi hiii drishti so00
a. The formula in Excel always starts with
sign
(iii) MEDIAN
b. A function that returns the highest value in a series is
(1) MIN
00 MAX
c. A function must be followed by opening and closing
(i) tabs
(1) brackets
d. Which of the following is a mathematical operator?
(iii) lines
(iii) negative
sign
e. By default, a spreadsheet cell reference is
(1) relative
(ii) absolute
f. An absolute cell address consists of the
(
(11) $
g. MIN is a type of
(ii) formula
() game
(iii) function​

Answer 1

Answer:

The tutorial explains the MAX function with many formula examples that show how to find highest value in Excel and highlight largest number in your worksheet.

MAX is one of the most straightforward and easy-to-use Excel functions. However, it does have a couple of tricks knowing which will give you a big advantage. Say, how do you use the MAX function with conditions? Or how would you extract the absolute largest value? This tutorial provides more than one solution for these and other related tasks.