Exam 13: Creating a Workbook

You can use the commands on the _________ menu in the Cells group on the Home tab to resize columns and rows. A)Wrap Text button B)Format button C)Orientation button D)Margins button ​

Laura has been entering dates in worksheets using the Long Date format. Her manager sends her an email asking her to change all the dates from the Long Date format to the Short Date format. Laura can make the changes by:

In situations where drag and drop can be a difficult and awkward way to move or copy a selection, it is often more efficient to use the Cut or _________. A)Move command B)Copy and Drag commands C)Copy and Paste commands D)Duplicate command

One of the ways to edit data in a cell is by selecting it and pressing the F5 key.

In the following snippet of a Microsoft Excel 2016 worksheet, when the selected cells are inserted into a worksheet, the rest of the cells shift to the right because:

Abdul has been working on a worksheet at a stockbroking firm. Data in this sheet is updated on a daily basis. He adds a new column as the third column of the sheet to accommodate the different aspects of his analysis. Which of the following changes will occur when Abdul adds the new column?

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it. However, before she prints, she wants to  see what data will appear on each page  . In order to do this, she should use the _____.

_________ is commonly recognized formats for date and time values. A)Time data B)Special date C)Date data D)Special time

The sheet currently displayed in the workbook window is called the _________. A)open sheet B)active sheet C)recent sheet D)explore sheet

You can select all the columns and rows in a worksheet by holding the Alt key while double-clicking on a column.

Case 13-2 Megan has created a workbook using Microsoft Excel 2016 and wants to print it. Megan is trying to print the worksheets of her workbook in landscape format. The information on one of the worksheets is too large to print and has to be printed on an A4 sheet. In order to do this, Megan must:

If you make a mistake as you edit, you can press the Esc key to cancel those edits on the formula bar.

To copy rather than move a sheet, press and hold the_____ as you drag and drop the sheet tab.

The Name box displays the contents of the active cell.

Which of the following allows you to cancel the changes you made while editing a cell?

Which of the following should be considered when setting column widths?

Victor is working on a worksheet and realizes that he has entered incorrect information in a column. He selects the entire column and clicks the Delete button in the Cells group on the Home tab. Which of the following happens when Victor clicks the button?

_________ displays the location of page breaks within a worksheet. A)Page Break Layout B)Page Break Preview C)Page Break Insert D)Page Break Margin

Discuss the different number formats that can be used in Microsoft Excel 2016.

When editing content directly in a cell, the Right and Left arrow keys move the _________ backward or forward through the cell's content. A)decimal place B)insertion point C)empty space D)first character