Search Header Logo

TERM 2 MS EXCEL QUIZ 1

Authored by Claret Dsilva

Computers

10th Grade

Used 2+ times

TERM 2 MS EXCEL QUIZ 1
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

29 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using Autosum in Excel, explain the steps to calculate the sum of a range of cells.

Click on the cell where you want the sum to appear, then click on the 'AutoSum' button in the 'Editing' group on the 'Home' tab. Excel will automatically select what it thinks is the range of cells you want to sum. If it's correct, press Enter to accept the formula. If it's not correct, click and drag to select the correct range of cells, then press Enter.

Click on the cell and press 'Delete' key

Click on the 'AutoSum' button and then press 'Ctrl + A'

Click on the cell and type 'SUM' manually

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you calculate the total of a column in Excel using the SUM function?

=SUM(range)

=minus(range, range)

=plus(range

=keep adding(range)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, how do you find the minimum value in a range of cells?

SUM(range)

AVERAGE(range)

MIN(range)

MAX(range)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the significance of using the MIN function in Excel?

It is used to find the smallest value in a range of cells.

It is used to format the cells in a specific way.

It is used to find the largest value in a range of cells.

It is used to calculate the average of a range of cells.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you determine the maximum value in a range of cells using Excel?

MAX function

SUM function

AVERAGE function

MIN function

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Explain the importance of the MAX function in Excel.

It is used to calculate the average of a range of cells.

It has no specific function in Excel.

It helps to find the lowest value in a range of cells.

It helps to find the highest value in a range of cells.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you use the TODAY function in Excel to display the current date?

=CURRENT_DATE()

=TODAY()

=NOW()

=DATE()

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?