Question 1.1.(TCO 2) An absolute cell reference:(Points : 2)<\/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
Question 2.2.(TCO 2) In Excel, a function can be defined as a _____.(Points : 2)<\/p>\n
predefined formula that performs a calculation<\/p>\n
cell reference or a value<\/p>\n
list of values and defined names as you enter data into a spreadsheet<\/p>\n
set of rules that govern the structure and components for a formula<\/p>\n
Question 3.3.(TCO 2) =$E2-G$4 contains examples of _____ cell references.(Points : 2)<\/p>\n
Absolute<\/p>\n
Mixed<\/p>\n
Relative<\/p>\n
Constant<\/p>\n
Question 4.4.(TCO 2) Which of the following describes the SUM function?(Points : 2)<\/p>\n
Identifies the midpoint value in a set of values.<\/p>\n
Calculates the total of values contained in two or more cells.<\/p>\n
Calculates the arithmetic mean or average of values in a range.<\/p>\n
Displays the lowest value in a range.<\/p>\n
Question 5.5.(TCO 2) The MEDIAN function would identify the ____.(Points : 2)<\/p>\n
lowest value in a range.<\/p>\n
midpoint value in a range.<\/p>\n
highest value in a range.<\/p>\n
total number of cells in a range.<\/p>\n
Question 6.6.(TCO 2) Which of the following best describes the COUNT function?(Points : 2)<\/p>\n
Tallies the number of cells in a range that are not empty.<\/p>\n
Tallies the number of blank cells in a range.<\/p>\n
Displays the current date.<\/p>\n
Tallies the number of cells in a range that contain values.<\/p>\n
Question 7.7.(TCO 2) The NOW function would perform which of the following?(Points : 2)<\/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
Question 8.8.(TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false.(Points : 2)<\/p>\n
feature<\/p>\n
formula<\/p>\n
condition<\/p>\n
option<\/p>\n
Question 9.9.(TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas.(Points : 2)<\/p>\n
constants<\/p>\n
macros<\/p>\n
programs<\/p>\n
procedures<\/p>\n
Question 10.10.(TCO 2) To simplify entering ranges in formulas, you can use _____.(Points : 2)<\/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
Question 11.11.(TCO 2) When calculating a PMT function, the RATE would be described best by which of the following?(Points : 2)<\/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
Question 12.12.(TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year.(Points : 2)<\/p>\n
template<\/p>\n
macro<\/p>\n
web query<\/p>\n
function<\/p>\n
Question 13.13.(TCO 7) To unlock cells, click the _____ tab, then click Format in the Cells group and select Lock Cell.(Points : 2)<\/p>\n
home<\/p>\n
page layout<\/p>\n
data<\/p>\n
view<\/p>\n
Question 14.14.(TCO 7) Which of the following file formats can store macros?(Points : 2)<\/p>\n
xlsm<\/p>\n
csv<\/p>\n
xml<\/p>\n
xlsx<\/p>\n
Question 15.15.(TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened.(Points : 2)<\/p>\n
saves<\/p>\n
deletes<\/p>\n
runs<\/p>\n
disables<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1.1.(TCO 2) An absolute cell reference:(Points : 2) 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 cell 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-53843","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/53843","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=53843"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/53843\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=53843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=53843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=53843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}