Excel Exam 1 Multiple Choice | Quizizz PDF

## Quizizz Worksheets: Excel Exam 1 **Total questions:** 30 **Worksheet time:** 19 minutes **Instructor name:** Mr. Sandeep Chawla **Name:** __________ **Class:** __________ **Date:** __________ --- **1. Which tab is used to show print command?** a) home b) file c) view d) page layout **2....

## Quizizz Worksheets: Excel Exam 1 **Total questions:** 30 **Worksheet time:** 19 minutes **Instructor name:** Mr. Sandeep Chawla **Name:** __________ **Class:** __________ **Date:** __________ --- **1. Which tab is used to show print command?** a) home b) file c) view d) page layout **2. In cell address F25, “25” is identified as:** a) column b) cell c) range d) row **3. Which of the following is the intersection of a row and column?** a) tab b) cell c) range d) bar chart **4. Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently?** a) The Quick Access Toolbar b) A worksheet c) The Help window d) The ribbon **5. A feature of Microsoft office 2016 from which you access file and program management commands:** a) cell address b) backstage view c) formula bar d) active cell **6. David wants to key the numbers 1-1000 in column A of the spreadsheet. What command should he use to complete this task?** a) AutoFill b) sort c) filter d) find and replace **7. Which command on the Fill option dialog box is the default option if a month or day is entered?** a) fill without formatting b) fill series c) copy cells d) fill formatting only **8. How do you change the width of a column so that the widest entry will fit?** a) AutoFit b) TrueFit c) SmartFit d) BestFit **9. Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?** a) Set b) Segment c) Cluster d) Range **10. Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?** a) Column marker b) Fill handle c) Cell pointer d) Formula bar **11. True or False: Using the Delete key removes both text and formats from a cell.** a) True b) False **12. Which of the following is where you can save, select a template, change document properties, and close or exit Excel?** *The image shows options like Info, Protect Workbook, Inspect Workbook, Manage Workbook.* a) Print b) Backstage c) Edit d) Windows **13. To change printer, layout, or margin settings, you click the File tab and use which of the following options?** *The image shows file menu options like Info, New, Open, Save, Save As, Print, Share, Export, Publish, and Close.* a) Print b) Open c) Options d) Info **14. Which of the following options can be used to fit the worksheet to one page?** *The image shows Print Setup menu options like Collated, Landscape Orientation, Letter 8.5" x 11", Custom Margins and No Scaling* a) Margins b) Scaling c) Collated d) Orientation **15. Which predesigned file already has a significant amount of formatting, text, and other features?** *The image contains an Excel interface displaying options for creating new documents with various templates.* a) Template b) Text file c) Preset file d) Blank workbook **16. If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.** *The picture shows a spreadsheet called Contoso Potluck Form.* a) FALSE b) TRUE **17. Portrait orientation is the default orientation and it prints the page taller than it is wide.** *The picture shows options for Portrait Orientation and Landscape orientiation.* a) TRUE b) FALSE **18. The line between rows or columns.** a) boundary b) page break c) footer d) column width **19. A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.** a) orientation b) document theme c) gridlines d) effects **20. Lines of text that appear at the bottom of each page.** a) footer b) column heading c) column width d) header **21. The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.** a) effects b) orientation c) document theme d) boundary **22. Cells that run from top to bottom in a worksheet and are identified by letters** a) active cell b) name box c) column d) row **23. A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface.** a) quick access toolbar b) ribbon c) command group d) row **24. Which of the following procedures is not a way to delete one or more worksheets from a workbook?** a) Select a group of worksheets, right-click the group, and click Delete. b) Press Ctrl+A to select all cells in the worksheet and then press Delete. c) Click the down arrow next to Delete on the Home tab and click Delete Sheet. d) Right-click a worksheet tab and click Delete. **25. Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?** a) It helps Excel learn where your data ranges are located. b) It lets you reuse formats and formulas in a new sheet. c) It's the easiest way to make a backup before making changes. d) You should keep one worksheet hidden in case of an error. **26. Which of the following will return your worksheet to 100% with one click?** *The image shows part of zoom control A that is < 100% and zoom button B, C, D > a) B b) C c) A d) D **27. Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?** a) Select the visible area of the worksheet. b) Enter the name of the worksheet in the Hide dialog box. c) Right-click the worksheet's tab and click Hide. d) On the View tab, in the Window group, click Hide. **28. Which cell would you click to freeze Rows 1-5 and Column A?** *The image shows an excel sheet.* a) B6 b) B5 c) A6 d) A5 **29. When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?** a) August (2) b) Sheet2 c) July d) September **30. Which of the following procedures is not a way to sort a table by the contents of one column?** a) Click an AutoFilter button in the total row. b) Click the Filter button in the Sort & Filter group of the Data tab. c) Click an AutoFilter button in the field names row. d) Click the Sort button in the Sort & Filter group of the Data tab.