Question 1. Question : <\/p>\n
(TCO 2) An absolute cell reference:<\/p>\n
causes a potential error.<\/p>\n
indicates a cell’s specific location and the reference does not change when you copy the formula.<\/p>\n
occurs when a formula directly or indirectly refers to the cell containing the formula.<\/p>\n
contains both an absolute and a relative cell reference.<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 2. Question : <\/p>\n
(TCO 2) Which of the following best describes a mixed cell reference?<\/p>\n
Occurs when a formula directly or indirectly refers to the cell containing the formula.<\/p>\n
Causes a potential error.<\/p>\n
Contains absolute or relative cell references, but not both.<\/p>\n
Contains both an absolute and a relative cell reference.<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 3. Question : <\/p>\n
(TCO 2) The rules for constructing a function can be referred to as the function’s _____.<\/p>\n
synthesis<\/p>\n
synergy<\/p>\n
synchronization<\/p>\n
syntax<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 4. Question : <\/p>\n
(TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.<\/p>\n
PRESENT<\/p>\n
TODAY<\/p>\n
CURRENT<\/p>\n
SET<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 5. Question : <\/p>\n
(TCO 2) The _____ function returns a result based on a condition.<\/p>\n
MAX<\/p>\n
TODAY<\/p>\n
FIND<\/p>\n
IF<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 6. Question : <\/p>\n
(TCO 2) The MAX function identifies the _____.<\/p>\n
highest value in a range.<\/p>\n
number of blank cells in a range.<\/p>\n
lowest value in a range.<\/p>\n
midpoint value in a range.<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 7. Question : <\/p>\n
(TCO 2) The NOW function would perform which of the following?<\/p>\n
Contains another function embedded inside one or more of its arguments.<\/p>\n
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.<\/p>\n
Evaluates true or false.<\/p>\n
Displays the current date and time.<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 8. Question : <\/p>\n
(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values.<\/p>\n
lookup value<\/p>\n
column index<\/p>\n
lookup table<\/p>\n
random<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 9. Question : <\/p>\n
(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell.<\/p>\n
sizing handle<\/p>\n
pointer<\/p>\n
fill handle<\/p>\n
insertion point<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 10. Question : <\/p>\n
(TCO 2) To simplify entering ranges in formulas, you can use _____.<\/p>\n
range names<\/p>\n
a cell’s relative location<\/p>\n
both an absolute and a relative cell reference<\/p>\n
a cell’s specific location<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 11. Question : <\/p>\n
(TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?<\/p>\n
It is the periodic interest rate, such as a monthly interest rate.<\/p>\n
It is the total number of payment periods.<\/p>\n
It is a word or a string of characters that represent one or more cells.<\/p>\n
It is the present value of the loan.<\/p>\n
: Textbook Chapter 2<\/p>\n
Comments: <\/p>\n
Question 12. Question : <\/p>\n
(TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.<\/p>\n
theme<\/p>\n
style<\/p>\n
template<\/p>\n
macro<\/p>\n
: Textbook Chapter 11<\/p>\n
Comments: <\/p>\n
Question 13. Question : <\/p>\n
(TCO 7) The process of protecting a worksheet requires you to enter a(n) _____.<\/p>\n
user name<\/p>\n
e-mail address<\/p>\n
IN user key<\/p>\n
password<\/p>\n
: Textbook Chapter 11<\/p>\n
Points Received: 0 of 2<\/p>\n
Comments: <\/p>\n
Question 14. Question : <\/p>\n
(TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.<\/p>\n
begin<\/p>\n
stop<\/p>\n
copy<\/p>\n
paste<\/p>\n
: Textbook Chapter 11<\/p>\n
Comments: <\/p>\n
Question 15. Question : <\/p>\n
(TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.<\/p>\n
View<\/p>\n
Data<\/p>\n
Insert<\/p>\n
Developer<\/p>\n
: see p. 608 in textbook, first point under “Creating Macro Buttons.”<\/p>\n
Comments: <\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. Question : (TCO 2) An absolute cell reference: causes a potential error. indicates a cell’s specific location and the reference does not change when you copy the formula. occurs when a formula directly or indirectly refers to the Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-120015","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/120015","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=120015"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/120015\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=120015"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=120015"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=120015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}