Title: Microsoft Excel, Pt. 1
Course: Question Banks

Q: To open a new workbook in Excel, you should use the ________ command.
- File>Open
- Insert>New Page
- File>New
A: File>New

Q: ________ is the keyboard shortcut to create a new workbook in Excel.
- Alt-N
- Windows-N
- Ctrl-N
A: Ctrl-N

Q: When entering data into a column, you should use the ________ button to proceed to the next cell.
- shift
- tab
- enter
A: enter

Q: If you wish to organize data in an Excel worksheet in a row, you can use the ________ button to proceed to the next cell in the row.
- shift
- enter
- tab
A: tab

Q: If you wish to quickly apply a color scheme to an entire set of rows and columns in Excel, you should apply a ________ style.
- comma
- cell
- table
A: table

Q: In order to format a series of rows and columns as a table, you should use the “Format as a Table” button in the ________ group of the ribbon.
- Table
- Cells
- Styles
A: Styles

Q: When you wish to quickly indicate that certain cells in a table are different, you should apply a ________ style.
- table
- comma
- cell
A: cell

Q: In order to quickly indicate some cells are “good”, you should use the Cell Styles button in the ________ group of the ribbon.
- Table
- Cells
- Styles
A: Styles

Q: The ________ group of the ribbon has a simple dropdown for changing the format of cells.
- Styles
- Comma
- Numbers
A: Numbers

Q: The ________ group of the ribbon has a simple dropdown for changing the format of cells.
- Styles
- Comma
- Cells
A: Cells

Q: If you use the comma button in the “Numbers” group of the ribbon, you can quickly apply the ________ comma style.
- Currency
- Comma [0]
- 1000 Separator
A: 1000 Separator

Q: Comma styles can be applied using a dropdown menu under “Format” in the ________ group of the ribbon.
- Number
- General
- Cells
A: Cells

Q: The ________ button in the “Cell” group of the ribbon has a simple dropdown for removing a row of data from a worksheet.
- Format
- Insert
- Delete
A: Delete

Q: The ________ button in the “Cells” group of the ribbon has a simple dropdown for adding a blank row into an existing table in a worksheet.
- Format
- Delete
- Insert
A: Insert

Q: If you use the “Format” button in the “Cells” group of the ribbon, you can quickly ________.
- insert rows in a table
- delete columns in a table
- resize all the columns of a table
A: resize all the columns of a table

Q: The “Row Height” option in the “Format Cells” menu will allow you ________.
- autofit the height of a row to the text in the cells
- apply the default height to Excel rows
- specify a standard pixel height for multiple rows at once
A: specify a standard pixel height for multiple rows at once

Q: The ________ option can quickly and automatically help you combine data from different columns into a single column with the same formatting.
- AutoSum
- Sort
- Flash Fill
A: Flash Fill

Q: ‘Ctrl-E’ is the keyboard shortcut for ________.
- Enter
- Exit
- Flash Fill
A: Flash Fill

Q: The ________ option can quickly add up all the numbers in a column or row.
- Sort
- Flash Fill
- AutoSum
A: AutoSum

Q: The ________ group of the ribbon contains the AutoSum button.
- Styles
- Formulas
- Editing
A: Editing