Question 1

Each ________ in an Excel table represents a record.

Accepted Answer

The answer of Each ________ in an Excel table represents...

Question 2

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

Accepted Answer

A) True 
 B)False

Question 3

With data arranged in a table,you can display a total row after the last record.Excel sums the values in the last column automatically

Accepted Answer

A) True 
 B)False

Question 4

A total row appears as the last row of a table to:

Accepted Answer

A) highlight or emphasize cells that meet certain conditions. 
B) format cells based upon their value in reference to the value of other cells. 
C) tag a table element as a reference in a formula. 
D) display summary statistics,such as a sum. 
A) highlight or emphasize cells that meet certain conditions. 
B) format cells based upon their value in reference to the value of other cells. 
C) tag a table element as a reference in a formula. 
D) display summary statistics,such as a sum.

Question 5

You can only apply one filter to a large dataset in Excel 2013.

Accepted Answer

A) True 
 B)False

Question 6

A table style controls the fill color of header rows.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following shows where automatic page breaks will occur 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 8

Match between columns
                        Premises: Color scale
Highlight Cells Rules
Icon set
Data bar
Top Bottom Rules

Accepted Answer

The Answer of horizontal gradient or solid fill indicating a is...

Question 9

The Freeze Panes option keeps:

Accepted Answer

A) only the first column visible as you scroll through a worksheet. 
B) both rows and columns above and to the left of the active cell visible as you scroll. 
C) only the designated rows visible as you scroll through a worksheet. 
D) all row names and column headings on the screen for preparation in printing. 
A) only the first column visible as you scroll through a worksheet. 
B) both rows and columns above and to the left of the active cell visible as you scroll. 
C) only the designated rows visible as you scroll through a worksheet. 
D) all row names and column headings on the screen for preparation in printing.

Question 10

Sorting arranges records in a table by:

Accepted Answer

A) using filter arrows. 
B) the row number. 
C) the value in field(s)within a table. 
D) permanently removing extraneous data. 
A) using filter arrows. 
B) the row number. 
C) the value in field(s)within a table. 
D) permanently removing extraneous data.

Question 11

What are icon sets?

Accepted Answer

Icon sets are symbols or signs

Question 12

A(n)________ row appears as the last row of a table to display summary statistics,such as a sum.

Accepted Answer

The answer of A(n)________ row appears as the last row...

Question 13

Excel enables you to sort data on ________ different levels.

Accepted Answer

A) 116 
B) 18 
C) 256 
D) 64 
A) 116 
B) 18 
C) 256 
D) 64

Question 14

Why might you want to freeze rows or columns in a large dataset?

Accepted Answer

When you scroll to parts of a dataset no

Question 15

What are the four types of sorts in Excel 2013?

Accepted Answer

There are Text,Dates

Question 16

If the automatic page breaks occur in undesirable locations,you can adjust the page breaks.

Accepted Answer

A) True 
 B)False

Question 17

A color scale:

Accepted Answer

A) highlights cells meeting specified criteria with a specified color,font,or border. 
B) is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range. 
C) calculates an aggregate for values in a range or database. 
D) is a conditional format that displays a color based on the relative value of the cell contents. 
A) highlights cells meeting specified criteria with a specified color,font,or border. 
B) is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range. 
C) calculates an aggregate for values in a range or database. 
D) is a conditional format that displays a color based on the relative value of the cell contents.

Question 18

Top/Bottom Rules:

Accepted Answer

A) is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells. 
B) moves data from the top of the workbook to the bottom for analysis. 
C) highlight cells meeting specified criteria with a specified color,font,or border. 
D) format cells based upon their value in relation to the value of other cells. 
A) is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells. 
B) moves data from the top of the workbook to the bottom for analysis. 
C) highlight cells meeting specified criteria with a specified color,font,or border. 
D) format cells based upon their value in relation to the value of other cells.

Question 19

Match between columns
                        Premises: Filtering
Duplicate Values
Top 10 option
Sorting
Custom Filter

Accepted Answer

The Answer of conditional formatting that displays doubled cells and is...

Question 20

You can sort data by one or more columns.

Accepted Answer

A) True 
 B)False

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

Each ________ in an Excel table represents a record.

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

With data arranged in a table,you can display a total row after the last record.Excel sums the values in the last column automatically

A total row appears as the last row of a table to:

You can only apply one filter to a large dataset in Excel 2013.

A table style controls the fill color of header rows.

Which of the following shows where automatic page breaks will occur in a worksheet?

The Freeze Panes option keeps:

Sorting arranges records in a table by:

What are icon sets?

A(n)________ row appears as the last row of a table to display summary statistics,such as a sum.

Excel enables you to sort data on ________ different levels.

Why might you want to freeze rows or columns in a large dataset?

What are the four types of sorts in Excel 2013?

If the automatic page breaks occur in undesirable locations,you can adjust the page breaks.

A color scale:

Top/Bottom Rules:

You can sort data by one or more columns.

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