Question 1

____________________ indicates how characters are emphasized.

Accepted Answer

The answer of ____________________ indicates how characters are emphasized....

Question 2

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 ____.

Accepted Answer

A)  requirements document
B)  USB flash drive
C)  file name
D)  table of keyboard shortcutsE) A) and B)
F) A) and C)

Question 3

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

Accepted Answer

The answer of Like an area chart, a(n) ____________________ chart...

Question 4

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

Accepted Answer

A)  blank
B)  test issues
C)  requirements
D)  certifiedE) None of the above
F) All of the above

Question 5

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Accepted Answer

A)  revised
B)  relative
C)  recycled
D)  retainedE) B) and C)
F) A) and B)

Question 6

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

Accepted Answer

The answer of ____________________ involves reducing the electricity consumed and...

Question 7

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

Accepted Answer

A)  worksheet
B)  workflow
C)  document
D)  presentationE) None of the above
F) B) and C)

Question 8

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+BE) All of the above
F) None of the above

Question 9

You use ____ to view an XPS file.

Accepted Answer

A)  Adobe Reader
B)  Backstage View
C)  Microsoft PowerView
D)  XPS ViewerE) None of the above
F) C) and D)

Question 10

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

Accepted Answer

A)  CTRL+HOME
B)  CTRL+END
C)  HOME
D)  ENDE) B) and D)
F) A) and D)

Question 11

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Accepted Answer

A) True 
 B)False

Question 12

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Accepted Answer

A)  Automatic
B)  Hidden
C)  Replacement
D)  StandardE) A) and C)
F) None of the above

Question 13

How many chart types does Excel offer?

Accepted Answer

A)  5
B)  15
C)  30
D)  50E) A) and B)
F) B) and C)

Question 14

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

Accepted Answer

A)  save
B)  print
C)  format
D)  clearE) All of the above
F) C) and D)

Question 15

The range of cells receiving the content of copied cells is called the ____.

Accepted Answer

A)  receiver cell
B)  final cell
C)  receiving range
D)  destination areaE) B) and D)
F) None of the above

Question 16

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.

Accepted Answer

The answer of The ____________________ button allows you to choose...

Question 17

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 18

Clicking the ____ box completes an entry.

Accepted Answer

A)  Cancel
B)  Formula
C)  Enter
D)  TabE) None of the above
F) A) and B)

Question 19

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Accepted Answer

The answer of ____________________ corrects two initial capital letters by...

Question 20

The first step in creating an effective worksheet is to make sure you ____.

Accepted Answer

A)  apply font formatting
B)  understand what is required
C)  insert a chart
D)  enter the dataE) A) and B)
F) A) and C)

Exam 8: Excel_Module_1

____________________ indicates how characters are emphasized.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You should press the SPACEBAR to clear a cell.

Correct AnswerverifiedShow Answer

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Correct AnswerverifiedShow Answer

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The first step in creating an effective worksheet is to make sure you ____.

Correct AnswerverifiedShow Answer

You use ____ to view an XPS file.

Correct AnswerverifiedShow Answer

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 ____.

Correct AnswerverifiedShow Answer

How many chart types does Excel offer?

Correct AnswerverifiedShow Answer

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Clicking the ____ box completes an entry.

Correct AnswerverifiedShow Answer

The range of cells receiving the content of copied cells is called the ____.

Correct AnswerverifiedShow Answer

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified