Question 1

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?

A) Delimited
B) Fixed Width
C) Fixed Length
D) Data Preview

A

Accepted Answer

Jada is choosing to split the full names based on a specific character (comma and space), which is the definition of delimited. Fixed Width and Fixed Length options would not work as the spacing between the first and last name is not fixed. Data Preview is not an option in the Text to Columns dialog box, it is simply a display of what the data will look like after it has been split.

Question 2

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

Accepted Answer

Yes, you can paste an item from the Office Clipboard multiple times by pressing the paste option repeatedly or using the Ctrl + V keyboard shortcut multiple times.

Question 3

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?&#10;A) Formulas&#10;B) Proofing&#10;C) Language&#10;D) Advanced

Accepted Answer

The option "Formulas" should be chosen as X to calculate formulas automatically in Excel. This option can be found under the "Formulas" tab in the Excel Options menu. Choosing this option will ensure that formulas are recalculated every time a change is made in the worksheet.

Question 4

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?&#10;A) Calculate Now&#10;B) Calculate Sheet&#10;C) Watch Window&#10;D) Calculation Options

Accepted Answer

The answer of Amanda needs to manually calculate an open...

Question 5

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?&#10;A) Formulas&#10;B) Proofing&#10;C) Language&#10;D) Advanced

Accepted Answer

"Automatic" refers to calculating formulas automatically, which falls under the category of "Formulas". Therefore, the best choice is A) Formulas.

Question 6

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

Accepted Answer

Excel's Spell Checker checks the spelling in the current worksheet only, not in all worksheets at once. You need to manually select each worksheet and run the Spell Checker for each one.

Question 7

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.

Accepted Answer

The correct sequence to set the default language in Microsoft Office applications typically involves going to File > Options > Language, then under the "Choose Editing Languages" section, you select the language you want to use and click "Set as Default." The sequence "Insert > Options > Language" is incorrect.

Question 8

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

Accepted Answer

Selecting the "Detect language automatically" check box in the Language dialog box will allow the system to automatically detect the language.

Question 9

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?&#10;A) Formulas&#10;B) Proofing&#10;C) Language&#10;D) Advanced

Accepted Answer

The correct option to select as X in the given series of clicks to set formulas for manual calculation is "Formulas". The series of clicks - File < Options < Formulas < Manual - will take you to the Advanced tab of the Excel Options menu where you can find the Calculation options. Under Calculation options, you can select "Manual" to set manual calculation for formulas.

Question 10

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?&#10;A) F5&#10;B) F9&#10;C) F10&#10;D) F12

Accepted Answer

Pressing F9 prompts Excel to recalculate all open workbooks manually.

Deck 13: Customizing Your Workspace Text and Graphics