test

Question 1

How do you create a new email?

Answer 1

Ctrl + N

Question 2

How do you reply to an email?

Answer 2

Ctrl + R

Question 3

How do you reply to all recipients of an email?

Answer 3

Ctrl + Shift + R

Question 4

How do you forward an email?

Answer 4

Ctrl + F

Question 5

How do you send an email?

Answer 5

Ctrl + Enter

Question 6

How do you open an email?

Answer 6

Enter

Question 7

How do you mark an email as read?

Answer 7

Ctrl + Q

Question 8

How do you mark an email as unread?

Answer 8

Ctrl + U

Question 9

How do you delete an email?

Answer 9

Delete

Question 10

How do you permanently delete an email?

Answer 10

Shift + Delete

Question 11

How do you move to the next email?

Answer 11

Ctrl + > or Down Arrow

Question 12

How do you move to the previous email?

Answer 12

Ctrl + < or Up Arrow

Question 13

How do you create a new calendar event?

Answer 13

Ctrl + Shift + A

Question 14

How do you switch to the calendar view?

Answer 14

Ctrl + 2

Question 15

How do you switch to the mail view?

Answer 15

Ctrl + 1

Question 16

How do you switch to the contacts view?

Answer 16

Ctrl + 3

Question 17

How do you switch to the tasks view?

Answer 17

Ctrl + 4

Question 18

How do you open the search box in Outlook?

Answer 18

Ctrl + E or F3

Question 19

How do you send and receive all emails?

Answer 19

F9

Question 20

How do you close Outlook?

Answer 20

Alt + F4

Question 22

How do you copy and paste quickly?

Answer 22

Ctrl + C / Ctrl + V (Useful for quickly duplicating data or moving information.)

Question 23

How do you undo and redo actions?

Answer 23

Ctrl + Z / Ctrl + Y (Useful to correct mistakes or revert changes easily.)

Question 24

How do you quickly apply filters?

Answer 24

Ctrl + Shift + L (Useful for sorting and filtering large datasets efficiently.)

Question 25

How do you insert or delete a row/column?

Answer 25

Ctrl + Shift + '+' (insert), Ctrl + '-' (delete) (Useful for adjusting table structures quickly.)

Question 26

How do you use Flash Fill?

Answer 26

Ctrl + E (Useful for automatically detecting and filling patterns in data.)

Question 27

How do you use AutoFill?

Answer 27

Drag the bottom-right corner of a cell (Useful for quickly extending sequences like numbers, dates, or text.)

Question 28

How do you highlight important values?

Answer 28

Conditional Formatting (Useful for visually identifying trends, outliers, or specific data points.)

Question 29

How do you search for a value in a table?

Answer 29

VLOOKUP or XLOOKUP (Useful for retrieving data from a table based on a specific key.)

Question 30

How do you perform advanced lookups?

Answer 30

INDEX-MATCH (Useful as a more flexible and faster alternative to VLOOKUP.)

Question 31

How do you summarize large datasets?

Answer 31

Pivot Tables (Useful for analyzing and summarizing complex data efficiently.)

Question 32

How do you remove duplicate values?

Answer 32

Remove Duplicates (Useful for cleaning datasets and avoiding redundancy.)

Question 33

How do you split text into multiple columns?

Answer 33

Text to Columns (Useful for separating data, like first and last names, into different cells.)

Question 34

How do you combine text from multiple cells?

Answer 34

CONCATENATE or TEXTJOIN (Useful for merging names, addresses, or other text data.)

Question 35

How do you make conditional decisions in Excel?

Answer 35

IF function (Useful for creating dynamic responses based on criteria, e.g., pass/fail.)

Question 36

How do you count or sum values based on a condition?

Answer 36

COUNTIF / SUMIF (Useful for analyzing data by counting or summing based on a condition.)

Question 37

How do you create a drop-down list in a cell?

Answer 37

Data Validation → List (Useful for restricting input options and making forms more user-friendly.)

Question 38

How do you switch rows and columns?

Answer 38

Transpose (Useful when needing to reorganize data for better readability.)

Question 39

How do you lock headers while scrolling?

Answer 39

Freeze Panes (Useful for keeping column or row titles visible when working with large sheets.)

Question 40

How do you analyze 'what-if' scenarios?

Answer 40

Goal Seek (Useful for finding the necessary input value to reach a specific target output.)

Question 41

How do you clean and transform large datasets?

Answer 41

Power Query (Useful for automating data import, transformation, and cleaning processes.)