Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A)  ALT+B
B)  CTRL+B
C)  SHIFT+B
D)  TAB+B B

Question 3

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

Accepted Answer

line

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  press F4
B)  press ALT+F4
C)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu
D)  right-click the Excel app button on the taskbar and then click 'Close all windows' on the shortcut menu

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A thin red border indicates the active cell.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  CTRL+HOME
B)  CTRL+END
C)  HOME
D)  END

Question 9

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

Accepted Answer

A)  quotation mark (") 
B)  colon (:) 
C)  plus (+) 
D)  equal sign (=)

Question 10

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

Accepted Answer

A)  XPS
B)  TIF
C)  BMP
D)  PDF

Question 11

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

Accepted Answer

The answer of Excel's ____________________ function,which adds all of the...

Question 12

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.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 13

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

Accepted Answer

The answer of The default font for a new workbook...

Question 14

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.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 15

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

Accepted Answer

A)  worksheet
B)  workflow
C)  document
D)  presentation

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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.

Accepted Answer

A)  AutoFormat
B)  AutoComplete
C)  AutoFunction
D)  AutoCalculate

Question 19

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

Accepted Answer

A)  blank
B)  test issues
C)  requirements
D)  certified

Question 20

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.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

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.