Microsoft Excel Quiz #10 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 Which Excel function is used to find the smallest value in a range of cells? MAX COUNT MIN AVERAGE 2 / 17 Which keyboard shortcut is used to open the Format Cells dialog box in Excel? Ctrl + 4 Ctrl + 3 Ctrl + 2 Ctrl + 1 3 / 17 Which function is used to find the highest value in a range of cells? MAX MIN AVERAGE COUNT 4 / 17 What is the shortcut key to insert a new row in Excel? Ctrl + Shift + R Ctrl + R Ctrl + Shift + + Ctrl + Alt + R 5 / 17 Which chart type is best for comparing values across categories? Scatter chart Bar chart Pie chart Line chart 6 / 17 Which function is used to calculate the sum of a range of cells in Excel? AVERAGE COUNT MAX SUM 7 / 17 What is the keyboard shortcut to save an Excel workbook? Ctrl + O Ctrl + P Ctrl + S Ctrl + N 8 / 17 Which Excel function is used to find the total number of cells in a range that contain numbers? COUNT SUM MAX AVERAGE 9 / 17 What is the keyboard shortcut to undo the last action in Excel? Ctrl + Z Ctrl + X Ctrl + C Ctrl + V 10 / 17 Which function is used to calculate the sum of a range of cells in Excel? COUNT MAX SUM AVERAGE 11 / 17 Which feature in Excel allows you to apply a formula to multiple cells at once? Fill Series Copy and P Autofill Format Painter 12 / 17 Which feature in Excel allows you to group and summarize data? Filter Freeze Panes Sort Pivot tables 13 / 17 Which of the following options is used to create a new email in Microsoft Outlook? File Send/Receive View Home 14 / 17 Which Excel function is used to round a number to a specified number of decimal places? FLOOR CEILING ROUND TRUNC 15 / 17 Which of the following options is used to set up a signature for your emails in Microsoft Outlook? Home View Options File 16 / 17 Which function is used to calculate the average of a range of cells in Excel? AVERAGE MAX COUNT SUM 17 / 17 Which chart type should be used to display data that changes over time? Bar chart Pie chart Scatter chart Line chart Your score is Share LinkedIn Facebook Twitter VKontakte 0% Share: admin Previous post Microsoft Excel Quiz #9 May 17, 2023 You may also like Microsoft Excel Quiz #9 17 May, 2023 Microsoft Excel Quiz #8 17 May, 2023 Microsoft Excel Quiz #7 17 May, 2023