IBA: EXCEL FUNCTIONS (unit 6)
A
Columns are ___________ and identified by __________. Vertical, Letters Horizontal, Numbers Top Down, Vowels Bottom Up, Numbers
D
Every workbook has at least ______ worksheet. 4 3 2 1
D
How can you give a range a certain name? Insert Tab, Table Formula Tab, AutoSum Insert Tab, Column Formula Tab, Define
C
If you are finished using the shortcut keyboard options, which button should you click to back out? Page Up Backspace Escape Shift
A
If you wanted to look at some of the different printing options, which tab would you use? Page Layout Home Review Data
B
In Excel, how would you access the backstage view? Insert Tab File Tab Formula Tab Help Tab
B
Rows are _______ and identified by ___________. Vertical, Letters Horizontal, Numbers Top Down, Vowels Bottom Up, Numbers
True
T/F: Almost all buttons of your choice can be added to the QAT.
False
T/F: If you choose to remove a tab when customizing your ribbon, you can never put that tab back in place.
False
T/F: Once you've added all of your choice buttons to the quick access toolbar, you can't reset it back to its default settings.
True
T/F: Range names cannot contain spaces.
True
T/F: When you right-click your mouse, you will almost always have access to a shortcut menu.
A
The status bar is located where in your Excel workbook? Bottom Right Left Top
B
What actions do you need to take to customize the status bar? Left-click and select what you would like to add. Right-click and select what you would like to add. Double-click status tab. Click status tab once.
C
What do dialog box launchers allow us to see? A. Nothing B. Data of the box. C. All features of that particular section D. Page layout features
A
What key is necessary for you to click on your keyboard to access shortcuts? Alt Caps Lock Tab Shift
A
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. Let your mouse rest on the button of choice and left click. Double-click the button of your choice. Single-click the button of your choice.
D
When you rest your mouse on a button, a dialogue box pops up explaining what it is used for. What is the proper name for this dialogue box? Pop-up box Pop-up bubble Pop-up help Pop-up tip
B
Which of the following should you select in order to customize your ribbon after you have right-clicked on a tab? Customize the Tab Customize the Ribbon Customize Formulas Customize Design