Microsoft Excel (Range)

Microsoft Excel (Range)

University

10 Qs

quiz-placeholder

Similar activities

Year 10 Plenary SUM,MAX, MIN, AVERAGE

Year 10 Plenary SUM,MAX, MIN, AVERAGE

6th Grade - University

10 Qs

Excel Formulas and Functions Quiz

Excel Formulas and Functions Quiz

University

10 Qs

TNPL Excel Quizzz 1

TNPL Excel Quizzz 1

University

15 Qs

SDE311 - Test 1 Review

SDE311 - Test 1 Review

University

9 Qs

MENGGUNAKAN EXCEL TINGKAT DASAR (TUGAS 2)

MENGGUNAKAN EXCEL TINGKAT DASAR (TUGAS 2)

University - Professional Development

15 Qs

Data Analytics

Data Analytics

University

10 Qs

Quiz in Excel 2

Quiz in Excel 2

University

10 Qs

MICROSOFT EXCEL FOR BEGINNER : INVENTORY FINANCING

MICROSOFT EXCEL FOR BEGINNER : INVENTORY FINANCING

University

10 Qs

Microsoft Excel (Range)

Microsoft Excel (Range)

Assessment

Quiz

Computers

University

Easy

Created by

Tanabro Campbell

Used 2+ times

FREE Resource

10 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

True/ False? The sum function is easier to use when your'e working with more than a few numbers.

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

The _______function returns the smallest numeric value in the data provided.

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

The ______ function in Excel is the simplest form of a mathematical function, which just returns the maximum values out of the selected values or array.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following formulas below illustrates the correct function to create the Sum (Range)?

=SUM(

=SUM(Range)

SUM=(Range)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The first formula range when creating formulas in Excel is called an?

Argument

Cell

Range

parenthesis

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

______ function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. ​

7.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

_____ (Range) function in Excel returns the number of cells that contain numbers in a given range.

COUNTA

COUNT

COUNTBLANK

COUNTIFS

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?