Microsoft Excel Quiz #9 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 of the following options is used to create a new calendar appointment in Microsoft Outlook? File Home Calendar View 2 / 15 Which Excel function is used to find the largest integer less than or equal to a specified number? ROUNDUP CEILING FLOOR ROUNDDOWN 3 / 15 Which feature in Excel allows you to freeze the rows and columns of a worksheet? Pivot tables Freeze Panes Filter Sort 4 / 15 Which chart type should be used to show the relationship between two variables? Bar chart Pie chart Scatter chart Line chart 5 / 15 What is the keyboard shortcut to insert a new column in Excel? Ctrl + Alt + C Ctrl + Shift + C Ctrl + Shift + + Ctrl + C 6 / 15 Which keyboard shortcut is used to open the Insert Function dialog box in Excel? Ctrl + Shift + L Ctrl + Shift + G Ctrl + Shift + F Ctrl + Shift + A 7 / 15 Which of the following options is used to set up an out of office auto-reply in Microsoft Outlook? Home Options File View 8 / 15 Which Excel function is used to calculate the product of a range of cells? COUNT PRODUCT SUM MAX 9 / 15 Which chart type should be used to display proportions or percentages? Pie chart Line chart Scatter chart Bar chart 10 / 15 Which of the following options is used to delete an email in Microsoft Outlook? Send/Receive File Home View 11 / 15 Which of the following options is used to create a new contact in Microsoft Outlook? File Home Send/Receive View 12 / 15 Which of the following options is used to add an attachment to an email in Microsoft Outlook? Insert File Home View 13 / 15 Which Excel function is used to concatenate (join) two or more strings of text? MERGE CONCAT JOIN TEXTJOIN 14 / 15 Which of the following options is used to mark an email as unread in Microsoft Outlook? File Send/Receive Home View 15 / 15 Which of the following options is used to flag an email for follow-up in Microsoft Outlook? Send/Receive Home File View Your score is Share LinkedIn Facebook Twitter VKontakte 0% Share: admin Previous post Microsoft Excel Quiz #8 May 17, 2023 Next post Microsoft Excel Quiz #10 May 17, 2023 You may also like Microsoft Excel Quiz #10 17 May, 2023 Microsoft Excel Quiz #8 17 May, 2023 Microsoft Excel Quiz #7 17 May, 2023
