• Register
0 votes


I am new, I need help, can anyone help me by filling in the blanks?
The ____ function determines the lowest number in a range?
7 5 3
5,380 points

Please log in or register to answer this question.

2 Answers

0 votes


The correct answer is : MIN

The Excel MIN function returns the smallest numeric value in a range of values. The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values. Get the smallest value.

This might help you.

8 6 2
10,530 points
0 votes


The correct answer of this question is The MIN function determines the lowest numbers in a range.

For Further Information Check Out This list

Which of the following calculations multiplies 23 by 0.01?


The adjusted cell references in a copied and pasted formula are called ____ cell references.


When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.


You can open the Format Cells dialog box by pressing the ____ keys

Ctrl + 1

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.


You can use the arrow keys to complete an entry in Point mode.


To paste copied cell contents, you can press the ____ keys.

Ctrl + V

Clicking the ____ opens the Insert Function dialog box.

Insert function box in the formula bar

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key

Right parenthesis

The most common error when entering a formula is to reference the wrong cell in the formula.


When you enter a two-digit year that is less than 30, Excel changes the year to ____.


____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page Layout

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.


Which of the following is the path to the Conditional Formatting button?

(HOME tab | Styles group)

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

A ____ is text and graphics that print at the top of each page.


Cooler colors tend to pull away from the reader.


A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.


Which of the following is the path to the Sum arrow?

(HOME tab | Editing group)

The ____ function determines the lowest number in a range.


The ____ Option button lists formatting options following an insertion of cells, rows, or columns.


As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.


A ____ is text and graphics that print at the bottom of every page.


Moving from left to right, the first calculation in the order of operations is negation (-).


Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.


Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.


You______a worksheet to emphasize certain entries an make the worksheet easier to read and understand.


You can apply the Bold font style by pressing the ____keyboard shortcut keys.

Cntrl + B

Which of the following keys over the insertion point to the beginning of data in a cell?


The ______ preceding a formula alerts Excel that you are entering a formula or function and not text.

equal sign (=)

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab I Styles group)

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto Fill Options

Live preview is available on a touch screen


The range of cells receiving the content of copied cells is called the ____.

Destination Area

Pressing the ____ key to complete an entry activates the adjacent cell to the right.


A character with a point size of 10 is about 10/72 of one inch in height.


With Excel in Edit mode, you can edit cell contents directly in the cell.


Clicking the ___ box completes an entry.


The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area.


The first step in creating an effective worksheet is to make sure you ____.

Understand what is required

A thin red border indicates the active cell


When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.


The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range.


You should press the SPACEBAR to clear a cell.


To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.


If you accidentally undo an action , you can use the Redo button to redo it..


If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ECS key to erase the entire entry, and then reenter the data from the beginning.


An Excel_____ allows data to be summarized and charted easily.


A ______ reference is an adjusted cell reference in a copied and pasted formula.


10 6 4
31,120 points

Related questions

1 vote
1 answer 391 views
Problem: The maximum number of entry points that any programming structure can have is ____.? Which answer fits in the blank? A) five B) zero C) three D) one
asked Feb 19, 2020 maddi86 5.4k points
0 votes
1 answer 9 views
Problem: Why I got this error: how to call to undefined function split()? ny idea on what I need to fix this. I am new in c++. Thanks in advance.
asked Mar 13 jasimchaudary 1.5k points
0 votes
1 answer 83 views
Problem: Can anyone help it was actually asked in exam as following and I need to know whether my answer was right or not? In most programming languages, before you can use any variable, you must include a ____ for it? a. declaration b. definition c. header d. proclamation
asked Feb 19, 2020 maddi86 5.4k points
0 votes
1 answer 34 views
Problem: I have recently learned about the functions in C++ and I want to write a function that has three string parameters and returns the smallest string of all according to its length. How can I do that? This question might seem nonsense so I apologize for being so dumb. Thanks!
asked Feb 27 Code Learner 9.2k points
0 votes
1 answer 53 views
Problem: Hi! I am a beginner and got stuck on an assignment in which I am asked to write a python function that takes three arguments and after performing some calculation, should tell whether the three values can be used to create a triangle. I am unable to build the logic. Please help!
asked Feb 25 Code Learner 9.2k points
0 votes
1 answer 1.9K views
Problem: I am new, I need help, can anyone help me by filling in the blanks? The ________ built-in function is used to read a number that has been typed on the keyboard? A. get() B. input() C. keyboard() D. read()
asked Feb 19, 2020 maddi86 5.4k points
0 votes
1 answer 1 view
1 view
Problem: What are my options for dealing with this issue “Calculate min () is similar to the min () function”?
asked Mar 30 tuhin1 48.9k points
0 votes
1 answer 17 views
Problem: I want to implement a kind of console (function menu_principal), where the user can go to different menus according to their choice. One of these options is to enter a directory (function dir_manager, accessed with the number 1). Once the user wants to end the execution, he must type the ... * option1 = 1; // <---- THIS IS THE ERROR return; } else if (* option1 == 9) { return; } } }
asked Jan 1 sasha 16.2k points
0 votes
1 answer 25 views
Problem: I want to write a function that receives two pointers to functions and returns a pointer to the function composicion. Is it possible to do that? This was my idea: typedef int (* integerFunction) (int); integer function composition (integer function f1, integer function f2) { return f1 (f2); }
asked Jan 1 sasha 16.2k points
0 votes
1 answer 14 views
Problem: Would the following code be correct? class Person { private: string name; bool sex; int age; public: Person (); bool getSexo (); int getAge (); Person play (string s); }Hope someone could help me out?
asked Jan 25 sasha 16.2k points