Microsoft Office Advanced Excel Total Questions - 10 1. Which of the following functions is used to count the number of cells in a range that contain a specific value? COUNTIF SUMIF AVERAGEIF MAXIF 2. Which of the following functions is used to calculate the variance of a range of cells in Excel? VARIANCE VAR STDEV AVERAGE 3. What is the shortcut key to switch between worksheets in Excel? Ctrl+Tab Ctrl+Page Up Ctrl+Page Down Alt+Tab 4. Which of the following chart types is used to show the proportion of each value to the total? Line chart Bar chart Scatter chart Pie chart 5. What is the shortcut key to create a new worksheet in Excel? Ctrl+Shift+N Ctrl+N Ctrl+W Ctrl+Alt+N 6. Which of the following functions is used to calculate the standard deviation of a range of cells in Excel? VARIANCE VAR STDEV AVERAGE 7. What is the shortcut key to insert a new row in Excel? Ctrl+R Ctrl+I Ctrl+Shift+R Ctrl+Alt+R 8. Which of the following functions is used to count the number of cells in a range that are not empty? COUNT COUNTA COUNTBLANK COUNTIF 9. Which of the following functions is used to concatenate two or more strings in Excel? CONCATENATE CONCAT TEXTJOIN JOIN 10. What is the shortcut key to display the “Format Cells” dialog box in Excel? Ctrl+1 Ctrl+2 Ctrl+3 Ctrl+4 Submit
