Excel Basics and Commands

• Excel Exam 1 consists of 30 multiple-choice questions and is estimated to take 19 minutes to complete.

Excel Basics and Commands

• The "File" tab is used to access the print command.
• In a cell address like "F25", the "25" refers to the row number.
• A cell is the intersection of a row and a column in a worksheet.
• The Quick Access Toolbar contains Save, Undo, and Redo commands.
• Backstage view is where file and program management commands are accessed in Microsoft Office 2016.
• The AutoFill command automatically populates a series of numbers like 1-1000 in a column.
• In the Fill Options dialog box, "Fill Series" is the default option when a month or day is entered.
• The AutoFit feature automatically adjusts the column width to fit the widest entry.
• A range refers to a group of selected cells that can be formatted, moved, copied, or deleted.
• The fill handle, a small green square at the lower-right corner of a selected cell, copies cell contents or creates a series.
• Using the Delete key only removes text from a cell, not the formatting.
• The "Backstage" area is where users can save files, select a template, change document properties, and close or exit Excel
• Users access the info section of the File tab to change printer, layout, or margin settings.
• To fit a worksheet to one page, use the Scaling option.
• A template is a predesigned file with existing formatting, text, and features.
• If there are too many columns to fit on a printed page, decreasing the column width will help.
• Portrait orientation is the default page orientation and prints the page taller than it is wide.
• A boundary is the line between rows or columns.
• A document theme is a predefined set of colors, fonts, and effects that can be applied to a workbook
• Footers are lines of text appearing at the bottom of each page.
• Orientation is the position of the content in a worksheet, so it prints either vertically or horizontally on a page.
• A column refers to cells that run from top to bottom in a worksheet and which are identified by letters.
• A ribbon is a broad band at the top of the Excel window that organizes commands and tools.
• The process of pressing Ctrl+A to select all cells and then pressing Delete is not a way to delete one or more worksheets.
• It lets you reuse formats and formulas in a new sheet is a reason to copy a worksheet within a workbook.
• Clicking the A returns your worksheet to 100% with one click.
• Right-clicking the worksheet's tab and clicking Hide is a method for hiding a single worksheet in a multi-sheet workbook.
• To freeze Rows 1-5 and Column A, click cell B6.
• When copying a worksheet named "August", Excel names the copy "August (2)".
• Clicking the Filter button in the Sort & Filter group of the Data tab is not a way to sort a table by the contents of one column.