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

Q: The ________ shortcut to add a new worksheet can be found at the bottom of the active workbook.
- “Insert” Menu> “Sheet”
- “Insert” tab
- “+”
A: “+”

Q: The ________ option can be used to add a new worksheet from the “Cells” group.
- “Blank worksheet”
- “Add worksheet”
- “Insert”
A: “Insert”

Q: The ________ button will also sort data from smallest to largest.
- “Sort Z to A”
- “Custom Sort”
- “Sort A to Z”
A: “Sort A to Z”

Q: If you wish to sort a column based on clothing size, use the ________ option.
- “Sort Manual”
- “Sort A to Z”
- “Custom Sort”
A: “Custom Sort”

Q: The ________ button lets a user hide some data but does not actually delete it from the worksheet.
- “Hide”
- “Custom Sort”
- “Filter”
A: “Filter”

Q: The ________ tab contains the “Filter” menu for quickly hiding some data.
- “Home”
- “View”
- “Data”
A: “Data”

Q: The ________ function can be used to automatically count how often a particular word appears in a column of information.
- “IF”
- “Filter”
- “COUNTIF”
A: “COUNTIF”

Q: The ________ function could be used to populate a column with a ‘yes’ or ‘no’ flag based on whether something specific has already happened.
- “Filter”
- “COUNTIF”
- “IF”
A: “IF”

Q: The ________ tab contains the buttons for creating a chart in Excel.
- “Data”
- “Layout”
- “Insert”
A: “Insert”

Q: If you wish to visualize data so that the information is represented as vertical bars, create a ________.
- Sales Total pie graph
- Line chart
- Clustered Column Chart
A: Clustered Column Chart

Q: ________ can be used to change the way a chart looks, such as bar versus lines.
- “Edit”
- “Recommended Charts”
- “Change Chart Type”
A: “Change Chart Type”

Q: ________ can be used to change what data is on which axis of a chart.
- “Change Chart Type”
- “Edit”
- “Switch Row/Column”
A: “Switch Row/Column”

Q: The ________ tab contains the buttons for creating a sparkline in Excel.
- “Data”
- “Layout”
- “Insert”
A: “Insert”

Q: ________ can be used to change the way a sparkline looks, such as lines instead of columns or color options.
- “Change Chart Type”
- “Format Sparkline”
- “Sparkline Tools”
A: “Sparkline Tools”

Q: The ________ allows you to automatically apply a color or highlight to cells that meet a specific value.
- “COUNTIF”
- “Filter”
- “Conditional Formatting”
A: “Conditional Formatting”

Q: Use the ________ option to set conditional formatting to highlight cells that contain a specific word.
- “equal to”
- “New Rule”
- “text that contains”
A: “text that contains”

Q: The ________ allows you to automatically switch the printed direction of your worksheet.
- “Margins”
- “Size”
- “Orientation”
A: “Orientation”

Q: Use the ________ option to change how closely the worksheet is printed to the edge of the paper.
- “Size”
- “Orientation”
- “Margins”
A: “Margins”