Compubotics - Excel

Compubotics - Excel

Professional Development

10 Qs

quiz-placeholder

Similar activities

Mejora continua y talento humano

Mejora continua y talento humano

Professional Development

10 Qs

MEETINGS AND RESOLUTION (SK MT)

MEETINGS AND RESOLUTION (SK MT)

Professional Development

10 Qs

Harry Potter Book Trivia

Harry Potter Book Trivia

1st Grade - Professional Development

10 Qs

2020 Jagaur XE Quiz

2020 Jagaur XE Quiz

Professional Development

10 Qs

GUESS THE SPORT

GUESS THE SPORT

1st Grade - Professional Development

10 Qs

Black History Month

Black History Month

Professional Development

10 Qs

Beyblade Burst

Beyblade Burst

KG - Professional Development

10 Qs

Get to know THC & TVS

Get to know THC & TVS

University - Professional Development

11 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?