Question 1

What is a field?

Accepted Answer

A) A complete set of data for an entity 
B) Indicates where data starts on a new worksheet 
C) An individual piece of data,such as an address 
D) All data about one specific item 
A) A complete set of data for an entity 
B) Indicates where data starts on a new worksheet 
C) An individual piece of data,such as an address 
D) All data about one specific item

Question 2

Each row in an Excel table:

Accepted Answer

A) is an individual piece of data,such as a last name. 
B) is the sequence in which pages print. 
C) represents a Field which can contain an individual piece of data for a record. 
D) represents a record. 
A) is an individual piece of data,such as a last name. 
B) is the sequence in which pages print. 
C) represents a Field which can contain an individual piece of data for a record. 
D) represents a record.

Question 3

How can you identify the difference between automatic page breaks on a worksheet and manual page breaks?

Accepted Answer

Blue dashed lines indicate whe

Question 4

Each column in a table:

Accepted Answer

A) needs to be converted to a range in order to work with it. 
B) represents a record. 
C) is a complete set of data for an entity. 
D) represents a field which can contain an individual piece of data for a record. 
A) needs to be converted to a range in order to work with it. 
B) represents a record. 
C) is a complete set of data for an entity. 
D) represents a field which can contain an individual piece of data for a record.

Question 5

A(n)________ is a space for an individual piece of data within a record,such as a street name.

Accepted Answer

The answer of A(n)________ is a space for an individual...

Question 6

The calculations on a total row in a table use the ________ function.

Accepted Answer

SUBTOTAL o

Question 7

A page break indicates where the end of all the columns (fields)occurs.

Accepted Answer

A) True 
 B)False

Question 8

How are manual page breaks indicated in a worksheet?

Accepted Answer

A) By solid blue lines 
B) By dotted red lines 
C) By blue dashed lines 
D) By solid black lines 
A) By solid blue lines 
B) By dotted red lines 
C) By blue dashed lines 
D) By solid black lines

Question 9

Print order:

Accepted Answer

A) represents a Field which is an individual piece of data. 
B) is the sequence in which pages print. 
C) represents a record. 
D) is the command to print in Excel 2013. 
A) represents a Field which is an individual piece of data. 
B) is the sequence in which pages print. 
C) represents a record. 
D) is the command to print in Excel 2013.

Question 10

What do banded rows and banded columns do in an Excel table?

Accepted Answer

Banded rows display alternate

Question 11

If the default conditional format options do not provide what you need,you can create your own rule for formatting.

Accepted Answer

A) True 
 B)False

Question 12

A(n)________ structured reference is a structured formula that includes references,such as table numbers.

Accepted Answer

The answer of A(n)________ structured reference is a structured formula...

Question 13

To keep columns and/or rows on the screen and visible,use the Windows group on the View Tab ,and then click ________ Panes.

Accepted Answer

The answer of To keep columns and/or rows on the...

Question 14

Match between columns
                        Premises: Press Ctrl+Home without frozen panes
Solid blue lines
Blue dashed lines on a worksheet
Press Ctrl+Home with frozen panes
F5

Accepted Answer

The Answer of Automatic page breaks and first unfrozen cell is...

Question 15

Sorting dates oldest to newest:

Accepted Answer

A) is the process of displaying only records that meet specific conditions. 
B) arranges dates in alphabetical order. 
C) is a Text filter. 
D) displays data in chronological order. 
A) is the process of displaying only records that meet specific conditions. 
B) arranges dates in alphabetical order. 
C) is a Text filter. 
D) displays data in chronological order.

Question 16

Function key ________ accesses the Go To command in Excel.

Accepted Answer

The answer of Function key ________ accesses the Go To...

Question 17

Press F6 to display the Go To dialog box.

Accepted Answer

A) True 
 B)False

Question 18

Table Styles use Live Preview.

Accepted Answer

A) True 
 B)False

Question 19

To create a table from an existing range of data:

Accepted Answer

A) click within the range,click the Table Tools Design tab,and then select Convert to Table. 
B) select any cell in the worksheet then click Existing Range in the Tools group. 
C) click in a cell and on the Home tab,click the Insert arrow in the Cells group. 
D) click the Insert tab and then click Table in the Tables group. 
A) click within the range,click the Table Tools Design tab,and then select Convert to Table. 
B) select any cell in the worksheet then click Existing Range in the Tools group. 
C) click in a cell and on the Home tab,click the Insert arrow in the Cells group. 
D) click the Insert tab and then click Table in the Tables group.

Question 20

Which of the following is NOT an option on the Page Layout tab?

Accepted Answer

A) Manage page breaks 
B) Set the print area 
C) Print titles 
D) Print preview 
A) Manage page breaks 
B) Set the print area 
C) Print titles 
D) Print preview

Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

What is a field?

Each row in an Excel table:

How can you identify the difference between automatic page breaks on a worksheet and manual page breaks?

Each column in a table:

A(n)________ is a space for an individual piece of data within a record,such as a street name.

The calculations on a total row in a table use the ________ function.

A page break indicates where the end of all the columns (fields)occurs.

How are manual page breaks indicated in a worksheet?

Print order:

What do banded rows and banded columns do in an Excel table?

If the default conditional format options do not provide what you need,you can create your own rule for formatting.

A(n)________ structured reference is a structured formula that includes references,such as table numbers.

To keep columns and/or rows on the screen and visible,use the Windows group on the View Tab ,and then click ________ Panes.

Sorting dates oldest to newest:

Function key ________ accesses the Go To command in Excel.

Press F6 to display the Go To dialog box.

Table Styles use Live Preview.

To create a table from an existing range of data:

Which of the following is NOT an option on the Page Layout 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: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

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