What does the Max function do?

Returns the largest value in a set of values and ignores text.

Returns the highest three values in a set of values and ignores text.

Returns the text that you are searching for.

Returns the smallest value in a set of values and ignores text.

What does the Min function return?

Returns the smallest value in a set of values and ignores text.

Returns the smallest three numbers form a set and ignores text.

Returns the largest three numbers form a set and ignores text.

Returns the largest value in a set of values and ignores text.

When number signs (#####) are displayed in the cell, it means:

There are too many characters in the cell to be displayed with the current cell width

The formula in the cell is wrong

The decimal point placement in the cell is wrong

What is the syntax for a nested if function in Excel?

=IF(condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false2))

=IF(condition1, value_if_true1, ELSEIF(condition2, value_if_true2, value_if_false2))

=IF(condition1, value_if_true1, ELSE(condition2, value_if_true2, value_if_false2))

=IF(condition2, value_if_true1, IF(condition2, value_if_true2, value_if_false2))

What is the purpose of the SUMIF function in Excel?

To add up values based on a specific criteria or condition.

To multiply values without any condition

To subtract values based on a specific criteria

To divide values based on a specific criteria

Which of the following formulas represents a correct nested IF statement?

=IF(A1>10, "High", IF(A1>5, "Medium", "Low"))

=IF(A1>10, IF(A1>5, "Medium", "Low"), "High"," "), " "

=IF(A1>10, "High", IF("Medium", A1>5, "Low"))

=IF(A1>10, "High", "Medium", "Low")

What is the basic syntax of the IF function in Excel?

IF(logical_test,value_if_true,value_if_false)

IF(logical_condition,value_if_true,value_if_false)

IF(condition,then_value,else_value)

IF(test,do_this,otherwise_do_that)

What is a Nested IF statement in Excel?

An IF statement that is located within another IF statement

An IF statement that only has one condition

An IF statement that uses text values only

An IF statement that cannot have more than one condition

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

A function that automatically identifies and adds ranges of cells in your worksheet.

A combination of numbers and symbols used to express a calculation.

A document that is stored on your computer.

What is an Active Cell?

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

A function that automatically identifies and adds ranges of cells in your worksheet.

A combination of numbers and symbols used to express a calculation.

A document that is stored on your computer.

A “page” within an Excel workbook that contains columns, rows, and cells.

A function that automatically identifies and adds ranges of cells in your worksheet.

A combination of numbers and symbols used to express a calculation.

A document that is stored on your computer.

Year 9 Test

9th Grade

•

40 Qs

Similar activities

ASTS TIK 6 GENAP

6th Grade - University

•

35 Qs

UH Informatika 9 - 2025

9th Grade

•

40 Qs

KELAS 8 SEMESTER 1 TAHUN 2025/2026

8th Grade - University

•

40 Qs

ICT GRADE 6

6th Grade - University

•

42 Qs

LATIHAN UNTUK PTS INFORMATIKA Kelas 9

9th Grade

•

37 Qs

Computational Thinking Worksheet

7th Grade - University

•

40 Qs

KISI UAS KELAS 7F, SEMESTER GENAP TAHUN 2025

7th Grade - University

•

40 Qs

SAS Informatika Kelas 7 Ganjil

7th Grade - University

•

35 Qs

Year 9 Test

Quiz

•

Information Technology (IT)

•

9th Grade

•

Practice Problem

•

Hard

Jeganathan Kanagaratnam

FREE Resource

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Microsoft Excel is what type of software?

Word Processing

Spreadsheet

Presentation

Drawing

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The cell address of the highlighted cell is

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The intersection of a column and a row is called a __________.

Formula Bar

Cell

Template

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What function was used to find the lowest grade?

average

min

max

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What function was used to find the highest grade?

min

sum

max

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which operator is used to multiply in Excel?

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A sales manager has requested the highest sale for the first quarter. Which function will be used?

SUM

MAX

MIN

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

UH Informatika 9 - 2025

Quiz

•

9th Grade

40 questions

Computational Thinking Worksheet

Quiz

•

7th Grade - University

40 questions

KISI UAS KELAS 7F, SEMESTER GENAP TAHUN 2025

Quiz

•

7th Grade - University

35 questions

SAS Informatika Kelas 7 Ganjil

Quiz

•

7th Grade - University

35 questions

ASTS TIK 6 GENAP

Quiz

•

6th Grade - University

41 questions

Content Creation Tip, Tricks & Strategies

Quiz

•

9th - 12th Grade

39 questions

4.1-4.3 Questions

Quiz

•

9th Grade

45 questions

Kelas 5

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Information Technology (IT)

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

10 questions

Understanding Meiosis

Interactive video

•

6th - 10th Grade

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

28 questions

Ser vs estar

Quiz

•

9th - 12th Grade

20 questions

Christmas Movie Trivia

Quiz

•

9th - 12th Grade

10 questions

Exploring the Energy Cycle: Photosynthesis and Cellular Respiration

Interactive video

•

6th - 10th Grade

25 questions

photosynthesis and cellular respiration

Quiz

•

9th Grade

10 questions

Guess the Christmas Movie by the Scene Challenge

Interactive video

•

6th - 10th Grade

Year 9 Test

40 questions

Microsoft Excel is what type of software?

The cell address of the highlighted cell is

The intersection of a column and a row is called a __________.

What function was used to find the lowest grade?

What function was used to find the highest grade?

Which operator is used to multiply in Excel?

A sales manager has requested the highest sale for the first quarter. Which function will be used?

Columns in a spreadsheet are:

What does the Max function do?

What does the Min function return?

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Information Technology (IT)