Exam 8: Excel_Module_1

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

Which of the following keys toggles between Insert mode and Overtype mode?

Which of the following is the Ribbon path to the Cell Styles button?

Live preview is available on a touch screen.

____________________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

Case 1-2 Anita is new to Microsoft Excel 2016. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. -Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

A single point is about 1/32 of one inch in height.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

In a worksheet, columns typically contain information that is similar to a list. _________________________

The opposite of merging cells is splitting a merged cell. _________________________

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

How many chart types does Excel offer?

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.