Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

excel > EXCEL- BASICS 2 > Flashcards

EXCEL- BASICS 2 Flashcards

1
Q

LOGIC AND ERRORS

A

CENTRALLY ALIGNED

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

NOT EQUAL OPERATOR

A

<>

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

AND FUNCTION

A

ALL LOGIC MUST BE TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

OR FUNCTION

A

ONE LOGIC MUST BE TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

LOGICAL BUILT-IN FUNCTIONS

A
  1. ISTEXT
  2. ISNUMBER
  3. ISLOGICAL
  4. ISERROR
  5. ISERR
  6. ISNA
  7. ISBLANK
  8. ISNONTEXT
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ISERR VS. ISERROR

A

ISERR- NO #N/A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

TYPES OF ERROR

A
  1. # N/A
  2. # VALUE!
  3. # REF!
  4. # DIV/0!
  5. # NUM!
  6. # NAME?
  7. # NULL!
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

N/A

A

NOT AVAILABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

REF!

A

REFERENCE PROBLEM LIKE DELETED

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DIV/0!

A

DIVIDE BY 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

NUM!

A

TOO LARGE OR SMALL NUMBER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

VALUE!

A

WRONG OPERATIONS ON TEXT OR NUMBERS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

NULL!

A

NO INTERSECTION

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

NAME?

A

WHAT NAME YOU HAVE IN A FORMULA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

INSTEAD OF DRAGGING FOR AUTOMATIC FILLING

A

DOUBLE CLICK ON THE CORNER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

ADVANTAGE OF IF FUNCTION

A

REPLACE TRUE/FALSE ANSWERS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

SPELL CHECK

A

IN EDIT MODE ONLY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

CONDITIONAL FORMATTING

A

UNDER HOME-> STYLE-> NEW RULE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

DATE FUNCTIONS

A
  1. TODAY
  2. NOW
  3. YEAR
  4. MONTH
  5. DAY
  6. DATE
  7. EDATE
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

TODAY

A
  1. NO ARGUMENT

2. TODAY’S DATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

NOW

A
  1. NO ARGUMENT

2. TODAY’S DATE & TIME

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

ADVANTAGE OF DATE

A

DAY ARGUMENT CAN BE GIVEN ANY VALUE

23
Q

EDATE

A

ADDING OR SUBTRACTING MONTHS

24
Q

TRIM FUNCTION

A

Get Rid of All Spaces Except for Single Spaces Between Words

25
Q

PROPER FUNCTION

A

GET RID OF CAPITAL LETTERS EXCEPT FOR FIRST LETTERS OF EACH WORD

26
Q

FIND AND SEARCH FUNCTION

A
  1. FIND CASE-SENSITIVE
  2. SEARCH NOT CASE-SENSITIVE
  3. BOTH FINDS POSITION
  4. FIND_TEXT IN DOUBLE QUOTES
27
Q

SUBSTITUTE FUNCTION

A
  1. REPLACING ONE TEXT WITH ANOTHER TEXT

2. INSTANCE_NUM MEANS WHICH OCCURRENCE TO REPLACE; BY DEFAULT IT REPLACE ALL OCCURRENCE

28
Q

REPLACE FUNCTION

A

REPLACE THE PART WITH SOMETHING ELSE

29
Q

LEFT FUNCTION

A

GET LEFT PART ONLY

30
Q

TEXTS CONCATENATED USING

A
  1. &

2. CONCATENATE FUNCTION

31
Q

DATA SETUP

A
  1. FIELD NAMES
  2. NO BLANK FIELD NAMES
  3. NO BLANK COLUMNS (FIELDS)
  4. NO BLANK ROWS (RECORDS)
  5. BLANK ROW/ COLUMNS SEPARATING ONE LIST FROM OTHER
32
Q

NEED OF DATA SETUP

A

EASY TO SORT, FILTER, PIVOT, SUBTOTAL

33
Q

BLANK ROW/ COLUMNS SEPARATING ONE LIST FROM OTHER

A

OTHERWISE BECOMES PART OF THE DATA EARLIER

34
Q

CTRL+*

A

HIGHLIGHTS THE CURRENT DATA SET

35
Q

CTRL+T OR CTRL+L

A

INSERT TABLE

36
Q

TABLE

A
  1. FORMATTING
  2. SORT AND FILTER APPEARS AUTOMATICALLY
  3. CAN “CONVERT TO RANGE” IN HOME RIBBON
  4. USE OF TAB ON LAST RECORD TO ADD NEW RECORD
  5. USE OF NAME OF TABLE AND USE OF SQUARE BRACKETS TO GET THE APPROPRIATE FIELD IN THAT TABLE
  6. NAME CAN BE USED IN OTHER WORKSHEETS AS WELL
37
Q

FORMATTING OF TABLES

A
  1. CAN HAVE NEW STYLE
  2. IN CUSTOM IN DESIGN->QUICK STYLES OR IN HOME-> FORMAT AS TABLE
  3. CAN BE ALSO SET AS DEFAULT
38
Q

CTRL+HOME

A

JUMPS TO A1

39
Q

TABLE IS DYNAMIC

A

ANY FORMULA AUTOMATICALLY UPDATES IF NEW RECORD IS ADDED LIKE IN SUM, CHARTS, PIVOT ETC.

40
Q

CTRL+F3

A

NAME MANAGER

41
Q

SHIFT+F11

A

NEW WORKSHEET

42
Q

SORT

A
  1. CLICK ON ONE CELL IN DATA LIST
  2. SORT IN HOME OR DATA RIBBON
  3. ALL OTHER COLUMNS ARE ALSO ARRANGED
  4. ONLY USE ONE CELL TO START SORT OR EXPAND THE SELECTION
43
Q

CTRL+SHIFT+~

A

GETS NUMBER TO GENERAL FORMAT

44
Q

TO GET THE ORIGINAL DATA AFTER SORTING

A

INSERT ORDER FIELD

45
Q

MAJOR SORT & MINOR SORT

A
  1. FIRST WE HAVE THE MAJOR SORT
  2. THEN SOME MINOR SORT IS DONE WITHIN MAJOR SORT IN OTHER FIELD
  3. CAN DO IT IN CUSTOM SORT
46
Q

MAJOR SORT & MINOR SORT

A
  1. WITHOUT CUSTOM SORT, MINOR SORT IS FIRST

2. WITH CUSTOM SORT, MINOR SORT IS LAST

47
Q

HORIZONTAL SORT

A

USING CUSTOM SORT

48
Q

SORTING CAN BE DONE BY COLORS ALSO

A
  1. WITH TABLE

2. WITHOUT TABLE

49
Q

ADDING A COLUMN TO A TABLE

A
  1. AUTOMATICALLY GENERATES THE FIELD

2. AUTOMATICALLY FILLS WHOLE WITHOUT DRAGGING OR DOUBLE CLICKING

50
Q

RANDOM SORT

A

USING RAND () FUNCTION

51
Q

FILTERING

A
  1. BY HIDING THE ROWS- ROWS’ HEADER TURNS BLUE
  2. FILTER SYMBOL ON FIELD
  3. COPIES ONLY ROWS WHICH ARE VISIBLE
  4. CLEAR FILTER BUTTON- EVEN MULTIPLE FILTERING
  5. BY COLOR ALSO
  6. MULTIPLE FILTERING POSSIBLE
  7. TEXT FILTERS, DATE FILTERS, NUMBER FILTERS, CUSTOM FILTERS
52
Q

CTRL+SHIFT+L

A

FILTER

53
Q

PIVOT TABLE

A
  1. COLUMN HEADER
  2. ROW HEADER
  3. PIVOT TABLE OPTION: CLASSICAL DISPLAY VERSUS 2007 DISPLAY
  4. DRAG OR RIGHT CLICK
  5. CAN SUMMARIZE BY MONTHS ETC. AUTOMATICALLY WITHOUT USING DATE FUNCTIONS: RIGHT CLICK & GROUP
  6. PIVOT TABLE OPTIONS TOOLS
  7. DESIGN- PIVOT TABLE STYLE OPTIONS
  8. DOUBLE CLICK ON A CELL IN PIVOT AND YOU GET ALL THE DATA RELATED TO THAT CELL IN A NEW SHEET
  9. EASY TO PIVOT
54
Q

VALUE FIELD SETTINGS

A

E.G. TO CHANGE SUM OF SALES AS WELL AS FORMATTING

excel (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions