Advanced Excel Total Questions - 10 1. 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 2. Which of the following functions is used to count the number of cells in a range that are not empty? COUNT COUNTA COUNTBLANK COUNTIF 3. What is the shortcut key to create a new worksheet in Excel? Ctrl+Shift+N Ctrl+N Ctrl+W Ctrl+Alt+N 4. What is the shortcut key to display the “Format Cells” dialog box in Excel? Ctrl+1 Ctrl+2 Ctrl+3 Ctrl+4 5. Which of the following functions is used to concatenate two or more strings in Excel? CONCATENATE CONCAT TEXTJOIN JOIN 6. What is the shortcut key to insert a new row in Excel? Ctrl+R Ctrl+I Ctrl+Shift+R Ctrl+Alt+R 7. 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 8. Which of the following functions is used to calculate the standard deviation of a range of cells in Excel? VARIANCE VAR STDEV AVERAGE 9. Which of the following functions is used to calculate the variance of a range of cells in Excel? VARIANCE VAR STDEV AVERAGE 10. What is the shortcut key to switch between worksheets in Excel? Ctrl+Tab Ctrl+Page Up Ctrl+Page Down Alt+Tab Submit
