Spreadsheet for Data Analysis I - 2

Spreadsheet for Data Analysis I - 2

Professional Development

15 Qs

quiz-placeholder

Similar activities

Language Objectives

Language Objectives

8th Grade - Professional Development

11 Qs

Quiz 3: Digital Wireless Communication

Quiz 3: Digital Wireless Communication

Professional Development

10 Qs

Diagnostico_ofimatica

Diagnostico_ofimatica

1st Grade - University

20 Qs

Simulasi Level 1 - Literasi

Simulasi Level 1 - Literasi

Professional Development

20 Qs

Excel Repaso

Excel Repaso

6th Grade

10 Qs

POST TEST ADUM

POST TEST ADUM

Professional Development

20 Qs

EVALUACIÓN DEL DESEMPEÑO SEMANA 5

EVALUACIÓN DEL DESEMPEÑO SEMANA 5

Professional Development

15 Qs

Spreadsheet for Data Analysis I - 2

Spreadsheet for Data Analysis I - 2

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Medium

Created by

Siddharth Gupta

Used 6+ 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

5 mins • 1 pt

Which sign is used for absolute addressing?

@

 $

&

*

2.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Which one is not a Function in MS Excel ?

SUM

AVG

MAX

MIN

3.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

What does the VLOOKUP function do?

Looks up text that contain V

Checks whether text is the same in one cell as in the next

Finds related records

All of above

4.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

In MS Excel spreadsheet, Data can be sorted using ________.

Filter function

ARRAY function

Lookup function

Operator function

5.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

The __ feature of ms excel quickly completes a series of data.

Auto Filter

Auto Complete

Auto Fill

Auto Sum

6.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

A circular reference is

Geometric modeling tool

A cell that points to a drawing object

A formula that either directly or indirectly depends on itself

Always erroneous

7.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Which of the following features cannot be found in the Data ribbon?

What-If Analysis

Pivot Table

Data Validation

Text to Columns

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?

Discover more resources for Professional Development