Search Header Logo

Excel Features and Functions Quiz

Authored by SHANIMOL BARAKATH

Other

Professional Development

Used 1+ times

Excel Features and Functions Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

23 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, the sort feature allows you to arrange data in ascending or descending order.

ascending

descending

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To sort data alphabetically from A to Z, we use the Ascending sort option.

Ascending

Descending

3.

OPEN ENDED QUESTION

3 mins • 1 pt

To select an entire worksheet, you can press the keyboard shortcut Ctrl+A or click the Select All button.

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

To select non-adjacent rows or columns, you should hold down the Ctrl key while making your selections.

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

To enter a number like '01481' and prevent Excel from dropping the leading zero, you must type an apostrophe before the number, which treats it as text.

Evaluate responses using AI:

OFF

6.

OPEN ENDED QUESTION

3 mins • 1 pt

Cell content can be modified by either replacing the content directly or by using the edit mode.

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

The undo command is used to cancel your last action. Its keyboard shortcut is Ctrl+Z.

Evaluate responses using AI:

OFF

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?