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