DA-1

Q1. A circular reference is a formula that either directly or indirectly depends on itself

A. TRUE

B. FALSE

Q2. The numbers in our worksheet look like this: 0.36 You want them to look like this: 36%. How can you accomplish this?

A. Right click on the cell > Select Format Cells > Choose Fraction from the menu

B. Click the % button on the formatting toolbar

C. Add the percentage calculation formula

D. Retype the desired value by manually adding the desired outcome

Q3. To delete an embedded object

A. Double click the object

B. Select the object by clicking it

C. Press the Shift + Delete keys

D. Select it and then press the delete key

Q4. Returns the number of characters you specify from the right side of a string

A. Char

B. Len

C. Right

D. Rstring

Q5. Removes all spaces from text except for single spaces between words

A. Code

B. Clean

C. Trim

D. Text to Column

Q6. Which of following is Not one of Excel’s what-if function?

A. Goal Seek

B. Solver

C. Scenario Manager

D. Auto Outline

Q7. You can use data ___________ to restrict the type of data or the values that users enter into a cell

A. Auditing

B. Delimit

C. Validation

D. Consolidate

Q8. 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. Pivot

D. What-if

Q9. ____ order arranges content in reverse alphabetical order, from Z to A

A. Reverse

B. Ascending

C. Descending

D. Transpose

Q10. _______ are a powerful tool to quickly group, summarize, and rearrange larger datasets

A. Cell References

B. Functions

C. Pivot Tables

D. Ranges