Question 1

Identify the letter of the choice that best matches the phrase or definition.
-A function that displays the highest value in a range.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 2

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing;=G15 is an invalid formula 
A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing;=G15 is an invalid formula

Question 3

To start a new line in a cell,press the ____ keys.

Accepted Answer

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

Question 4

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A)  function 
B)  feature 
C)  task 
D)  calculation 
A)  function 
B)  feature 
C)  task 
D)  calculation

Question 5

With the accounting number style,a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

Accepted Answer

A) True 
 B)False

Question 6

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 7

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error 
A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error

Question 8

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

Accepted Answer

A)  40 
B)  26 
C)  48 
D)  13 
A)  40 
B)  26 
C)  48 
D)  13

Question 9

The Accounting number format assigns a floating dollar sign._________________________

Accepted Answer

A) True 
 B)False

Question 10

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX 
A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX

Question 11

The default view in Excel is called ____ view.

Accepted Answer

A)  Normal 
B)  Standard 
C)  Basic 
D)  Values 
A)  Normal 
B)  Standard 
C)  Basic 
D)  Values

Question 12

In designing a worksheet,visual aesthetics should come first._________________________

Accepted Answer

A) True 
 B)False

Question 13

You can open the Format Cells dialog box by pressing the ____ keys.

Accepted Answer

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

Question 14

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 15

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Accepted Answer

A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above 
A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above

Question 16

Which of the following is the path to the Copy and Paste buttons?

Accepted Answer

Question 17

Which of the following is the path to the Conditional Formatting button?

Accepted Answer

Question 18

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The values version of the worksheet show

Question 19

The equal sign (=)precedes a formula.

Accepted Answer

A) True 
 B)False

Question 20

Identify the letter of the choice that best matches the phrase or definition.
-Opens the Format Cells dialog box.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Identify the letter of the choice that best matches the phrase or definition. -A function that displays the highest value in a range.

Which of the following happens when you enter the formula =G15 into a cell?

To start a new line in a cell,press the ____ keys.

A ____ is a prewritten formula that is built into Excel.

With the accounting number style,a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

The ____ function displays the highest value in a range.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

The Accounting number format assigns a floating dollar sign._________________________

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

The default view in Excel is called ____ view.

In designing a worksheet,visual aesthetics should come first._________________________

You can open the Format Cells dialog box by pressing the ____ keys.

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

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Which of the following is the path to the Copy and Paste buttons?

Which of the following is the path to the Conditional Formatting button?

Briefly discuss displaying the formulas version of a worksheet.

The equal sign (=)precedes a formula.

Identify the letter of the choice that best matches the phrase or definition. -Opens the Format Cells dialog box.

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

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

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

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters

Exam 13: Excel: Formulas, Functions, and Formatting

Identify the letter of the choice that best matches the phrase or definition. -A function that displays the highest value in a range.

Which of the following happens when you enter the formula =G15 into a cell?

To start a new line in a cell,press the ____ keys.

A ____ is a prewritten formula that is built into Excel.

With the accounting number style,a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

The ____ function displays the highest value in a range.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

The Accounting number format assigns a floating dollar sign._________________________

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

The default view in Excel is called ____ view.

In designing a worksheet,visual aesthetics should come first._________________________

You can open the Format Cells dialog box by pressing the ____ keys.

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

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Which of the following is the path to the Copy and Paste buttons?

Which of the following is the path to the Conditional Formatting button?

Briefly discuss displaying the formulas version of a worksheet.

The equal sign (=)precedes a formula.

Identify the letter of the choice that best matches the phrase or definition. -Opens the Format Cells dialog box.

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

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Creating a Worksheet and a Chart

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

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters