Search Header Logo

EXCEL FUNCTIONS CYBERNETIK

Authored by Amrapali Meshram

Computers

9th - 12th Grade

EXCEL FUNCTIONS CYBERNETIK
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt


1. What is the syntax of the SUM function in Excel?

=SUM (range)

=TOTAL (range)

=COUNT (range)

=SUMMA (range)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The IF function in Excel can be used to perform what type of calculation?

Text processing

Logical comparison

Mathematical calculation

Statistical analysis

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut to sum cells quickly in Excel?

ALT+S

CTRL+S

Alt+Shift+S

CTRL+Shift+S

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function can be used to count how many unique values are in a range of cells in Excel?

COUNTIF

COUNTUNIQUE

COUNTBLANK

COUNT

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function in Excel is used to convert a text value to a number?

VALUE

INT

NUMBER

CONVERT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function is used to calculate the average of a range of numbers in Excel?

AVG

MEAN

MEDIAN

MODE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function is used to find the largest value within a range of cells in Excel?

MAX

MIN

AVERAGE

RANGE

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?