Exam 7: Excel: Creating a Worksheet and a Chart

A given range contains the data that determines the size of slices in a corresponding pie chart;these entries are called the category names.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Like an area chart,a(n)____________________ chart often is used to illustrate changes in data over time.

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

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

A thin red border indicates the active cell.

Pressing the ____ keyboard shortcut key(s)selects cell A1.

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Selects cell A1.

The default font for a new workbook is ____________________ 11-point regular black.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Should not be used to clear a cell.

An Excel ____ allows data to be summarized and charted easily.

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

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

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

The person or persons requesting the worksheet should supply their requirements in a ____ document.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Toggles between Insert and Overtype mode.