Question 1

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Accepted Answer

A)  contiguous 
B)  indexed 
C)  direct 
D)  indirect 
A)  contiguous 
B)  indexed 
C)  direct 
D)  indirect

Question 2

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 3

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

Accepted Answer

A)  8.43 
B)  7.52 
C)  11.65 
D)  9.43 
A)  8.43 
B)  7.52 
C)  11.65 
D)  9.43

Question 4

The equal sign (=)precedes a formula.

Accepted Answer

A) True 
 B)False

Question 5

A ____ is text and graphics that print at the bottom of every page.

Accepted Answer

A)  footer 
B)  toe 
C)  margin 
D)  stopper 
A)  footer 
B)  toe 
C)  margin 
D)  stopper

Question 6

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

Question 7

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Accepted Answer

A)  Function 
B)  Formula 
C)  Equal 
D)  Calculate 
A)  Function 
B)  Formula 
C)  Equal 
D)  Calculate

Question 8

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 9

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 10

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 11

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 12

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

Which of the following Option buttons gives options for filling cells following a fill operation?

Accepted Answer

A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Insert Options 
D)  Paste Options 
A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Insert Options 
D)  Paste Options

Question 17

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Accepted Answer

A) True 
 B)False

Question 18

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

Accepted Answer

A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste 
A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste

Question 19

The Percent Style button instructs Excel to display a value as a percentage,determined by multiplying the cell entry by 100,rounding the result to the nearest percent,and adding a percent sign.

Accepted Answer

A) True 
 B)False

Question 20

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

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

The equal sign (=)precedes a formula.

A ____ is text and graphics that print at the bottom of every page.

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

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

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

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

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.

Clicking the Create Function box opens the Function Arguments dialog box.

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 happens when you enter the formula =G15 into a cell?

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

Which of the following Option buttons gives options for filling cells following a fill operation?

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

The Percent Style button instructs Excel to display a value as a percentage,determined by multiplying the cell entry by 100,rounding the result to the nearest percent,and adding a percent sign.

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

Creating a Worksheet and a Chart

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 2: Formulas, Functions, and Formatting

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

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

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

The equal sign (=)precedes a formula.

A ____ is text and graphics that print at the bottom of every page.

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

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

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

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

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.

Clicking the Create Function box opens the Function Arguments dialog box.

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 happens when you enter the formula =G15 into a cell?

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

Which of the following Option buttons gives options for filling cells following a fill operation?

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

The Percent Style button instructs Excel to display a value as a percentage,determined by multiplying the cell entry by 100,rounding the result to the nearest percent,and adding a percent sign.

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

Creating a Worksheet and a Chart

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

Financial Functions, Data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters