Advanced Operations with Excel Quiz

Advanced Operations with Excel Quiz

University

20 Qs

quiz-placeholder

Similar activities

Quiz on neural network unit II

Quiz on neural network unit II

University

16 Qs

GIS Unit-1

GIS Unit-1

University

15 Qs

Repaso U1

Repaso U1

University

16 Qs

Computer Architecture Unit 3

Computer Architecture Unit 3

University

15 Qs

IT 209

IT 209

University

15 Qs

IT (data, viruses and more)

IT (data, viruses and more)

8th Grade - Professional Development

20 Qs

PHP First Internal Practical Viva

PHP First Internal Practical Viva

University

20 Qs

Advanced Operations with Excel Quiz

Advanced Operations with Excel Quiz

Assessment

Quiz

Computers

University

Practice Problem

Medium

Created by

Ricky Manliguis

Used 5+ times

FREE Resource

AI

Enhance your content in a minute

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

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using macros in MS Excel?

To make the tasks more complicated

To automate routine tasks

To slow down the procedure

To limit the functionality of Excel

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This is one of the options in the Macros command button dropdown menu. This opens the Macro dialog box where you can select a macro to run or edit.

Use Relative References

Record Macro

View Macros

Delete Macro

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the VLOOKUP function do in MS Excel?

Sorts the data in ascending order

Counts the number of cells in a range

Searches for a value vertically

Searches for a value horizontally

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

One of the parameters of VlookUp that is value that the function uses to search on.

Range_lookup

lookup_value

Col_index_num

The table_array

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This VlookUp option is the column of data that contains the answer that you want.

Col_index_num

The table_array

lookup_value

Range_lookup

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is the area of cells in which the table is located. This includes not only the column being searched on, but the data columns for which you are going to get the values that you need.

Col_index_num

The table_array

lookup_value

Range_lookup

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you email a workbook in MS Excel?

Choose File » Print

Choose File » Save and Send

Choose View » Email Workbook

Choose Edit » Send Email

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?