EXCEL Competency Exam Practice Questions And Answers Latest Top Score.

EXCEL Competency Exam Practice Questions And Answers Latest Top Score. The AutoAdd function adds up numbers in a column or row you specify a) True b) False - correct answer. b) False "AAA" is an example of a _______ in Excel a) cell reference b) column heading c) name box d) row heading - correct answer. 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 - correct answer. b) conditional formatting As a general rule, Excel will _______-align numbers. a) right b) left c) top d) bottom - correct answer. 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 - correct answer. 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 - correct answer. b) does not change Which of the following is a logical function? a) AVERAGE b) IF c) SUMPRODUCT d) VLOOKUP - correct answer. b) IF _______ order arranges content in reverse alphabetical order, from Z to A. a) Reverse b) Major c) Ascending d) Descending - correct answer. d) Descending _______ are a powerful tool to quickly group, summarize, and rearrange larger datasets. a) Cell references b) Functions c) Pivot tables d) Ranges - correct answer. c) Pivot tables