Microsoft Excel Quiz #10 This is is the 10th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 17 What is the keyboard shortcut to save an Excel workbook? Ctrl + P Ctrl + S Ctrl + N Ctrl + O 2 / 17 Which of the following options is used to create a new email in Microsoft Outlook? Home File View Send/Receive 3 / 17 Which chart type is best for comparing values across categories? Scatter chart Bar chart Line chart Pie chart 4 / 17 What is the keyboard shortcut to undo the last action in Excel? Ctrl + X Ctrl + Z Ctrl + V Ctrl + C 5 / 17 Which chart type should be used to display data that changes over time? Pie chart Bar chart Line chart Scatter chart 6 / 17 Which feature in Excel allows you to apply a formula to multiple cells at once? Autofill Copy and P Fill Series Format Painter 7 / 17 Which function is used to calculate the average of a range of cells in Excel? COUNT AVERAGE MAX SUM 8 / 17 Which function is used to calculate the sum of a range of cells in Excel? COUNT SUM MAX AVERAGE 9 / 17 Which Excel function is used to find the total number of cells in a range that contain numbers? SUM MAX AVERAGE COUNT 10 / 17 Which feature in Excel allows you to group and summarize data? Freeze Panes Pivot tables Filter Sort 11 / 17 Which function is used to calculate the sum of a range of cells in Excel? SUM COUNT MAX AVERAGE 12 / 17 What is the shortcut key to insert a new row in Excel? Ctrl + Shift + + Ctrl + Shift + R Ctrl + R Ctrl + Alt + R 13 / 17 Which Excel function is used to find the smallest value in a range of cells? COUNT MAX AVERAGE MIN 14 / 17 Which function is used to find the highest value in a range of cells? COUNT MAX MIN AVERAGE 15 / 17 Which Excel function is used to round a number to a specified number of decimal places? ROUND TRUNC FLOOR CEILING 16 / 17 Which keyboard shortcut is used to open the Format Cells dialog box in Excel? Ctrl + 2 Ctrl + 3 Ctrl + 1 Ctrl + 4 17 / 17 Which of the following options is used to set up a signature for your emails in Microsoft Outlook? Options File Home View Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #9 This is is the 9th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 15 Which keyboard shortcut is used to open the Insert Function dialog box in Excel? Ctrl + Shift + L Ctrl + Shift + A Ctrl + Shift + F Ctrl + Shift + G 2 / 15 Which chart type should be used to show the relationship between two variables? Line chart Bar chart Pie chart Scatter chart 3 / 15 Which of the following options is used to add an attachment to an email in Microsoft Outlook? Home File View Insert 4 / 15 Which of the following options is used to create a new calendar appointment in Microsoft Outlook? View Home File Calendar 5 / 15 Which Excel function is used to concatenate (join) two or more strings of text? TEXTJOIN JOIN CONCAT MERGE 6 / 15 What is the keyboard shortcut to insert a new column in Excel? Ctrl + Alt + C Ctrl + C Ctrl + Shift + + Ctrl + Shift + C 7 / 15 Which of the following options is used to delete an email in Microsoft Outlook? Send/Receive View Home File 8 / 15 Which of the following options is used to set up an out of office auto-reply in Microsoft Outlook? Home View Options File 9 / 15 Which of the following options is used to flag an email for follow-up in Microsoft Outlook? File Home Send/Receive View 10 / 15 Which of the following options is used to mark an email as unread in Microsoft Outlook? View File Send/Receive Home 11 / 15 Which of the following options is used to create a new contact in Microsoft Outlook? Send/Receive File Home View 12 / 15 Which chart type should be used to display proportions or percentages? Line chart Bar chart Pie chart Scatter chart 13 / 15 Which Excel function is used to calculate the product of a range of cells? COUNT MAX PRODUCT SUM 14 / 15 Which Excel function is used to find the largest integer less than or equal to a specified number? CEILING FLOOR ROUNDUP ROUNDDOWN 15 / 15 Which feature in Excel allows you to freeze the rows and columns of a worksheet? Freeze Panes Filter Sort Pivot tables Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #8 This is is the 8th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 8 Which of the following options is used to create a new task in Microsoft Outlook? View Home File Tasks 2 / 8 Which Excel function is used to count the number of cells in a range that meet a specific criteria? COUNT AVERAGE COUNTIF SUM 3 / 8 Which Excel function is used to calculate the difference between two dates? DATEDIF MONTHS DAYS YEARS 4 / 8 Which chart type should be used to show the distribution of data? Pie chart Bar chart Histogram Line chart 5 / 8 Which of the following options is used to search for an email in Microsoft Outlook? File Search Home View 6 / 8 Which of the following options is used to access the address book in Microsoft Outlook? File View Contacts Home 7 / 8 Which of the following options is used to move an email to a folder in Microsoft Outlook? Send/Receive File Home View 8 / 8 Which keyboard shortcut is used to apply the bold formatting to selected text in Excel? Ctrl + Shift + B Ctrl + U Ctrl + B Ctrl + I Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #7 This is is the 7th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 8 Which of the following options is used to mark an email as important in Microsoft Outlook? File View Send/Receive Home 2 / 8 Which Excel function is used to calculate the exponential growth of a value over time? TREND EXP GROWTH FORECAST 3 / 8 Which of the following options is used to schedule a meeting in Microsoft Outlook? Calendar File Home View 4 / 8 Which keyboard shortcut is used to delete a selected cell, row, or column in Excel? Ctrl + X Ctrl + D Ctrl + – Ctrl + C 5 / 8 Which feature in Excel allows you to highlight cells that meet specific criteria? Conditional Formatting Filter Pivot tables Sort 6 / 8 Which Excel function is used to convert a text string into a number? TRIM VALUE TEXT CONCATENATE 7 / 8 Which of the following options is used to create a new email group in Microsoft Outlook? People View Home File 8 / 8 Which of the following options is used to add a contact to your favorites in Microsoft Outlook? Contacts View File Home Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #6 This is is the 6th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 7 Which Excel function is used to calculate the average of a range of cells? COUNT MIN AVERAGE MAX 2 / 7 Which of the following options is used to add a category to an email in Microsoft Outlook? View Tags Home File 3 / 7 Which chart type should be used to show the progress towards a goal? Gauge chart Line chart Bar chart Pie chart 4 / 7 Which keyboard shortcut is used to open the Save As dialog box in Excel? Ctrl + S Ctrl + Shift + S Ctrl + Alt + S Ctrl + F 5 / 7 Which of the following options is used to view your mailbox usage in Microsoft Outlook? File Home View Account Settings 6 / 7 Which chart type should be used to compare values side-by-side? Scatter chart Pie chart Bar chart Line chart 7 / 7 Which of the following options is used to set up a new email account in Microsoft Outlook? File Home View Account Settings Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #5 This is is the 5th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 9 Which of the following options is used to change the default font in Microsoft Outlook? File Home View Options 2 / 9 Which of the following options is used to create a new email signature in Microsoft Outlook? File Options View Home 3 / 9 Which Excel function is used to calculate the interest rate for a loan or investment? RATE PMT PV FV 4 / 9 Which of the following options is used to add a reminder to an email in Microsoft Outlook? View File Home Tags 5 / 9 Which feature in Excel allows you to create custom calculations based on existing data? Sort Chart Wizard Pivot tables Filter 6 / 9 Which Excel function is used to calculate the total number of cells that contain numbers in a range? SUM COUNTIF COUNTA COUNTBLANK 7 / 9 Which of the following options is used to change the color of an email in Microsoft Outlook? Home View File Tags 8 / 9 Which keyboard shortcut is used to select the entire worksheet in Excel? Ctrl + Shift + A Ctrl + A Ctrl + Alt + A Ctrl + W 9 / 9 Which of the following options is used to change the time zone in Microsoft Outlook? File Home View Options Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #4 This is is the 4th part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 10 Which keyboard shortcut is used to switch between the absolute, relative, and mixed reference types in Excel? F6 F2 F4 F8 2 / 10 Which of the following options is used to access the Junk Email folder in Microsoft Outlook? View Folder Home File 3 / 10 Which of the following options is used to mark an email as read in Microsoft Outlook? Tags Home View File 4 / 10 Which of the following options is used to forward an email in Microsoft Outlook? Home File Respond View 5 / 10 Which Excel function is used to concatenate two or more text strings? CONCAT TEXT JOIN MERGE 6 / 10 Which Excel function is used to calculate the standard deviation of a range of cells? AVERAGE VARP SUM STDEV 7 / 10 Which keyboard shortcut is used to open the Go To dialog box in Excel? Ctrl + E Ctrl + F Ctrl + G Ctrl + H 8 / 10 Which chart type should be used to show the proportion of different categories in a data set? Bar chart Pie chart Scatter chart Line chart 9 / 10 Which of the following options is used to print an email in Microsoft Outlook? Print Home File View 10 / 10 Which of the following options is used to reply to an email in Microsoft Outlook? View File Respond Home Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #3 This is is the 3rd part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 10 Which Excel function is used to calculate the present value of a future payment? FV PMT RATE PV 2 / 10 Which chart type should be used to show the trend of data over time? Pie chart Scatter chart Bar chart Line chart 3 / 10 Which keyboard shortcut is used to undo the last action in Excel? Ctrl + C Ctrl + V Ctrl + X trl + Z 4 / 10 Which of the following options is used to create a new folder in Microsoft Outlook? Folder Home View File 5 / 10 Which Excel function is used to round a number to a specified number of decimal places? CEILING FLOOR TRUNC ROUND 6 / 10 Which of the following options is used to delete an email in Microsoft Outlook? View Home File Delete 7 / 10 Which chart type should be used to show the trend of data over time? Scatter chart Bar chart Pie chart Line chart 8 / 10 Which of the following options is used to mark an email as important in Microsoft Outlook? Tags File View Home 9 / 10 Which of the following options is used to move an email to a different folder in Microsoft Outlook? File Move Home View 10 / 10 Which of the following options is used to search for an email in Microsoft Outlook? Home File Search View Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #2 This is is the 2nd part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 9 Which of the following options is used to mark an email as spam in Microsoft Outlook? Junk View File Home 2 / 9 Which keyboard shortcut is used to create a new workbook in Excel? Ctrl + Q Ctrl + O Ctrl + N Ctrl + P 3 / 9 Which of the following options is used to add an attachment to an email in Microsoft Outlook? Home File View Insert 4 / 9 Which of the following options is used to set an out of office message in Microsoft Outlook? Home View Automatic Replies File 5 / 9 Which feature in Excel allows you to group data based on common values? Filter Pivot tables Sort Subtotal 6 / 9 Which of the following options is used to add an attachment to an email in Microsoft Outlook? File Insert Home View 7 / 9 Which of the following options is used to view your calendar in Microsoft Outlook? Home View Calendar File 8 / 9 Which of the following options is used to create a new meeting in Microsoft Outlook? Calendar Home File View 9 / 9 Which Excel function is used to calculate the median of a range of cells? MEDIAN AVERAGE MIN MAX Your score is Share LinkedIn Facebook Twitter VKontakte 0%
Microsoft Excel Quiz #1 This is is the 1st part of the Microsoft Excel Quiz where you will be tested on various basics concepts of Microsoft Excel 1 / 10 Which of the following options is used to mark an email as unread in Microsoft Outlook? Mark as Unread Home People File 2 / 10 Which of the following options is used to send an email in Microsoft Outlook? Send File People Home 3 / 10 Which of the following options is used to reply to an email in Microsoft Outlook? Reply File Home People 4 / 10 Which of the following options is used to create a new email in Microsoft Outlook? People Home File New Email 5 / 10 Which of the following options is used to mark an email as read in Microsoft Outlook? People Home File Mark as Read 6 / 10 Which of the following options is used to delete a contact in Microsoft Outlook? File Home People Delete 7 / 10 Which of the following options is used to flag an email for follow-up in Microsoft Outlook? Flag File Home People 8 / 10 Which of the following options is used to reply to all recipients of an email in Microsoft Outlook? People Reply all File Home 9 / 10 Which of the following options is used to forward an email to another person in Microsoft Outlook? File People Home Forward 10 / 10 Which of the following options is used to create a new contact in Microsoft Outlook? People Contacts Home File Your score is Share LinkedIn Facebook Twitter VKontakte 0%
