Exam 9: Excel: Creating a Worksheet and a Chart

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

If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

Critical Thinking Questions Case 1-1 Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry decides that before either of his employees creates a new workbook he must give them a ____.

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

The date you change a file is an example of a(n) ____ property.

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

List and briefly describe six chart types from which you can choose in Excel.Mention how you select the appropriate type of chart.

Modified Multiple Choice You can insert a function in a cell by ____.

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area.

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

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

By default, text is ____ in a cell.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Excel can display characters in only three font colors: black, red, and blue.

You use ____ to view an XPS file.

Modified Multiple Choice ____ is an electronic image format, sometimes called a fixed format.

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

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.