Microsoft Office Excel 2019 Total Questions - 10 1. What are the shortcut keys for AutoSum? ALT and = CTRL and S ALT and S CTRL and = 2. What type of chart is useful for comparing values over categories? Pie Chart Line Chart Column Chart Dot Graph 3. What is the keyboard shortcut key to lock cell references in a formula? F4 CTRL ALT F2 4. In Excel, which one denoted a range from B1 through E5 B1-E5 B1 to E5 B1:E5 B1$E5 5. What are the keyboard shortcut keys to edit formula in a cell F2 CTRL + 1 CTRL + F F4 6. Which of the following is not a term pertaining to spreadsheets? Browser Cell Character Formula 7. What is the intersection of a column and a row on a worksheet called? Column Address Value Cell 8. Which of the following Excel features allows you to select/highlight all cells that are formulas? Find Go To Special Go To Replace 9. In which tab of the ribbon can you change Workbook Views to Page Break Preview? View Review Page Layout Data 10. What are the basic rectangular building blocks of a spreadsheet? Cells zoom slider Help button All of these ပေးပို့ပါ
