EXCEL Competency Exam Practice| updated 2023/24

EXCEL Competency Exam Practice| updated 2023/24 The 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