Exam 13: Customizing Your Workspace Text and Graphics

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?

Amanda needs to manually calculate an open worksheet. Which of the following options should she click on in the Formulas tab in the Calculation group?

Jada types out full names of students in her class in a single column, with a comma and a space between the first and the last name. She now wants to split the first and the last names into two columns. To do so, she clicks on the Text to Columns option on the Data tab in the Data Tools group. In the dialog box that appears, Jada chooses an option and clicks Next. She then clears all the check boxes under the selected option except for the Comma and Space check box and clicks Finish. Which of these can be the option Jada selected in the dialog box?

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?

You can repeatedly paste an item from the Office Clipboard as many times as you like.

To set the default language, open the file then click/ make entries in the following series: Insert > Options > Language > Choose Editing Languages > Select the language that you want to use in Set the Office Language Preferences dialog box > Set as Default.

To detect language automatically, you should select the Detect language automatically check box in the Language dialog box.

Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual?