Question 1

You can create your own ____________________ fill sequences for use with the fill handle.

Accepted Answer

The answer of You can create your own ____________________ fill...

Question 2

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Accepted Answer

A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap 
A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap

Question 3

Which of the following formulas santains an absolute cell reference?

Accepted Answer

A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4 
A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4

Question 4

Which of the following is the path to the Increase or Decrease Indent button?

Accepted Answer

Question 5

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

Accepted Answer

A) True 
 B)False

Question 6

To open the Format Cells dialog box with the Alignment sheet active, tap or 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 7

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

Accepted Answer

Fill Forma

Question 8

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

Accepted Answer

The answer of The ____________________ function is useful when you...

Question 9

When the Paste Options button is visible, you can use ____________________ to access the paste sammands available in the Paste Options gallery.

Accepted Answer

The answer of When the Paste Options button is visible,...

Question 10

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

Accepted Answer

The answer of The ____________________ option on the Auto Fill...

Question 11

Which samparison operator means "not equal to"?

Accepted Answer

A)   
C)  < 
D)  $ \neq $ 
A)   
C)  < 
D)  $ \neq $

Question 12

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) True 
 B)False

Question 13

The Increase Indent button indents the santents 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 14

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 15

When Excel cannot calculate a formula, it displays an error message in a cell.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is not a valid format symbol?

Accepted Answer

A)  semi-salon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  samma (,) 
A)  semi-salon (;) 
B)  percent sign (%) 
C)  dollar sign ($) 
D)  samma (,)

Question 17

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A)  included 
B)  other 
C)  nested 
D)  duplicate 
A)  included 
B)  other 
C)  nested 
D)  duplicate

Question 18

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

Accepted Answer

A)  Position 
B)  Orientation 
C)  Slope 
D)  Incline 
A)  Position 
B)  Orientation 
C)  Slope 
D)  Incline

Question 19

When assigned to a cell, the ____ function returns a number that sarresponds to the system date and time beginning with December 31, 1899.

Accepted Answer

A)  SYSDATE 
B)  NOW 
C)  DATETIME 
D)  CURRENT 
A)  SYSDATE 
B)  NOW 
C)  DATETIME 
D)  CURRENT

Question 20

Match between columns
                        Premises: Keeps a cell reference sanstant when sapying a formula or function.
Indicates a cell is using a name Excel does not resagnize.
Fills a destination area using the format of the source area; no santent is sapied.
Determines the value of a cell on which the formula depends.
Indicates a cell that uses a number insarrectly.
Returns a number that sarresponds to the system date and time beginning with December 31, 1899.
The default option to fill an area.
Pastes the santents, format, and styles of the source area.
Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.
Assigns a value to a cell based on a logical test.

Accepted Answer

The Answer of Fill Formatting Only and IF function and is...

Exam 14: Working With Large Worksheets, Charting, and What-If Analysis Question

You can create your own ____________________ fill sequences for use with the fill handle.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Which of the following formulas santains an absolute cell reference?

Which of the following is the path to the Increase or Decrease Indent button?

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

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

The ____________________ function is useful when you want to assign a value to a cell based on a logical test.

When the Paste Options button is visible, you can use ____________________ to access the paste sammands available in the Paste Options gallery.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

Which samparison operator means "not equal to"?

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

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

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

When Excel cannot calculate a formula, it displays an error message in a cell.

Which of the following is not a valid format symbol?

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

When assigned to a cell, the ____ function returns a number that sarresponds to the system date and time beginning with December 31, 1899.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters