Spring 24 BIM I Final Exam Review

How many actions does the Undo button let you reverse?

• 24

• 50

• 75

• 100

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

• The Undo button on the Quick Access toolbar

• The Cancel button on the Formula bar

• The Enter button on the Formula bar

• The Save button on the Quick Access toolbar

In the formula =SUM(A6:A9), which of the following best describes A6?

• argument

• function

• label

• active cell

On which tab and button are document properties located for editing?

• File tab, Info Button

• View tab, Show button

• Review tab, Changes button

• Home tab, Alignment button

To apply a cell style, you would use the Cell Styles command on the _____ tab.

• Layout

• Insert

• View

• Home

To combine multiple cells into one combined cell, which of the following do you use?

• Column Width command

• Center button

• Merge and Center button

• Increase Indent button

To have Excel enter the lowest price from a range of prices, which of the following would you use?

• MAX function

• COUNT function

• MIN function

• COUNTA function

To print more than one copy of your worksheet, which tab would you go to?

• View

• Page Layout

• Insert

• File

To print your worksheet at its actual size, which of the following would you select?

• Fit to

• No scaling

• Fit sheet to one page

• Scale to fit

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

• Home

• Page Layout

• Insert

• View