Excel Tables, Data Lists and Conditional Formatting

Excel Tables, Data Lists and Conditional Formatting

University - Professional Development

15 Qs

quiz-placeholder

Similar activities

Server Administration- Quiz 1

Server Administration- Quiz 1

12th Grade - University

10 Qs

Computer Science (1-9) - Identifying & Preventing Threats

Computer Science (1-9) - Identifying & Preventing Threats

University

11 Qs

Informatika Kelas 5 Bab 2

Informatika Kelas 5 Bab 2

5th Grade - University

19 Qs

Mastering KineMaster

Mastering KineMaster

Professional Development

10 Qs

have fun with econometrics

have fun with econometrics

University

15 Qs

PSSI Chp 1 dan 2

PSSI Chp 1 dan 2

University

12 Qs

TES AWAL MODUL 2

TES AWAL MODUL 2

University

10 Qs

Algo Quiz

Algo Quiz

University

16 Qs

Excel Tables, Data Lists and Conditional Formatting

Excel Tables, Data Lists and Conditional Formatting

Assessment

Quiz

Computers

University - Professional Development

Practice Problem

Hard

Created by

Jenny Ibias

Used 8+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If I want to create a drop down list of items, where should I go?

Data - Data validation

Insert - Objects

Data - Group

Insert - Table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is a formatting style that allows different data analysis.

Simple formatting

Conditional formatting

Layout design

Data analysis

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Table-like format done by adding cell borders allows sorting of data.

True

False

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Expanding and collapsing groups of data can be done by hiding and unhiding rows or columns.

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Grouping and ungrouping data sets are under Insert Ribbon.

True

False

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Large datasets always involves more than two worksheets.

True

False

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Collapsing and expanding data groups are represented with what symbols?

+ / +

* / -

+ / -

> / <

Create a free account and access millions of resources

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?