Search Header Logo

BNB_ExcelTest

Authored by Kaushik Ghosh

Computers

6th - 7th Grade

Used 4+ times

BNB_ExcelTest
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a column has joint-data (such as last name, first name), you can automatically "pull" sections of the data into a new column by using:

Flashfill
Autofill
Merge & Center
Copy and Paste

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify.

sum
countif
trim
vlookup

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

And, Or, and Not are called __________ operator.

comparison
logical
arithmetic
connector

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following has a syntax error?

If(B3<=20,"good",If(B3=<30,"better","best))

If(B3<=75,"pass",if(B3<=60,"credit","distinction"))

If(B3="blue","Boy,"Girl")

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you fix only one column

$B$2

$B2

B$2

B2$

6.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

The absolute cell reference uses which symbol:

$

%

*

&

7.

MULTIPLE CHOICE QUESTION

30 sec • 5 pts

To combine text that is in two different cells, use the formula:

COMBINE

MATCH

CONCATENATE

SUBTOTAL

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?