Exam 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Which of the following describes all of the categories of data pertaining to one person,place,thing,event,or idea within a table row?

(Multiple Choice)

4.8/5

(85)

Question 61

The criteria range is an area on your worksheet where you define the criteria for the filter.

(True/False)

4.9/5

(89)

Question 62

You can save an Excel file as a text file with which of the following file extensions?

(Multiple Choice)

4.8/5

(70)

Question 63

You can share worksheets or workbooks with others by ________.

(Multiple Choice)

4.8/5

(86)

Question 64

Match the terms or phases with their meanings: i.Compound criteria II.Wildcard III.And comparison operator IV.Or comparison operator v.Compound filter

(Multiple Choice)

4.8/5

(91)

Question 65

To move to a specific cell or range of cells in a large worksheet use the ________ command.

(Short Answer)

4.9/5

(75)

Question 66

Before printing or distributing a large worksheet,the Print Preview option enables you to see ________.

(Multiple Choice)

4.8/5

(83)

Question 67

A series of rows that contains related data is known as a query.

(True/False)

4.8/5

(83)

Question 68

A question mark (?)in a search criteria enables you to search for single characters in the field.

(True/False)

4.8/5

(75)

Question 69

An organized collection of facts related to a specific topic is known as a ________.

(Multiple Choice)

4.9/5

(74)

Question 70

A file format that was created by Adobe Systems to create a representation of what an Excel spreadsheet would look like when printed is ________.

(Short Answer)

4.9/5

(85)

Question 71

Use a(n)________ to apply complex criteria to a single column.

(Multiple Choice)

4.9/5

(78)

Question 72

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called ________.

(Short Answer)

4.7/5

(87)

Question 73

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

(Multiple Choice)

5.0/5

(85)

Question 74

The default font for headings in Excel is ________.

(Short Answer)

4.9/5

(65)

Question 75

A predesigned set of colors,fonts,lines,and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.

(Multiple Choice)

4.7/5

(91)

Question 76

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

(True/False)

4.7/5

(70)

Question 77

To freeze column and row titles on the screen so that they are visible while you scroll,which of the following command(s)would you use?

(Multiple Choice)

4.7/5

(81)

Question 78

The active area of a worksheet contains data or has contained data and does NOT contain cells that were not used in the worksheet.

(True/False)

4.8/5

(84)

Question 79

Subtotaled rows that are totaled and summarized are referred to as ________ data.

(Multiple Choice)

4.8/5

(81)

Question 80

Showing 61 - 80 of 98

Which of the following describes all of the categories of data pertaining to one person,place,thing,event,or idea within a table row?

The criteria range is an area on your worksheet where you define the criteria for the filter.

You can save an Excel file as a text file with which of the following file extensions?

You can share worksheets or workbooks with others by ________.

Match the terms or phases with their meanings: i.Compound criteria II.Wildcard III.And comparison operator IV.Or comparison operator v.Compound filter

To move to a specific cell or range of cells in a large worksheet use the ________ command.

Before printing or distributing a large worksheet,the Print Preview option enables you to see ________.

A series of rows that contains related data is known as a query.

A question mark (?)in a search criteria enables you to search for single characters in the field.

An organized collection of facts related to a specific topic is known as a ________.

A file format that was created by Adobe Systems to create a representation of what an Excel spreadsheet would look like when printed is ________.

Use a(n)________ to apply complex criteria to a single column.

The portions of a worksheet bounded by and separated from other parts of the worksheet by horizontal and vertical lines are called ________.

________ displays only the rows that meet the criteria or conditions you specify to limit which records are included in the results.

The default font for headings in Excel is ________.

A predesigned set of colors,fonts,lines,and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.

You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.

To freeze column and row titles on the screen so that they are visible while you scroll,which of the following command(s)would you use?

The active area of a worksheet contains data or has contained data and does NOT contain cells that were not used in the worksheet.

Subtotaled rows that are totaled and summarized are referred to as ________ data.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Creating Charts, Diagrams, and Templates

Excell: Creating Pivottables and Pivotcharts

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters