Question 1

The Accounting number format assigns a floating dollar sign.

Accepted Answer

A) True 
 B)False

Question 2

Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time, total time, and distance.After three months, Anna wants to the know the average distance she runs.What should she do to calculate the average distance?

Accepted Answer

A) Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B) Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C) Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D) Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument. 
A) Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B) Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C) Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D) Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument.

Question 3

The _____ function displays the highest value in a range.

Accepted Answer

A) MIN 
B) SUM 
C) MAX 
D) AVERAGE 
A) MIN 
B) SUM 
C) MAX 
D) AVERAGE

Question 4

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following actions are provided by the Paste Options button?

Accepted Answer

A) Pastes an exact copy of what you copied including contents and formatting 
B) Pastes synonyms or acronyms 
C) Pastes just formulas 
D) Pastes just formatting 
A) Pastes an exact copy of what you copied including contents and formatting 
B) Pastes synonyms or acronyms 
C) Pastes just formulas 
D) Pastes just formatting

Question 6

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.

Accepted Answer

A) True 
 B)False

Question 7

Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 8

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign.

Accepted Answer

A) fixed 
B) formatted 
C) floating 
D) none of the above 
A) fixed 
B) formatted 
C) floating 
D) none of the above

Question 9

A _____ cell in Excel has a numerical value of zero.

Accepted Answer

A) blank 
B) formatted 
C) copied 
D) filled 
A) blank 
B) formatted 
C) copied 
D) filled

Question 10

Excel includes a(n)_________________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n)_________________________ you can use to...

Question 11

To paste copied cell contents, you can press the _____ keys.

Accepted Answer

A) CTRL+C 
B) CTRL+P 
C) CTRL+V 
D) CTRL+X 
A) CTRL+C 
B) CTRL+P 
C) CTRL+V 
D) CTRL+X

Question 12

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is the path to the Sum button?

Accepted Answer

Question 14

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.

Accepted Answer

A) placement 
B) operations 
C) positioning 
D) selections 
A) placement 
B) operations 
C) positioning 
D) selections

Question 15

Which of the following are considered guidelines to use when making decisions about creating a new workbook?

Accepted Answer

A) Determine the necessary formulas and functions needed 
B) Identify how to format various elements of the worksheet 
C) Specify how the hard copy of the worksheet should appear 
D) Enter data into the worksheets and format the cells 
A) Determine the necessary formulas and functions needed 
B) Identify how to format various elements of the worksheet 
C) Specify how the hard copy of the worksheet should appear 
D) Enter data into the worksheets and format the cells

Question 16

Which of the following is the path to the Comma Style button?

Accepted Answer

Question 17

You can select a range using the keyboard by pressing the _____ key and then an ARROW key.

Accepted Answer

A) F2 
B) F4 
C) F6 
D) F8 
A) F2 
B) F4 
C) F6 
D) F8

Question 18

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

Accepted Answer

A) scheme 
B) gallery 
C) theme 
D) style 
A) scheme 
B) gallery 
C) theme 
D) style

Question 19

Which of the following is true of a function?

Accepted Answer

A) Takes a value or values 
B) Performs a calculation 
C) Returns a result to the cell 
D) Contains arguments 
A) Takes a value or values 
B) Performs a calculation 
C) Returns a result to the cell 
D) Contains arguments

Question 20

Always take time to check the _________________________ of a worksheet before submitting it to your supervisor.

Accepted Answer

The answer of Always take time to check the _________________________...

The Accounting number format assigns a floating dollar sign.

The _____ function displays the highest value in a range.

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Which of the following actions are provided by the Paste Options button?

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.

Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign.

A _____ cell in Excel has a numerical value of zero.

Excel includes a(n)_________________________ you can use to check a worksheet for spelling errors.

To paste copied cell contents, you can press the _____ keys.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Which of the following is the path to the Sum button?

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.

Which of the following are considered guidelines to use when making decisions about creating a new workbook?

Which of the following is the path to the Comma Style button?

You can select a range using the keyboard by pressing the _____ key and then an ARROW key.

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

Which of the following is true of a function?

Always take time to check the _________________________ of a worksheet before submitting it to your supervisor.

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Access: Querying a Database

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : What-If Analysis, Charting and Working With Large Worksheets

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 11: Excel : Formulas, Functions, and Formatting

The Accounting number format assigns a floating dollar sign.

The _____ function displays the highest value in a range.

The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user's eye toward the cell or range.

Which of the following actions are provided by the Paste Options button?

Dates that include years both before and after the year 2000 should be formatted with a two-digit year.

Excel has more than 400 additional functions that perform just about every type of calculation you can imagine.

In the accompanying figure, the ranges E4:I4 and F13:I13 are formatted with a _____ dollar sign.

A _____ cell in Excel has a numerical value of zero.

Excel includes a(n)_________________________ you can use to check a worksheet for spelling errors.

To paste copied cell contents, you can press the _____ keys.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Which of the following is the path to the Sum button?

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.

Which of the following are considered guidelines to use when making decisions about creating a new workbook?

Which of the following is the path to the Comma Style button?

You can select a range using the keyboard by pressing the _____ key and then an ARROW key.

A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

Which of the following is true of a function?

Always take time to check the _________________________ of a worksheet before submitting it to your supervisor.

Microsoft Windows Internet Explorer 8 : Introduction to Internet Explorer

Office 2010 and Windows 7 : essential concepts and skills

Access : Databases and Database Objects : an Introduction

Access: Querying a Database

Discovering Computers: Introduction to Computers

Discovering Computers: the Internet and World Wide Web

Discovering Computers: Application Software

Discovering Computers: Operating Systems and Utility Programs

Discovering Computers: Computer Security and Safety, Ethics, and Privacy

Excel : Creating a Worksheet and an Embedded Chart

Excel : What-If Analysis, Charting and Working With Large Worksheets

Powerpoint : Creating and Editing a Presentation With Clip Art

Powerpoint : Enhancing a Presentation With Pictures, Shapes and Wordart

Powerpoint : Reusing a Presentation With Adding Media

Word: Creating, Formatting, and Editing a Word Document With Pictures

Word: Creating a Research Paper With Citations and References

Word: Creating a Business Letter With a Letterhead and Table

Filters