Compubotics - Excel

Compubotics - Excel

Professional Development

10 Qs

quiz-placeholder

Similar activities

Quiz Night - Round One

Quiz Night - Round One

Professional Development

10 Qs

Chúa tể ngôn ngữ, chơi chữ thần công , thần đồng tiếng Việt :)))

Chúa tể ngôn ngữ, chơi chữ thần công , thần đồng tiếng Việt :)))

Professional Development

10 Qs

Y más Bacon para la Nata

Y más Bacon para la Nata

KG - Professional Development

12 Qs

Disney Babies/Parents

Disney Babies/Parents

Professional Development

15 Qs

Effective Complain Handling

Effective Complain Handling

Professional Development

10 Qs

Christmas

Christmas

Professional Development

13 Qs

Who's Your Bebe?

Who's Your Bebe?

Professional Development

10 Qs

Preguntas Takers y Culto Mes de Marzo

Preguntas Takers y Culto Mes de Marzo

Professional Development

10 Qs

Compubotics - Excel

Compubotics - Excel

Assessment

Quiz

Fun

Professional Development

Practice Problem

Hard

Created by

mohammadfaedzwan abdulrahman

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...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following logical operations will  make A = 2 and B = 4 return a FALSE statement?

A <= B

A >= B

A <> B

2*A = B

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you wanted to lock Cell A10’s column in further calculations how would you reference it in the formula?

Type A10

Type $A$10

Type $A10

Type A$10

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you wanted to lock Cell A10’s row in further calculations how would you reference it in the formula?

Type A10

Type $A$10

Type $A10

Type A$10

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

When starting from the top of a table, what is the shortcut to select all the values along a column?

CTRL+SHIFT+R

CTRL+SHIFT+L

CTRL+SHIFT+D

              

CTRL+SHIFT+U

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT an Excel wildcard for working with strings?

Asterisk (*)

   Question mark (?)

Ampersand (&)

Tilde (~)

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following data types can be counted using COUNT?

Blanks

Dates

Strings

Numbers

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a piece of information you need to provide to use VLOOKUP?

The lookup value

The range of cells

The number of the column to retrieve the result from

   The data type of the value

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?