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