Question 1

You can replace a formula with its function so it remains constant.​__________

Accepted Answer

A) True 
 B)False

Question 2

____________________ are values in cells that can be changed to determine new values for formulas.

Accepted Answer

The answer of ____________________ are values in cells that can...

Question 3

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

Accepted Answer

Question 4

Panes created using the vertical split bar scroll together horizontally.________________________

Accepted Answer

A) True 
 B)False

Question 5

Which comparison operator means "not equal to"?

Accepted Answer

A)   
C)   
A)   
C)

Question 6

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Accepted Answer

The answer of ____________________ is the default option that Excel...

Question 7

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Accepted Answer

A)  Copy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above 
A)  Copy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above

Question 8

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

Accepted Answer

A)  15 
B)  90 
C)  145 
D)  180 
A)  15 
B)  90 
C)  145 
D)  180

Question 9

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

Accepted Answer

The answer of You know Excel is in Copy mode...

Question 10

You should use a ____ chart to compare values side by side,broken down by category.

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column 
A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column

Question 11

Using the mouse to move or copy cells is called ____.

Accepted Answer

A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste 
A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste

Question 12

Charts can either be embedded in a worksheet or placed in a separate ____.

Accepted Answer

A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range 
A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range

Question 13

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

Accepted Answer

A) True 
 B)False

Question 14

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

Accepted Answer

A)  Wednesday 
B)  Thursday 
C)  Saturday 
D)  Monday 
A)  Wednesday 
B)  Thursday 
C)  Saturday 
D)  Monday

Question 15

To open the Format Cells dialog box with the Alignment sheet active,click the Alignment Settings _____.​

Accepted Answer

A)  ​button 
B)  ​check box 
C)  ​option button 
D)  ​Dialog Box Launcher 
A)  ​button 
B)  ​check box 
C)  ​option button 
D)  ​Dialog Box Launcher

Question 16

_____ refers to cells not wide enough to display the entire entry.​

Accepted Answer

A)  ​##### 
B)  ​&&&&& 
C)  ​$$$$$ 
D)  ​+++++ 
A)  ​##### 
B)  ​&&&&& 
C)  ​$$$$$ 
D)  ​+++++

Question 17

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 18

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Accepted Answer

A)  Goal 
B)  Formula 
C)  Option 
D)  Function 
A)  Goal 
B)  Formula 
C)  Option 
D)  Function

Question 19

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

Accepted Answer

Fill Forma

Question 20

_____ text often provides a strong visual appeal.​ ​

Accepted Answer

A)  ​Launched 
B)  ​Tiny 
C)  ​Logical 
D)  ​Rotated 
A)  ​Launched 
B)  ​Tiny 
C)  ​Logical 
D)  ​Rotated

You can replace a formula with its function so it remains constant.__________

____________________ are values in cells that can be changed to determine new values for formulas.

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

Panes created using the vertical split bar scroll together horizontally.________________________

Which comparison operator means "not equal to"?

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

You should use a ____ chart to compare values side by side,broken down by category.

Using the mouse to move or copy cells is called ____.

Charts can either be embedded in a worksheet or placed in a separate ____.

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

To open the Format Cells dialog box with the Alignment sheet active,click the Alignment Settings _____.

_____ refers to cells not wide enough to display the entire entry.

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

_____ text often provides a strong visual appeal.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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 3: Working With Large Worksheets, Charting, and What-If Analysis

You can replace a formula with its function so it remains constant.​__________

____________________ are values in cells that can be changed to determine new values for formulas.

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

Panes created using the vertical split bar scroll together horizontally.________________________

Which comparison operator means "not equal to"?

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box.Which of the following are valid values for that number?

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n)____________________ operation.

You should use a ____ chart to compare values side by side,broken down by category.

Using the mouse to move or copy cells is called ____.

Charts can either be embedded in a worksheet or placed in a separate ____.

You can press the CTRL+ACCENT MARK(`)keys to display the formulas in a worksheet._________________________

If the contents of a cell copied using the fill handle is Sunday and Tuesday,what are the next three values of the extended series?

To open the Format Cells dialog box with the Alignment sheet active,click the Alignment Settings _____.​

_____ refers to cells not wide enough to display the entire entry.​

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

The ____________________ option on the Auto Fill Options menu fills the destination area using the format of the source area; no content is copied unless the fill is a series.

_____ text often provides a strong visual appeal.​ ​

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

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

You can replace a formula with its function so it remains constant.__________

To open the Format Cells dialog box with the Alignment sheet active,click the Alignment Settings _____.

_____ refers to cells not wide enough to display the entire entry.

_____ text often provides a strong visual appeal.