Reboot-7 Chapter 2

Request edit access

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Reboot-7 Chapter 2

Chapter 2 Functions and More in Excel 2019

1. Which of the following formulas is not entered correctly? *

1 point

=10+50

=B7*B1

=B7+14

10+50

2. Which Functions can be used to introduce decision-making into your spreadsheet?
*

1 point

Logical Functions

Statistical Functions

Mathematical Functions

Text Functions

3. Which function in Excel is used to find the biggest value in a range?
*

1 point

Ceiling

Sum

LEN

MAX

4. Which one of the following is not a text function in MS Excel?
*

1 point

Mid( )

Len( )

Right( )

Mod( )

5. Which option in MS Excel is used to display the rows that meet certain conditions?
*

1 point

Find

Filter

Format

Sort

6. MS Excel can ______given data.
*

1 point

statistically analyze

sort

draw graphs for

all of them

7. In MS Excel, statistical functions like average, standard deviation, median, mode, etc. can be accessed under the category
*

1 point

Logical

Maths

Date

Statistical

8. Which function is used to find the remainder from division?
*

1 point

Divide( )

Mod( )

Sum( )

SQRT( )

9. In which tab will you find the Filter option?
*

1 point

Data

Home

Insert

view

10. After selecting data and invoking Data>Filter from the menu, a _____appears in each column of the first row to enable filtering.
*

1 point

Circle

Square

triangular button

blue dot

11. What is SUM in the ample given --- SUM(10,20) *

1 point

Constant

Variable

Arguement

Function

12. ___________ function appends several strings one after another *

1 point

Join()

Concat()

Concatenate()

Add()

13. All function begin with *

1 point

14. To find an average of n numbers we use *

1 point

Mathematical functions

Statical functions

Logical functions

Text functions

15. Goal seek option is under *

1 point

Formula Tab

Home Tab

Insert Tab

Data TAB

Submit

Clear form

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms