Question 1

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

Accepted Answer

The answer of You can change the color of cells...

Question 2

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

Accepted Answer

A)  Fill Color
B)  Gridline
C)  Orientation
D)  BordersE) A) and B)
F) A) and C)

Question 3

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

Accepted Answer

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.E) None of the above
F) C) and D)

Question 4

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

Accepted Answer

A)  change the color of cells
B)  add borders to cells
C)  merge cells
D)  rotate cellsE) None of the above
F) B) and C)

Question 5

You cannot merge more than two cells in Excel. ​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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? ​

Accepted Answer

A)  Rotate Text Up
B)  Rotate Text Down
C)  Angle Counterclockwise
D)  Angle ClockwiseE) A) and C)
F) All of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

_________ is the amount added to the principal by the lender. 
A)Nominal value 
B)Installment 
C)Interest 
D)Intrinsic value

Accepted Answer

The answer of _________ is the amount added to the...

Question 10

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

Accepted Answer

A)  theme
B)  number format
C)  data
D)  referenceE) A) and C)
F) All of the above

Question 11

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? ​

Accepted Answer

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 shadingE) C) and D)
F) B) and D)

Question 12

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

Accepted Answer

A)  AutoFill
B)  Sort A to Z
C)  Wrap Text
D)  Add SeriesE) A) and B)
F) None of the above

Question 13

The general syntax of Excel functions is _____. ​

Accepted Answer

A)  FUNCTION () 
B)  FUNCTION ( argument1 , argument2 ,...) 
C)  FUNCTION ( text1 , number1 , text2 , number2 ,...) 
D)  FUNCTION(=value1) E) All of the above
F) B) and C)

Question 14

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

Accepted Answer

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 timeE) None of the above
F) B) and D)

Question 15

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

Accepted Answer

Answers will vary. The AutoFill Options ...

Question 16

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

Accepted Answer

A)  a ScreenTip
B)  an argument
C)  the AutoFill option
D)  a mixed referenceE) A) and B)
F) None of the above

Question 17

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

Accepted Answer

A)  top-aligned
B)  center-aligned
C)  left-aligned
D)  right-alignedE) A) and C)
F) A) and B)

Exam 14: Working With Formulas and Functions

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

_________ is the amount added to the principal by the lender. A)Nominal value B)Installment C)Interest D)Intrinsic value

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

The DAY(date) function is used to _____.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

You cannot merge more than two cells in Excel.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Answers will vary. The AutoFill Options ...
View Answer

The general syntax of Excel functions is _____.

Correct Answer
verified

Exam 14: Working With Formulas and Functions

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

Correct AnswerverifiedShow Answer

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? ​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

_________ is the amount added to the principal by the lender. A)Nominal value B)Installment C)Interest D)Intrinsic value

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You cannot merge more than two cells in Excel. ​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAnswers will vary. The AutoFill Options ...View AnswerShow Answer

The general syntax of Excel functions is _____. ​

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

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?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The DAY(date) function is used to _____.

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

You cannot merge more than two cells in Excel.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
Answers will vary. The AutoFill Options ...
View Answer

The general syntax of Excel functions is _____.

Correct Answer
verified