EXCEL Competency Exam Practice

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

A reference that refers to the same cell or range on multiple sheets is called a(n) _______ a) 3-D b) Clustered c) Indexed d) Pivotal

a) 3-D

As a general rule, Excel will _______-align numbers. a) right b) left c) top d) bottom

a) right

Removes all spaces from text except for single spaces between words. a) CODE b) CLEAN c) TRIM d) SUBSTITUTE

b) CLEAN

The AutoAdd function adds up numbers in a column or row you specify a) True b) False

b) False

Which of the following is a logical function? a) AVERAGE b) IF c) SUMPRODUCT d) VLOOKUP

b) IF

The _______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. a) AND b) OR c) SOME d) LOOKUP

b) OR

"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

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

A(n) _______ helps automate repetitive tasks in Excel by recording your steps. a) formula b) macro c) solver d) process

b) macro

_______ calculates the payment for a loan based on constant payments and a constant interest rate. a) CPMT b) LOAN c) PMT d) PPMT

c) PMT

_______ 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

Returns the number of characters you specify from the right side of a string a) CHAR b) LEN c) RIGHT d) RSTRING

c) RIGHT

A worksheet _______ is a collection of two or more selected worksheets. a) index b) roster c) group d) cluster

c) group

_______ order arranges content in reverse alphabetical order, from Z to A. a) Reverse b) Major c) Ascending d) Descending

d) Descending

A _______ analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. a) Change b) Performance c) Pivotal d) What-if

d) What-if