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