EXCEL Competency Exam Practice fully solved 2023 passed

EXCEL Competency Exam PracticeThe AutoAdd function adds up numbers in a column or row you specify a) True b) False b) False "AAA" is an example of a _______ in Excel a) cell reference b) column heading c) name box d) row heading b) column heading _______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets. a) cell references b) conditional formatting c) Excel tables d) pivot tables b) conditional formatting As a general rule, Excel will _______-align numbers. a) right b) left c) top d) bottom a) right Cell D4 contains the formula =C1+C2. What formula will you see when you paste this into cell E5? a) =C1+C2 b) =$C1+$C2 c) =D2+D3 d) =E6+E7 c) =D2+D3 When you copy a formula that contains an absolute reference to a new location, the reference _______. a) is updated automatically b) does not change c) becomes bold d) has a dotted outline in its cell b) does not change Which of the following is a logical function? a) AVERAGE b) IF c) SUMPRODUCT d) VLOOKUP b) IF _______ order arranges content in reverse alphabetical order, from Z to A. a) Reverse b) Major c) Ascending d) Descending d) Descending _______ are a powerful tool to quickly group, summarize, and rearrange larger datasets. a) Cell references b) Functions c) Pivot tables d) Ranges c) Pivot tables A worksheet _______ is a collection of two or more selected worksheets. a) index b) roster c) group d) cluster c) group