Search Header Logo

Part 2

Authored by Tshepiso Makelana

Other

University

Part 2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What happens when you insert a new column in Excel?

The worksheet is duplicated

The new column appears to the left of the selected column, shifting the rest to the right

A column appears to the right of the selected column

All rows are deleted

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following is not a cell formatting option?

Number

Alignment

Worksheet

Font

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which function would you use to find the total of the total number of non-empty cells?

IF

SUM

COUNT

MIN

4.

MULTIPLE CHOICE QUESTION

20 sec • 3 pts

What does the COUNTIF function do?

Counts the total number of rows

Adds a range of cells

Counts cells based on a specific condition

Multiplies values in cells

5.

MULTIPLE CHOICE QUESTION

30 sec • 3 pts

What’s the main difference between a formula and a function in Excel?

There is no difference

B) A function is built-in and simplifies formulas, whereas a formula can be any calculation created by the user

A formula is built-in while a function is user-created

A formula can’t handle large data sets while a function can

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which function would you use to find the largest number in a range?

AVERAGE

MIN

SUMIF

MAX

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?