computer science test 2 (data validation + vlookup)

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/9

encourage image

There's no tags or description

Looks like no tags are added yet.

10 Terms

1
New cards

How to write a custom list

Words separated by commas

2
New cards

How to lock column

$ sign before letter

3
New cards

How to lock row

$ sign before the number

4
New cards

What can conditional formatting do?

Highlight cells above or below a certain value

5
New cards

What are the arguments in vlookup formula

(lookup value, full range, column, FALSE/TRUE)

6
New cards

Difference between false and true in vlookup

FALSE looks for exact lookup value, TRUE looks for an approximate and will round down.

7
New cards

Arguments in xlookup

(Lookup value, lookup range, return range, what it shows if not found, match mode, search mode)

8
New cards

Match mode numbers

0 : exact match

-1 : next smaller

1 : next larger

2 : wildcard (allows special characters)

9
New cards

Search mode numbers

1: search top to bottom

-1: search bottom to top

2: binary search top to bottom

-2: binary search bottom to top

10
New cards

What is binary search

It splits data to perform functions faster