0 of 17 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 17 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
A cell can be linked to another cell to show the same data in two places. What is the main reason you would do this?
What feature allows you to copy and paste the results of a formula rather than the formula itself?
How can you enter group mode in which you can modify multiple worksheets in the same way at the same time?
What visual indicator appears to show you a comment has been added to a cell?
Which of the following is not a recommended consideration for the accessibility of your worksheet?
If you encrypt your Excel workbook and you forget the password, you can contact your IT department to reset the password.
What feature allows you to specify the accepted values that can be inserted into a cell?
Which of the following is NOT a limitation of the VLOOKUP function?
Which function tells you the location of a value within a range?
What is the purpose of cell tracing (e.g., Trace Error, Trace Precedents, Trace Dependents)?
The IFNA and IFERROR functions are examples of what best practice?
What is the purpose of Goal Seek in What-If Analysis?
What is the purpose of the Solver add-in?
Which of the following is NOT a key consideration for using map charts?
If your open a text file from inside Excel, the app will open the Text Import Wizard. Within this wizard, what is a delimiter?
What is the general term for objects you insert onto a custom form (e.g., list box, combo box, checkbox)?
Why would you choose to use ActiveX controls in your forms as opposed to regular form controls?