Chapter 1

How many actions does the Undo button let you reverse

100

In formulas, calculations in square brackets are calculated first. True or False?

False

When you copy cell contents, the data is removed from its original location and placed on the clipboard. True or False?

False

When you enter a value in a worksheet cell, it is automatically left-aligned. True or False?

False

Which of the following tabs lets you see exactly how your worksheet looks before printing

File

To enter a range of text based on examples that are already in your worksheet, which of the following can you use

Flash Fill

You recieve a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is

Hidden

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do

Open the workbook, make changes, and then save it using a different name.

Where do you rename a workbook and adjust its save location

Save As Dialog box

Which of the following is true when you copy and paste formulas using the fill handle

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

Which of the following is true when you copy and paste formulas using the fill handle?

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

Which of the following is true about deleting a worksheet row

To delete a row, toy can select the row, then use the delete button in the Cells group

To save a workbook for the first time, you use the Save As dialog box

True

To show formulas instead of values, click on the formulas tab in the ribbon, then in the formula auditing group, click on the show formulas option. True or False?

True

You can edit cell contents in the formula bar or in the cell itself. True or False?

True

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop. True or False

True