Match between columns Premises: DSUM DMIN DAVERAGE DMAX DCOUNT

The Answer of Adds the values in a numeric database is...

Match between columns Premises: DAVERAGE DSUM DMAX DMIN Database function

The Answer of Identifies the highest value in a database is...

Exam 24: Excel: Specialized Functions

The first argument of any database function is ________.

(Short Answer)

4.9/5

(35)

Question 101

Match the following terms with the corresponding description.

DSUM

Adds the values in a numeric database column based on conditions you specify in a criteria range

DMIN

Identifies the lowest value in a database column that matches conditions you specify

DAVERAGE

Counts the cells that contain numbers in a database column that match conditions you specify

Correct Answer:

Verified

DSUM

DMIN

DAVERAGE

DMAX

DCOUNT

(Matching)

4.7/5

(40)

Question 102

Match the following terms with the corresponding description.

DAVERAGE

Identifies the highest value in a database column that matches conditions you specify.For example,you can use the DMAX function to determine the highest salary of account reps in Boston.

DSUM

Identifies the lowest value in a database column that matches conditions you specify

DMAX

Analyze data for selected records only in a database table

Correct Answer:

Verified

DAVERAGE

DSUM

DMAX

DMIN

Database function

(Matching)

4.9/5

(38)

Question 103

Showing 101 - 103 of 103

The first argument of any database function is ________.

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: Datasets and Tables: Managing Large Volumes of Data

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

Excel : What-If Analysis

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