EXCEL- BASICS 2

Question 1

LOGIC AND ERRORS

Answer 1

CENTRALLY ALIGNED

Question 2

NOT EQUAL OPERATOR

Answer 2

<>

Question 3

AND FUNCTION

Answer 3

ALL LOGIC MUST BE TRUE

Question 4

OR FUNCTION

Answer 4

ONE LOGIC MUST BE TRUE

Question 5

LOGICAL BUILT-IN FUNCTIONS

Answer 5

1. ISTEXT
2. ISNUMBER
3. ISLOGICAL
4. ISERROR
5. ISERR
6. ISNA
7. ISBLANK
8. ISNONTEXT

Question 6

ISERR VS. ISERROR

Answer 6

ISERR- NO #N/A

Question 7

TYPES OF ERROR

Answer 7

1. # N/A
2. # VALUE!
3. # REF!
4. # DIV/0!
5. # NUM!
6. # NAME?
7. # NULL!

Question 8

N/A

Answer 8

NOT AVAILABLE

Question 9

REF!

Answer 9

REFERENCE PROBLEM LIKE DELETED

Question 10

DIV/0!

Answer 10

DIVIDE BY 0

Question 11

NUM!

Answer 11

TOO LARGE OR SMALL NUMBER

Question 12

VALUE!

Answer 12

WRONG OPERATIONS ON TEXT OR NUMBERS

Question 13

NULL!

Answer 13

NO INTERSECTION

Question 14

NAME?

Answer 14

WHAT NAME YOU HAVE IN A FORMULA

Question 15

INSTEAD OF DRAGGING FOR AUTOMATIC FILLING

Answer 15

DOUBLE CLICK ON THE CORNER

Question 16

ADVANTAGE OF IF FUNCTION

Answer 16

REPLACE TRUE/FALSE ANSWERS

Question 17

SPELL CHECK

Answer 17

IN EDIT MODE ONLY

Question 18

CONDITIONAL FORMATTING

Answer 18

UNDER HOME-> STYLE-> NEW RULE

Question 19

DATE FUNCTIONS

Answer 19

1. TODAY
2. NOW
3. YEAR
4. MONTH
5. DAY
6. DATE
7. EDATE

Question 20

TODAY

Answer 20

1. NO ARGUMENT

2. TODAY’S DATE

Question 21

NOW

Answer 21

1. NO ARGUMENT

2. TODAY’S DATE & TIME

Question 22

ADVANTAGE OF DATE

Answer 22

DAY ARGUMENT CAN BE GIVEN ANY VALUE

Question 23

EDATE

Answer 23

ADDING OR SUBTRACTING MONTHS

Question 24

TRIM FUNCTION

Answer 24

Get Rid of All Spaces Except for Single Spaces Between Words

Question 25

PROPER FUNCTION

Answer 25

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

Question 26

FIND AND SEARCH FUNCTION

Answer 26

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

Question 27

SUBSTITUTE FUNCTION

Answer 27

1. REPLACING ONE TEXT WITH ANOTHER TEXT | 2. INSTANCE_NUM MEANS WHICH OCCURRENCE TO REPLACE; BY DEFAULT IT REPLACE ALL OCCURRENCE

Question 28

REPLACE FUNCTION

Answer 28

REPLACE THE PART WITH SOMETHING ELSE

Question 29

LEFT FUNCTION

Answer 29

GET LEFT PART ONLY

Question 30

TEXTS CONCATENATED USING

Answer 30

1. & | 2. CONCATENATE FUNCTION

Question 31

DATA SETUP

Answer 31

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

Question 32

NEED OF DATA SETUP

Answer 32

EASY TO SORT, FILTER, PIVOT, SUBTOTAL

Question 33

BLANK ROW/ COLUMNS SEPARATING ONE LIST FROM OTHER

Answer 33

OTHERWISE BECOMES PART OF THE DATA EARLIER

Question 34

CTRL+*

Answer 34

HIGHLIGHTS THE CURRENT DATA SET

Question 35

CTRL+T OR CTRL+L

Answer 35

INSERT TABLE

Question 36

TABLE

Answer 36

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

Question 37

FORMATTING OF TABLES

Answer 37

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

Question 38

CTRL+HOME

Answer 38

JUMPS TO A1

Question 39

TABLE IS DYNAMIC

Answer 39

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

Question 40

CTRL+F3

Answer 40

NAME MANAGER

Question 41

SHIFT+F11

Answer 41

NEW WORKSHEET

Question 42

SORT

Answer 42

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

Question 43

CTRL+SHIFT+~

Answer 43

GETS NUMBER TO GENERAL FORMAT

Question 44

TO GET THE ORIGINAL DATA AFTER SORTING

Answer 44

INSERT ORDER FIELD

Question 45

MAJOR SORT & MINOR SORT

Answer 45

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

Question 46

MAJOR SORT & MINOR SORT

Answer 46

1. WITHOUT CUSTOM SORT, MINOR SORT IS FIRST | 2. WITH CUSTOM SORT, MINOR SORT IS LAST

Question 47

HORIZONTAL SORT

Answer 47

USING CUSTOM SORT

Question 48

SORTING CAN BE DONE BY COLORS ALSO

Answer 48

1. WITH TABLE | 2. WITHOUT TABLE

Question 49

ADDING A COLUMN TO A TABLE

Answer 49

1. AUTOMATICALLY GENERATES THE FIELD | 2. AUTOMATICALLY FILLS WHOLE WITHOUT DRAGGING OR DOUBLE CLICKING

Question 50

RANDOM SORT

Answer 50

USING RAND () FUNCTION

Question 51

FILTERING

Answer 51

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

Question 52

CTRL+SHIFT+L

Answer 52

FILTER

Question 53

PIVOT TABLE

Answer 53

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

Question 54

VALUE FIELD SETTINGS

Answer 54

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