Microsoft Excel Quiz #4 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 Excel function is used to calculate the standard deviation of a range of cells? SUM STDEV AVERAGE VARP 2 / 10 Which chart type should be used to show the proportion of different categories in a data set? Scatter chart Pie chart Bar chart Line chart 3 / 10 Which keyboard shortcut is used to switch between the absolute, relative, and mixed reference types in Excel? F4 F2 F6 F8 4 / 10 Which Excel function is used to concatenate two or more text strings? JOIN CONCAT TEXT MERGE 5 / 10 Which of the following options is used to access the Junk Email folder in Microsoft Outlook? View Home File Folder 6 / 10 Which of the following options is used to print an email in Microsoft Outlook? Print View Home File 7 / 10 Which of the following options is used to forward an email in Microsoft Outlook? Home Respond View File 8 / 10 Which keyboard shortcut is used to open the Go To dialog box in Excel? Ctrl + H Ctrl + E Ctrl + G Ctrl + F 9 / 10 Which of the following options is used to mark an email as read in Microsoft Outlook? View Tags File Home 10 / 10 Which of the following options is used to reply to an email in Microsoft Outlook? File Respond Home View Your score is Share LinkedIn Facebook Twitter VKontakte 0% Share: admin Previous post Microsoft Excel Quiz #3 May 17, 2023 Next post Microsoft Excel Quiz #5 May 17, 2023 You may also like Microsoft Excel Quiz #10 17 May, 2023 Microsoft Excel Quiz #9 17 May, 2023 Microsoft Excel Quiz #8 17 May, 2023