Question 1

The =DATE(year,month,day)function returns a serial number for a date.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is FALSE about a function in Excel?

Accepted Answer

A) A function is a predefined formula that performs a calculation. 
B) There are more than 400 functions in Excel 2013. 
C) Functions are organized into two categories in Excel. 
D) Functions in Excel must adhere to correct syntax. 
A) A function is a predefined formula that performs a calculation. 
B) There are more than 400 functions in Excel 2013. 
C) Functions are organized into two categories in Excel. 
D) Functions in Excel must adhere to correct syntax.

Question 3

What is Quick Analysis in Excel 2013?

Accepted Answer

Quick Analysis is a new feature of Excel

Question 4

What does the TODAY function do?

Accepted Answer

A) Evaluates the day of the week,the date,and the time that the function was entered 
B) Displays the current date and time 
C) Displays the current date 
D) Displays any day that the user enters 
A) Evaluates the day of the week,the date,and the time that the function was entered 
B) Displays the current date and time 
C) Displays the current date 
D) Displays any day that the user enters

Question 5

Describe a circular reference.Provide an example.

Accepted Answer

A circular reference occurs if a formula

Question 6

Match between columns
                        Premises: Expand button
Trace Error button
Quick Analysis button
Collapse button
Auto Fill Options button

Accepted Answer

The Answer of set of tools to use to apply is...

Question 7

Which of the following is FALSE about the NOW function?

Accepted Answer

A) It displays the current date in a cell. 
B) It uses the computer's clock to display the date and time. 
C) It uses military time. 
D) It displays the current date and time. 
A) It displays the current date in a cell. 
B) It uses the computer's clock to display the date and time. 
C) It uses military time. 
D) It displays the current date and time.

Question 8

The IF function:

Accepted Answer

A) contains data for the basis of the lookup and data to be retrieved. 
B) looks up a value and returns a related result from a lookup table. 
C) evaluates a condition and returns one value if the condition is true,a different if false. 
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) looks up a value and returns a related result from a lookup table. 
C) evaluates a condition and returns one value if the condition is true,a different if false. 
D) contains another function embedded inside one or more of its arguments.

Question 9

The ________ function category performs tests and returns the value of the tests.

Accepted Answer

The answer of The ________ function category performs tests and...

Question 10

The pv of a PMT function refers to the present value of a loan.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: COL
Tax_Rate
Grades
Discount Rate %
Commission Rate

Accepted Answer

The Answer of acceptable name with underscore and acceptable abbreviation is...

Question 12

Match between columns
                        Premises: (... ,table_array,... )
(logical_test,... ,... )
(Number1)
(rate,... ,... )
( )

Accepted Answer

The Answer of =VLOOKUP and =TODAY and =PMT and =IF is...

Question 13

Match between columns
                        Premises: =($C5+D5)*$E5
=(C5+D5)*E5
=(C5+D5)*$E$5

Accepted Answer

The Answer of includes a circular reference and uses a is...

Question 14

A relative cell ________ indicates a cell's relative location.

Accepted Answer

The answer of A relative cell ________ indicates a cell's...

Question 15

The nper in a PMT function is:

Accepted Answer

A) the total number of payment periods. 
B) a word or a string of characters that represent one or more cells. 
C) the present value of a loan. 
D) a set of range names. 
A) the total number of payment periods. 
B) a word or a string of characters that represent one or more cells. 
C) the present value of a loan. 
D) a set of range names.

Question 16

What is a lookup table used for?

Accepted Answer

A) It looks up a value and returns a related result. 
B) It contains data for the basis of a lookup and the data to be retrieved. 
C) It is the lowest value for a specific category or series. 
D) It is a reference to a cell containing a value to look up. 
A) It looks up a value and returns a related result. 
B) It contains data for the basis of a lookup and the data to be retrieved. 
C) It is the lowest value for a specific category or series. 
D) It is a reference to a cell containing a value to look up.

Question 17

Match between columns
                        Premises: Syntax
Function ScreenTip
Formula AutoComplete
Function
Argument

Accepted Answer

The Answer of specific inputs in a function and displays is...

Question 18

The first argument in a PMT function is the ________.

Accepted Answer

The answer of The first argument in a PMT function...

Question 19

A range name:

Accepted Answer

A) indicates a cell's specific location and the reference does not change when you copy the formula. 
B) is a word or a string of characters that represent one or more cells. 
C) indicates a cell's relative location from the cell containing the formula. 
D) always begins with an equal sign (=). 
A) indicates a cell's specific location and the reference does not change when you copy the formula. 
B) is a word or a string of characters that represent one or more cells. 
C) indicates a cell's relative location from the cell containing the formula. 
D) always begins with an equal sign (=).

Question 20

The ________ function returns one value if a condition is true and another if a condition is false.

Accepted Answer

The answer of The ________ function returns one value if...

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

The =DATE(year,month,day)function returns a serial number for a date.

Which of the following is FALSE about a function in Excel?

What is Quick Analysis in Excel 2013?

What does the TODAY function do?

Describe a circular reference.Provide an example.

Which of the following is FALSE about the NOW function?

The IF function:

The ________ function category performs tests and returns the value of the tests.

The pv of a PMT function refers to the present value of a loan.

A relative cell ________ indicates a cell's relative location.

The nper in a PMT function is:

What is a lookup table used for?

The first argument in a PMT function is the ________.

A range name:

The ________ function returns one value if a condition is true and another if a condition is false.

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