FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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

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.

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

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.

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

A thin red border indicates the active cell.

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.

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

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.

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

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.

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.

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

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