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