Filters
Question type
Study Flashcards

Match the following terms with the corresponding description.

Premises
DAVERAGE
DSUM
DMAX
DMIN
Database function
Responses
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.
Identifies the lowest value in a database column that matches conditions you specify
Analyze data for selected records only in a database table
Adds the values in a numeric database column based on conditions you specify in a criteria range
Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify

Correct Answer

DAVERAGE
DSUM
DMAX
DMIN
Database function

The first argument of any database function is ________.

Correct Answer

verifed

verified

Match the following terms with the corresponding description.

Premises
DSUM
DMIN
DAVERAGE
DMAX
DCOUNT
Responses
Adds the values in a numeric database column based on conditions you specify in a criteria range
Identifies the lowest value in a database column that matches conditions you specify
Counts the cells that contain numbers in a database column that match conditions you specify
Determines the arithmetic mean,or average,of numeric entries in a database column that match conditions you specify
Identifies the highest value in a database column that matches conditions you specify

Correct Answer

DSUM
DMIN
DAVERAGE
DMAX
DCOUNT

Showing 101 - 103 of 103

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

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

100 Questions

Exam 7

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

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

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

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

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

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

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

100 Questions

Exam 18

Excel: Introduction to Excel: What Is a Spreadsheet

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 20

Excel : Charts: Depicting Data Visually

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

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

103 Questions

Exam 23

Excel : What-If Analysis

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 27

Excel: Imports, web Queries, and Xml

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 30

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

100 Questions

Exam 31

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

100 Questions

Exam 32

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

100 Questions

Exam 33

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

100 Questions

Exam 34

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

100 Questions

Exam 35

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

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

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

100 Questions

Exam 38

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

100 Questions

Show Answer