IBA Unit 6
Every workbook has at least ______ worksheet(s).
1
How many different printing options do you have?
3
What is Excel?
A spreadsheet program
If you want to adjust the Page Break area, what do you need to do?
Adjust the dashed blue line
What do dialog box launchers allow us to see?
All features of that particular section
What key is necessary for you to click on your keyboard to access shortcuts?
Alt
Which button should you click, to clear the content of an active cell?
Backspace
The status bar is located where in your Excel workbook?
Bottom
This refers to the rectangle boxes in an Excel workbook which is at the intersection of a row and a column.
Cell
What is the intersection of a column and a row in a table or worksheet called?
Cell
A vertical stack of cells in a table or worksheet.
Column
This refers to a group of cells that runs from the top of the page to the bottom.
Column
The column letter.
Column heading
Which of the following should you select in order to customize your ribbon after you have right-clicked on a tab?
Customize the ribbon
The page break between the information is indicated by what?
Dashed blue line
Which is NOT one of the worksheet view options in Excel?
Data
This area contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.
Excel ribbon menu
If you choose to remove a tab when customizing your ribbon, you can never put that tab back in place.
False
Once you've added all of your choice buttons to the quick access toolbar, you can't reset it back to its default settings.
False
Select "Print Selected Chart" to print the entire workbook.
False
Spaces are allowed in named ranges.
False
In Excel, how would you access the backstage view?
File tab
An equation that calculates a new value from values currently in a worksheet.
Formula
In this box, you can enter or edit data, a formula, or a function.
Formula bar
Rows are _______ and identified by ___________.
Horizontal, Numbers
What orientation would allow more information to be displayed on the page?
Landscape
What steps do you need to follow in order to add a button to the QAT?
Let your mouse rest on the button of choice and right click.
This area displays the location of a selected cell.
Name box
If you ever need to change a named range, go to the formulas tab and click ___.
Name manager
If you would like to clear the print area, what tab do you need to first enter into?
Page layout
The cells and ranges designated for printing.
Print Area
If you only wanted to print a certain area of your spreadsheet which option should you choose?
Print Selection
This feature lets you access common commands no matter which tab is selected.
Quick access toolbar
What actions do you need to take to customize the status bar?
Right-click and select what you would like to add.
The horizontal placement of cells in a table or worksheet.
Row
This refers to a group of cells that runs from the left of the page to the right.
Row
The row number.
Row heading
Adds together long columns or rows of numbers.
Sum button
A mini toolbar will allow the display of formatting options.
True
Almost all buttons of your choice can be added to the QAT.
True
The mini toolbar can be turned off.
True
You can adjust both the page layout as well as margins from the Page Setup Menu.
True
You can print both the data and the chart together.
True
You can tell how many pages there are because they are clearly marked behind your information.
True
The file used to store worksheets.
Workbook
A computerized spreadsheet.
Worksheet
This area controls the different ways that the Excel worksheets are displayed.
Worksheet view options
These are the files that are in the Excel workbooks. They also make up the different pages in Excel.
Worksheets
This feature allows you to drag a slider to control the size of the worksheet in Excel.
Zoom control
Columns are ___________ and identified by __________.
vertical, letters