test Flashcards
How do you create a new email?
Ctrl + N
How do you reply to an email?
Ctrl + R
How do you reply to all recipients of an email?
Ctrl + Shift + R
How do you forward an email?
Ctrl + F
How do you send an email?
Ctrl + Enter
How do you open an email?
Enter
How do you mark an email as read?
Ctrl + Q
How do you mark an email as unread?
Ctrl + U
How do you delete an email?
Delete
How do you permanently delete an email?
Shift + Delete
How do you move to the next email?
Ctrl + > or Down Arrow
How do you move to the previous email?
Ctrl + < or Up Arrow
How do you create a new calendar event?
Ctrl + Shift + A
How do you switch to the calendar view?
Ctrl + 2
How do you switch to the mail view?
Ctrl + 1
How do you switch to the contacts view?
Ctrl + 3
How do you switch to the tasks view?
Ctrl + 4
How do you open the search box in Outlook?
Ctrl + E or F3
How do you send and receive all emails?
F9
How do you close Outlook?
Alt + F4
How do you copy and paste quickly?
Ctrl + C / Ctrl + V (Useful for quickly duplicating data or moving information.)
How do you undo and redo actions?
Ctrl + Z / Ctrl + Y (Useful to correct mistakes or revert changes easily.)
How do you quickly apply filters?
Ctrl + Shift + L (Useful for sorting and filtering large datasets efficiently.)
How do you insert or delete a row/column?
Ctrl + Shift + ‘+’ (insert), Ctrl + ‘-‘ (delete) (Useful for adjusting table structures quickly.)
How do you use Flash Fill?
Ctrl + E (Useful for automatically detecting and filling patterns in data.)
How do you use AutoFill?
Drag the bottom-right corner of a cell (Useful for quickly extending sequences like numbers, dates, or text.)
How do you highlight important values?
Conditional Formatting (Useful for visually identifying trends, outliers, or specific data points.)
How do you search for a value in a table?
VLOOKUP or XLOOKUP (Useful for retrieving data from a table based on a specific key.)
How do you perform advanced lookups?
INDEX-MATCH (Useful as a more flexible and faster alternative to VLOOKUP.)
How do you summarize large datasets?
Pivot Tables (Useful for analyzing and summarizing complex data efficiently.)
How do you remove duplicate values?
Remove Duplicates (Useful for cleaning datasets and avoiding redundancy.)
How do you split text into multiple columns?
Text to Columns (Useful for separating data, like first and last names, into different cells.)
How do you combine text from multiple cells?
CONCATENATE or TEXTJOIN (Useful for merging names, addresses, or other text data.)
How do you make conditional decisions in Excel?
IF function (Useful for creating dynamic responses based on criteria, e.g., pass/fail.)
How do you count or sum values based on a condition?
COUNTIF / SUMIF (Useful for analyzing data by counting or summing based on a condition.)
How do you create a drop-down list in a cell?
Data Validation → List (Useful for restricting input options and making forms more user-friendly.)
How do you switch rows and columns?
Transpose (Useful when needing to reorganize data for better readability.)
How do you lock headers while scrolling?
Freeze Panes (Useful for keeping column or row titles visible when working with large sheets.)
How do you analyze ‘what-if’ scenarios?
Goal Seek (Useful for finding the necessary input value to reach a specific target output.)
How do you clean and transform large datasets?
Power Query (Useful for automating data import, transformation, and cleaning processes.)
