Deck 14: Working With Formulas and Functions

Question 1

The accompanying figure shows a cell in Microsoft Excel 2016 with _____. ​

A) mixed references ​
B)financial functions
C)center aligned text
D)the fill color option

Answer 1

A

Question 2

​ $A$7 is a relative cell reference.

Answer 2

False

Question 3

The Wrap Text option is used to center cell content vertically within the cell. ​

Answer 3

False

Question 4

Functions that retrieve data from multidimensional databases involving online analytical processing (OLAP) are called _____. ​

A)Compatibility functions
B)Cube functions
C)Math & Trig functions
D)Statistical functions

Question 5

The formula =SUM(D28:D30) uses an absolute reference. ​

Question 6

Functions that return true or false values are called _____. ​

A) logical functions.
B)statistical functions.
C)database functions.
D)financial functions

Question 7

You cannot merge more than two cells in Excel. ​

Question 8

Which of the following is true of optional arguments? ​

A)They are used to specify how a function should be written.
B)They are not separated by a comma when used within a function.
C)They are not required for a function to return a value.
D)They always start with a $ symbol in front of them.

Question 9

The Paste Options button in Excel offers fewer options than in Word. ​

Question 10

Miley is using Excel to calculate the value of power. She varies the value of voltage while maintaining a constant value of current. In the final step, she adds a $ in front of the current value in a formula. The formula entered by Miley is composed of _____. ​

A)relative references only
B)absolute references
C)refined references
D)mixed references only

Question 11

​ The Increase Indent button is in the Alignment group on the Home tab.

Question 12

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range? ​

A)Alt+R
B)F4
C)Shift+PgDn
D)F1

Question 13

The syntax of the PMT function is PMT(rate,nper,pv[,fv=0][,type=0]). ​

Question 14

The WEEKDAY function returns the current date and time. ​

Question 15

To remove an indentation, click the Decrease Indent button. ​

Question 16

The formula =SUM(A7:A9) is an example of a(n) _____ reference. ​

A)relative
B)linear
C)absolute
D)tabular

Question 17

The MIDPOINT function calculates the middle value of a collection of numbers. ​

Question 18

Borders are the lines that divide the columns and rows on a worksheet and define the structure of the worksheet. ​

Question 19

When a worksheet is printed, the gridlines are not printed unless you specify that they should be.  ​

Question 20

You cannot apply styles to a cell and its contents in Excel. ​

Question 21

In the accompanying figure of Microsoft Excel 2016, the present value (PV) is _____. ​

A)$20,000.00
B)60
C)12
D)$386.66

Question 22

Which of the following is true of a what-if analysis? ​

A)It is an examination of how changing values entered directly in a worksheet affect calculated values.
B)It is used to display both the current date and the current time.
C)It has a fill handle that can be dragged over a range to fill the series.
D)It limits the type of data that can be entered in a cell and removes duplicate data in a row.

Question 23

The series in the accompanying figure of Microsoft Excel 2016 has been created using the _____ option. ​

A)AutoFill
B)Sort A to Z
C)Wrap Text
D)Add Series

Question 24

The dialog box in the accompanying figure of Microsoft Excel 2016 is the _____ dialog box. ​ ​

A)Series
B)Date & Time
C)Trend
D)AutoFill

Question 25

In the accompanying figure of a feature of Microsoft Excel 2016, Box 1 points to the _____. ​ ​

A)required arguments
B)financial function
C)optional arguments
D)value returned by the function

Question 26

After selecting a function from the list, press the _____ key to insert it into the active cell. ​

A)Tab
B)Shift
C)F4
D)Insert

Question 27

Which of the following functions is used to calculate the day of the week from the date value? ​

A)WEEKDAY( date [, return_type ])
B)WEEKDAY( return-type, )
C)WEEKDAY( day, month, year )
D)WEEKDAY( MM / DD / YY )

Question 28

Which of the following AutoFill features copies the content but not the pattern? ​

A)Fill Without Formatting
B)AutoFill Content Only
C)Copy Content Only
D)Undo Formatting

Question 29

Which of the following is true of the COUNTA( value1 [, value2 , value3 ,...]) function? ​

A)It calculates the number of cells that are not empty in ranges.
B)It calculates the average of a collection of numbers.
C)It calculates the cells in a range containing numbers.
D)It calculates the maximum value of a collection of numbers.

Question 30

_____ is the amount of money being loaned. ​

A)Principal
B)Down payment
C)Interest
D)Stake

Question 31

​ In the accompanying figure of Microsoft Excel 2016, Box 1 points to _____. ​

A)a ScreenTip
B)an argument
C)the AutoFill option
D)a mixed reference

Question 32

Asher, a high school student, is learning how to use Excel. He enters a sequence of numbers, 1.0, 1.25, 1.5, …, as data in the first column. Which of the following features of AutoFill should Asher use to continue the pattern of data? ​

A)Fill Without Formatting
B)Flash Fill
C)Copy Cells
D)Fill series

Question 33

The _____ button can be used to see a more precise interest rate per period for loans. ​

A)Increase Decimal
B)Middle Align
C)Sort & Filter
D)Trace Precedents

Question 34

The DAY(date) function is used to _____. ​

A)extract the day of the month from the date value
B)return the day in the date value where 1=Monday, 2=Tuesday, and so forth
C)create a date value for the date represented by the year, month, and day arguments
D)display the current date and time

Question 35

RAND() is an example of a _____ function. ​

A)Cube
B)Math & Trig
C)Lookup & Reference
D)Information

Question 36

In the accompanying figure of a feature of Microsoft Excel 2016, B6:B11 is the _____. ​ ​

A)required argument
B)active cell
C)optional argument
D)merged cell

Question 37

In the accompanying figure of a feature of Microsoft Excel 2016, _____ points to the value that will be displayed in the active cell. ​ ​

A)Box 1
B)Box 2
C)Box 3
D)Box 4

Question 38

The general syntax of Excel functions is _____. ​

A)FUNCTION ()
B)FUNCTION ( argument1 , argument2 ,...)
C)FUNCTION ( text1 , number1 , text2 , number2 ,...)
D)FUNCTION(=value1)

Question 39

Which of the following is true of parenthesis in Microsoft Excel 2016? ​

A)Excel uses parenthesis in formulas to interpret them correctly.
B)Excel displays text and numbers only within parenthesis.
C)The parenthesis function in Excel returns a random number between 0 and 1.
D)The formulas in Excel always begin with an open parenthesis.

Question 40

In the accompanying figure of a feature of Microsoft Excel 2016, the button that Box 1 indicates is used to _____. ​ ​

A)collapse the dialog box
B)calculate the sum of the two cells
C)add an absolute reference to the cell
D)indicate an error

Question 41

The accompanying figure shows the buttons in Microsoft Excel 2016 that are used to _____ cells. ​

A)indent
B)combine
C)orient
D)merge

Question 42

In Microsoft Excel 2016, some styles are based on the workbook's current _____.

A)theme
B)number format
C)data
D)reference

Question 43

The Fill Color button arrow is located in the _____ group on the Home tab. ​

A)Font
B)Alignment
C)Styles
D)Editing

Question 44

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function? ​

A)Right-click on the cell containing the range and select the Format Cells option from the list
B)Position the cursor on the cell where the formula should appear
C)Drag the cell and place it on top of the reference cell
D)Select the range again and drag a handle on the border of the shading

Question 45

Andy, a chess player, wants to change the background of his Excel workbook to make it look like a chessboard. For this purpose, Andy should use the _____ button. ​

A)Fill Color
B)SmartArt
C)Cell Style
D)Theme

Question 46

The accompanying figure shows the Border tab in the _____ dialog box in Microsoft Excel 2016. ​ ​

A)Format Cells
B)AutoFill
C)Function Arguments
D)Paste Special

Question 47

​ The accompanying figure shows the _____ group on the Home tab in Microsoft Excel 2016.

A)Alignment
B)Editing
C)Styles
D)Font

Question 48

Case 14-1 Jenny, a programmer, uses Microsoft Excel 2016 to generate data required for the programs she develops. She uses various functions in Excel to perform the required calculations.
Jenny enters =INT(3.1428) in one of the cells, which returns the integer value. The function used by Jenny is a _____ function.

A)Math & Trig
B)Statistical
C)Date & Time
D)Logical

Question 49

​ In the accompanying figure of Microsoft Excel 2016, a worksheet named Budget refers to cell B10 on another worksheet named Car Loan Calculator in the same workbook. Which of the following will be the reference to cell B10?

A)='Car Loan Calculator'!B10
B)="Car Loan Calculator"!B10
C)='Car Loan Calculator'[B10]
D)="Car Loan Calculator"[B10]

Question 50

In the accompanying figure of Microsoft Excel 2016, the highlighted portion labeled "Savings Account" is an example of _____. ​

A)merging two cells
B)indenting cell contents
C)using AutoFill functions
D)citing mixed references

Question 51

The accompanying figure shows a button in Microsoft Excel 2016 that is used to _____. ​

A)change the color of cells
B)add borders to cells
C)merge cells
D)rotate cells

Question 52

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____. ​

A)single quotation mark appears to the right of the first square bracket and after the sheet name
B)double quotation mark appears to the left of the first square bracket and after the sheet name
C)single quotation mark appears to the left of the first square bracket and after the sheet name
D)double quotation mark appears to the right of the first square bracket and after the sheet name

Question 53

The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel. ​

A) Paste Special ​
B)Paste Options
C)Detailed Paste
D)Paste Cells

Question 54

A cell background can be formatted by using the _____ button. ​

A)Fill Color
B)Gridline
C)Orientation
D)Borders

Question 55

The cells in the accompanying figure of Microsoft Excel 2016 are _____. ​

A)top-aligned
B)center-aligned
C)left-aligned
D)right-aligned

Question 56

Case 14-2 Morris, a librarian, wishes to use Microsoft Excel 2016 to manage data on the books in the library. He explores various tabs and buttons in Excel to present the data as intended.
On the Home tab, in the Alignment group, Morris notices the feature shown in the accompanying figure. Morris identifies this feature as the _____ button.

A)Decrease Indent
B)Increase Indent
C)Align Right
D)Align Left

Question 57

Which of the following is true of borders in Excel? ​

A)Borders and gridlines are the same in Excel.
B)You must specify if borders must be printed or not.
C)Borders are the lines that divide the columns and rows on a worksheet.
D)You can specify the thickness of and the number of lines in borders.

Question 58

Rebecca, a workflow analyst at Blanket Flower LLC, is using Microsoft Excel 2016 to develop work schedules for each department in the company. Her manager asks her to list the various departments in the company in the first column of the worksheet as shown in the figure given below. Which of the following orientations should Rebecca use to represent the cell content as shown in the figure? ​

A)Rotate Text Up
B)Rotate Text Down
C)Angle Counterclockwise
D)Angle Clockwise

Question 59

Case 14-1 Jenny, a programmer, uses Microsoft Excel 2016 to generate data required for the programs she develops. She uses various functions in Excel to perform the required calculations.
Jenny is coding a security program to generate numerical passwords in Excel. Jenny should use the _____ function to generate the numerical portions of the passwords arbitrarily.

A)SUM()
B)RAND()
C)ROUND()
D)INT()

Question 60

Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell? ​

A)Merge & Center button
B)Wrap Text button
C)Orientation button
D)Lock Cell button

Question 61

A(n) _________ is a cell reference that contains both an absolute reference and a relative reference.

A)phantom reference
B)dangling reference
C)symbolic reference
D)pointer reference

Question 62

A _________ is a line you add along an edge of a cell.

A)gridline
B)caption
C)border
D)clip

Question 63

The _________ option merges each of the rows in the selected range around the columns in the range.

A)Merge & Centre
B)Increase Indent
C)Decrease Indent
D)Merge Across

Question 64

Case 14-2 Morris, a librarian, wishes to use Microsoft Excel 2016 to manage data on the books in the library. He explores various tabs and buttons in Excel to present the data as intended.
Morris notices the feature shown in the accompanying figure on the Home tab of his worksheet. Morris identifies this feature as the _____ button.
​

A)Orientation
B)Increase Indent
C)Top Align
D)Wrap Text

Question 65

TODAY function is the most commonly used ________ function.

A)finalize
B)time
C)financial
D)date

Question 66

List and briefly describe the financial functions used for loans and investments in Excel. ​

Question 67

If a(n) _________ is not included in a function, Excel assumes a default value for it.

A)recordset
B)multitable query
C)optional argument
D)endnote

Question 68

Briefly describe the different options available under the AutoFill Options button. ​

Question 69

​ When are relative, absolute, and mixed references used in Excel? Briefly explain.

Question 70

_________ are numbers, text, or cell references used by a function to return a value.

A)Ribbons
B)Piconets
C)Microwaves
D)Arguments

Question 71

_________ is an examination of how changing values entered directly in a worksheet affect calculated values.

A)What-if analysis
B)Inferential analysis
C)Exploratory analysis
D)If-Then-Else analysis

Question 72

_________ is the amount added to the principal by the lender.

A)Nominal value
B)Installment
C)Interest
D)Intrinsic value

Question 73

Cell references that remain fixed when a formula is copied to a new location are called _________.

A)phantom references
B)relative references
C)absolute references
D)pointer references

Question 74

The term _________ is defined as the length of time between each loan payment.

A)down payment
B)loan period
C)payment period
D)nominal value

Question 75

A cell reference that is interpreted in relation to the location of the cell containing the formula is called _________.

A)absolute reference
B)pointer reference
C)phantom reference
D)relative reference

Question 76

You can change the color of cells by adding background colors, also known as _________.

A)fill handle
B)color palettes
C)fill colors
D)flex wrap

Question 77

A(n) _________ is a function related to monetary calculations, such as loans and payments.

A)exponential function
B)financial function
C)finalize function
D)library function