Ms xecel

Ms xecel

Professional Development

13 Qs

quiz-placeholder

Similar activities

Segunda Guerra Mundial

Segunda Guerra Mundial

12th Grade - Professional Development

15 Qs

Cricket

Cricket

KG - Professional Development

10 Qs

Roman Quiz

Roman Quiz

5th Grade - Professional Development

13 Qs

ASESMENT SLM E.1 Pengertian Ilmu Sejarah

ASESMENT SLM E.1 Pengertian Ilmu Sejarah

Professional Development

15 Qs

Masuknya Hindu-Buddha ke Nusantara

Masuknya Hindu-Buddha ke Nusantara

12th Grade - Professional Development

15 Qs

United States Presidents Quiz!

United States Presidents Quiz!

KG - Professional Development

15 Qs

Proceso de independencia de Chile y América

Proceso de independencia de Chile y América

Professional Development

10 Qs

President's Day Quiz

President's Day Quiz

KG - Professional Development

10 Qs

Ms xecel

Ms xecel

Assessment

Quiz

History

Professional Development

Medium

Created by

sonia tokas

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

1. What does the TRIM function do in Excel?
a) Removes all spaces from a text string
b) Removes extra spaces except for single spaces between words
c) Converts text to uppercase
d) Removes special characters

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

2. What does the LOWER function do in Excel?
a) Converts text to uppercase
b) Converts text to lowercase
c) Capitalizes the first letter of each word
d) Replaces lowercase letters with numbers

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

3. Which function is used to find the row number of a value in a column?
a) INDEX
b) MATCH
c) HLOOKUP
d) OFFSET

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

4. What is the main difference between VLOOKUP and HLOOKUP?
a) VLOOKUP searches horizontally, HLOOKUP searches vertically
b) VLOOKUP searches vertically, HLOOKUP searches horizontally
c) VLOOKUP can only search in sorted data
d) HLOOKUP can only search in sorted data

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

5. Which combination is more flexible than VLOOKUP for looking up values?
a) SUMIF & COUNTIF
b) CONCATENATE & SUBSTITUTE
c) INDEX & MATCH
d) HLOOKUP & IF

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

6. What will the formula =IF(A1>10,"High","Low") return if A1 is 5?
a)low
b)High
c)10
d)Error

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

7. What will the formula =AND(A1>5, A1<15) return if A1 is 20?
b) FALSE
a) TRUE
c) 20
d) Error

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?