Search Header Logo

Advanced features of excel

Authored by Nazia Naseer

Computers

6th Grade

Used 186+ times

Advanced features of excel
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

The.................... feature lets you quickly enter a pre-defined series of data.

AutoFill

FlashFill

CustomFill

Copy

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To remove conditional formatting, click ..................in the Condition Formatting drop-down menu.

clear rules

Manage rules

Clear option

None of These

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

..................recognizes the data fill pattern in a worksheet and fills the remaining series according.

AutoFill

Custom Fill

Flash fill

None of These

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The Conditional Formatting button is present in the ____________ group on the Home Tab.

Styles

Cells

Editing

Alignment

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Options for sorting and filtering the data are present on the Home tab and the Data tab.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The button A to Z is used to arrange the data in descending order.

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following type of data are sorted by the Sorting feature.

Textual

Numeric

Alphanumeric

All of these

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?