Chapter 2

You click the Save icon at the top of an Excel workbook. The image below shows what appears on your screen. Why do you see this screen?

This is a new file that has not previously been saved.

Which action CANNOT be reversed using the Undo command?

deleting a tab in the workbook

In the image below, what is most likely the reason the work order and status columns are left-aligned while the cost column is right-aligned?

By default, cells with alpha characters are left-aligned and while numeric characters are right-aligned.

As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will Excel take with this?

Excel will display it as 6/31/2019, but it will be left-justified and just a set of numbers and dashes, not an actual date.

You are entering Sales data for each month in 2018. How can you quickly enter all 12 months in columns?

Type in "January," point to the lower right-hand corner of the cell, hold down the left mouse button, and drag across the next 11 rows.

You are adding dates in the spreadsheet shown below. What will happen when you press Enter after entering the date as shown in cell C9?

The date will appear as 8/1/2020 and will be right-aligned.

You are working in the most recent version of Excel provided by your company. Why would you use the Save as type pull-down menu?

You are saving the file for someone with an older version of Excel.