Microsoft Excel Ch. 5 EXAM
Sign in to Google to save your progress. Learn more
Last Name *
First Name *
Date *
MM
/
DD
/
YYYY
Hour *
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell. *
In the figure below, the Pmt figure is -250. The negative number means ____. *
Captionless Image
An example of the function of the natural logarithm of a number written correctly is ____. *
Date and time functions can be used to convert serial numbers to a ____. *
If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon. *
In the figure below, the annual interest rate is ____. *
Captionless Image
In the IF function, the second argument determines the value that appears in the cell if the logical test is ____. *
In the IF function, the third argument determines the value that appears in the cell if the logical test is ____. *
The ____ function replaces existing text in a specified cell with new text. *
An example of the function that returns the number of cells in a range of cells that contain data is ____. *
The present value of a loan based on equal payments is written as ____. *
In a PMT function, the argument indicated by fv refers to ____. *
An example of a square root function written correctly is ____. *
The AND function returns the result of ____ if any or all of the arguments are false. *
The ____ function repeats the text in the specified cell a specified number of times. *
You can use the Insert Function dialog box to find a specific function. In the ____ box, type a brief description of what you want to do. Then, click Go. *
You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key. *
The IFERROR function is written as ____. *
Case EX 5-1
Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet.
What should Cheryl do to access Formula AutoComplete to help her write her formulas? *
Case EX 5-2
Sam is using the functions within Excel to complete questions in a school homework assignment.
Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function. *
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy