Question 1

Syntax:

Accepted Answer

A) displays a list of functions and defined names as you enter a function. 
B) is a small pop-up description that displays the arguments for a function as you enter it. 
C) is a set of rules that govern the structure and components for a function. 
D) is an input such as a cell reference or a value needed to complete a function. 
A) displays a list of functions and defined names as you enter a function. 
B) is a small pop-up description that displays the arguments for a function as you enter it. 
C) is a set of rules that govern the structure and components for a function. 
D) is an input such as a cell reference or a value needed to complete a function.

Question 2

Match between columns
                        Premises: Lookup table
Quick Analysis
Logical test
Nested function
Breakpoint

Accepted Answer

The Answer of range containing values or text that can is...

Question 3

What does the MEDIAN function do?

Accepted Answer

A) Identifies the lowest value in a range 
B) Identifies the midpoint value in a set of values 
C) Identifies the highest value in a range 
D) Tallies the number of cells in a range that contain values 
A) Identifies the lowest value in a range 
B) Identifies the midpoint value in a set of values 
C) Identifies the highest value in a range 
D) Tallies the number of cells in a range that contain values

Question 4

Because the SUM function is a rarely used function it has no button on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 5

A mixed cell reference:

Accepted Answer

A) occurs when a formula directly or indirectly refers to the cell containing the formula. 
B) causes a potential error. 
C) contains absolute or relative cell references,but not both. 
D) contains both an absolute and a relative cell reference. 
A) occurs when a formula directly or indirectly refers to the cell containing the formula. 
B) causes a potential error. 
C) contains absolute or relative cell references,but not both. 
D) contains both an absolute and a relative cell reference.

Question 6

The ________ function category performs calculations such as averages and standard deviations.

Accepted Answer

The answer of The ________ function category performs calculations such...

Question 7

Match between columns
                        Premises: Lookup & Reference
Logical
Statistical
Date & Time
Financial

Accepted Answer

The Answer of looks up values in cells and creates is...

Question 8

While lookup tables are typically designed vertically,they can also be designed horizontally.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: =ROUND(number,num_digits)
=FREQUENCY(data_array,bins_array)
=MODE.SNGL(number1,[number2],... )
=INT(number)
=ABS(number)

Accepted Answer

The Answer of counts how often a value appears in is...

Question 10

The IF function in Excel 2013 has ________ arguments.

Accepted Answer

The answer of The IF function in Excel 2013 has...

Question 11

What is the F4 key used for in Excel 2013?

Accepted Answer

The F4 key toggles through relative,abso

Question 12

The IF function only evaluates a condition if the condition is true.

Accepted Answer

A) True 
 B)False

Question 13

Formula ________ displays a list of functions and defined names that match the letters that you start typing when creating a formula.

Accepted Answer

The answer of Formula ________ displays a list of functions...

Question 14

How are an input area on a worksheet and absolute cell references related?

Accepted Answer

An input area is a range in a worksheet

Question 15

A nested function:

Accepted Answer

A) contains data for the basis of the lookup and data to be retrieved. 
B) is the lowest value for a specific category or series in a lookup table. 
C) looks up a value and returns a related result from the lookup table. 
D) contains another function embedded inside one or more of its arguments. 
A) contains data for the basis of the lookup and data to be retrieved. 
B) is the lowest value for a specific category or series in a lookup table. 
C) looks up a value and returns a related result from the lookup table. 
D) contains another function embedded inside one or more of its arguments.

Question 16

The second argument for the IF function is the logical test.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ cell reference provides a permanent reference to a specific cell.

Accepted Answer

The answer of A(n)________ cell reference provides a permanent reference...

Question 18

A circular reference:

Accepted Answer

A) is a predefined formula that performs a calculation. 
B) is a rule that governs the structure and components for functions. 
C) occurs when a formula directly or indirectly refers to the cell containing the formula. 
D) is an input such as a cell reference or a value needed to complete a function. 
A) is a predefined formula that performs a calculation. 
B) is a rule that governs the structure and components for functions. 
C) occurs when a formula directly or indirectly refers to the cell containing the formula. 
D) is an input such as a cell reference or a value needed to complete a function.

Question 19

In Excel 2013,the function name describes the purpose of the function.

Accepted Answer

A) True 
 B)False

Question 20

The TODAY function displays what is due to be done today.

Accepted Answer

A) True 
 B)False

Exam 19: Excel: Formulas and Functions: Performing Quantitative Analysis

Syntax:

What does the MEDIAN function do?

Because the SUM function is a rarely used function it has no button on the Ribbon.

A mixed cell reference:

The ________ function category performs calculations such as averages and standard deviations.

While lookup tables are typically designed vertically,they can also be designed horizontally.

The IF function in Excel 2013 has ________ arguments.

What is the F4 key used for in Excel 2013?

The IF function only evaluates a condition if the condition is true.

Formula ________ displays a list of functions and defined names that match the letters that you start typing when creating a formula.

How are an input area on a worksheet and absolute cell references related?

A nested function:

The second argument for the IF function is the logical test.

A(n)________ cell reference provides a permanent reference to a specific cell.

A circular reference:

In Excel 2013,the function name describes the purpose of the function.

The TODAY function displays what is due to be done today.

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 : 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: 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