Question 1

Default margins on an Excel 2013 worksheet are .75" top and bottom.

Accepted Answer

A) True 
 B)False  True

Question 2

An output area is defined as:

Accepted Answer

A) a region of a worksheet with formulas dependent on values from an input area. 
B) a display of the range name and tab name within a workbook. 
C) a range of cells containing values for variables used in formulas and functions within a worksheet. 
D) the active cell on an active worksheet. 
A) a region of a worksheet with formulas dependent on values from an input area. 
B) a display of the range name and tab name within a workbook. 
C) a range of cells containing values for variables used in formulas and functions within a worksheet. 
D) the active cell on an active worksheet. A

Question 3

The wrap text feature in Excel:

Accepted Answer

A) can be downloaded as an add-on to Excel 2013. 
B) enables long formulas to wrap to two or more lines within a single cell. 
C) is most useful with very short titles or column headings. 
D) enables data to appear on two or more lines within a cell. 
A) can be downloaded as an add-on to Excel 2013. 
B) enables long formulas to wrap to two or more lines within a single cell. 
C) is most useful with very short titles or column headings. 
D) enables data to appear on two or more lines within a cell. D

Question 4

The ________ Toolbar allows a user to quickly save,undo,and redo or repeat commands in Excel 2013.

Accepted Answer

The answer of The ________ Toolbar allows a user to...

Question 5

Formatting data makes it difficult to read and tends to obscure meaningful details.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: range
Copy as Picture command
nonadjacent range
Copy
select all cells in a worksheet

Accepted Answer

The Answer of press Ctrl+A twice and group of adjacent is...

Question 7

A range:

Accepted Answer

A) cannot be selected with the mouse. 
B) is the numbers that fall between the smallest and largest in a formula or function. 
C) is another word for the active worksheet. 
D) refers to a group of adjacent or contiguous cells. 
A) cannot be selected with the mouse. 
B) is the numbers that fall between the smallest and largest in a formula or function. 
C) is another word for the active worksheet. 
D) refers to a group of adjacent or contiguous cells.

Question 8

In Excel 2013,it is only possible to add a new worksheet when the workbook is created.

Accepted Answer

A) True 
 B)False

Question 9

To display a different worksheet click the sheet ________ at the bottom of the workbook window.

Accepted Answer

The answer of To display a different worksheet click the...

Question 10

Using the fill handle on a cell containing a formula:

Accepted Answer

A) cannot complete a sequence of dates in a column. 
B) changes the background color of the selected cells to yellow. 
C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula. 
D) has two or more sub-commands related to the command. 
A) cannot complete a sequence of dates in a column. 
B) changes the background color of the selected cells to yellow. 
C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula. 
D) has two or more sub-commands related to the command.

Question 11

How do the Comma,Accounting,and Currency formats differ?

Accepted Answer

The Comma format includes the comma as a

Question 12

A formula is:

Accepted Answer

A) a number that represents a date and can be the basis of calculations. 
B) a combination of cell references,operators,values,and/or functions used to perform calculations. 
C) a number that represents a quantity and can be the basis of calculations. 
D) entered into a cell by pressing F2. 
A) a number that represents a date and can be the basis of calculations. 
B) a combination of cell references,operators,values,and/or functions used to perform calculations. 
C) a number that represents a quantity and can be the basis of calculations. 
D) entered into a cell by pressing F2.

Question 13

An input area is defined as:

Accepted Answer

A) a range of cells containing results based on the output area. 
B) a display of the name of a worksheet within a workbook. 
C) a range of cells containing values for variables used in formulas. 
D) the active cell within a workbook. 
A) a range of cells containing results based on the output area. 
B) a display of the name of a worksheet within a workbook. 
C) a range of cells containing values for variables used in formulas. 
D) the active cell within a workbook.

Question 14

Adjust the column ________ to accommodate the widest entry in a column.

Accepted Answer

The answer of Adjust the column ________ to accommodate the...

Question 15

When B5 is the active cell and you press Ctrl+Enter,what happens?

Accepted Answer

The label,value,or f

Question 16

Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option.

Accepted Answer

A) True 
 B)False

Question 17

Describe a nonadjacent range,provide an example,and describe how to select a nonadjacent range.

Accepted Answer

A nonadjacent range contains two or more

Question 18

Match between columns
                        Premises: spreadsheet
Title bar
worksheet
Ribbon
workbook

Accepted Answer

The Answer of electronic file that contains a grid of is...

Question 19

The ________ bar displays information about a selected command or operation in progress.

Accepted Answer

The answer of The ________ bar displays information about a...

Question 20

Why would you want to use the Increase Decimal or Decrease Decimal buttons on the Home tab?

Accepted Answer

Use Increase Decimal or Decrease Decimal

Exam 18: Excel: Introduction to Excel: What Is a Spreadsheet

Default margins on an Excel 2013 worksheet are .75" top and bottom.

An output area is defined as:

The wrap text feature in Excel:

The ________ Toolbar allows a user to quickly save,undo,and redo or repeat commands in Excel 2013.

Formatting data makes it difficult to read and tends to obscure meaningful details.

A range:

In Excel 2013,it is only possible to add a new worksheet when the workbook is created.

To display a different worksheet click the sheet ________ at the bottom of the workbook window.

Using the fill handle on a cell containing a formula:

How do the Comma,Accounting,and Currency formats differ?

A formula is:

An input area is defined as:

Adjust the column ________ to accommodate the widest entry in a column.

When B5 is the active cell and you press Ctrl+Enter,what happens?

Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option.

Describe a nonadjacent range,provide an example,and describe how to select a nonadjacent range.

The ________ bar displays information about a selected command or operation in progress.

Why would you want to use the Increase Decimal or Decrease Decimal buttons on the Home tab?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters