Spreadsheet for Data Analysis I - 2

Spreadsheet for Data Analysis I - 2

Professional Development

15 Qs

quiz-placeholder

Similar activities

UJIAN PEMBINAAN KKG 2019

UJIAN PEMBINAAN KKG 2019

University - Professional Development

15 Qs

Stress and Havoc or Peace and Calm

Stress and Havoc or Peace and Calm

Professional Development

20 Qs

Kelas Siap Menjadi HR Staff Batch 5

Kelas Siap Menjadi HR Staff Batch 5

KG

20 Qs

Microsoft Excel

Microsoft Excel

KG - Professional Development

20 Qs

QUIZ WORKSHOP MICROSOFT EXCEL

QUIZ WORKSHOP MICROSOFT EXCEL

University

20 Qs

Certification Technical Training FY23

Certification Technical Training FY23

Professional Development

20 Qs

2021 GANJIL PTS GTO TKRO

2021 GANJIL PTS GTO TKRO

10th Grade

20 Qs

KUIS AKHIR PPN B 2023

KUIS AKHIR PPN B 2023

1st Grade

10 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