Question 1

The ____ function determines the lowest number in a range.

Accepted Answer

A)  LOW 
B)  BASE 
C)  LEAST 
D)  MIN 
A)  LOW 
B)  BASE 
C)  LEAST 
D)  MIN

Question 2

The arithmetic operator,^,directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Accepted Answer

The answer of The ____________________ is a small black square...

Question 4

The most common error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

A) True 
 B)False

Question 5

A ____ is text and graphics that print at the top of each page.

Accepted Answer

A)  header 
B)  topper 
C)  margin 
D)  crown 
A)  header 
B)  topper 
C)  margin 
D)  crown

Question 6

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

Accepted Answer

A) True 
 B)False

Question 7

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 8

The ____ button assigns a fixed dollar sign to the numbers in a selected range,with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accepted Answer

A)  Comma style format 
B)  Accounting number format 
C)  Percent style format 
D)  Currency style format 
A)  Comma style format 
B)  Accounting number format 
C)  Percent style format 
D)  Currency style format

Question 9

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A)  ^ 
B)  * 
C)  % 
D)  > 
A)  ^ 
B)  * 
C)  % 
D)  >

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Pastes a formula.

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 11

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 12

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Accepted Answer

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

The ____ function determines the lowest number in a range.

The arithmetic operator,^,directs Excel to perform the division operation.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The most common error when entering a formula is to reference the wrong cell in the formula.

A ____ is text and graphics that print at the top of each page.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The ____ button assigns a fixed dollar sign to the numbers in a selected range,with the dollar sign to the far left with spaces between it and the first digit in the cell.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

The range automatically selected by Excel is always correct.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

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

The ____ function determines the lowest number in a range.

The arithmetic operator,^,directs Excel to perform the division operation.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The most common error when entering a formula is to reference the wrong cell in the formula.

A ____ is text and graphics that print at the top of each page.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The ____ button assigns a fixed dollar sign to the numbers in a selected range,with the dollar sign to the far left with spaces between it and the first digit in the cell.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Identify the letter of the choice that best matches the phrase or definition. -Pastes a formula.

The range automatically selected by Excel is always correct.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

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