Exam 13: Customizing Your Workspace Text and Graphics.(Digital Only).
Exam 1: Getting Started With Excel93 Questions
Exam 2: Formatting Workbook Text and Data58 Questions
Exam 3: Performing Calculations With Formulas and Functions37 Questions
Exam 4: Analyzing and Charting Financial Data47 Questions
Exam 5: Generating Reports From Multiple Worksheets and Workbooks27 Questions
Exam 6: Managing Data With Data Tools50 Questions
Exam 7: Summarizing Data With Pivottables39 Questions
Exam 8: Performing What-If Analyses22 Questions
Exam 9: Exploring Financial Tools and Functions5 Questions
Exam 10: Analyzing Data With Business Intelligence Tools25 Questions
Exam 11: Exploring Pivottable Design22 Questions
Exam 12: Developing an Excel Application60 Questions
Exam 13: Customizing Your Workspace Text and Graphics.(Digital Only).10 Questions
Exam 14: Introducing Power BI (Digital Only).3 Questions
Exam 15: Collaborating with Your Team.(Digital Only).53 Questions
Select questions type
You can repeatedly paste an item from the Office Clipboard as many times as you like.
Free
(True/False)
4.7/5
(41)
Correct Answer:
True
What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?
Free
(Multiple Choice)
4.8/5
(29)
Correct Answer:
A
To detect language automatically,you should select the Detect language automatically check box in the Language dialog box.
Free
(True/False)
4.8/5
(32)
Correct Answer:
True
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?
(Multiple Choice)
4.9/5
(35)
Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?
(Multiple Choice)
4.9/5
(33)
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?
(Multiple Choice)
4.9/5
(27)
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?
(Multiple Choice)
4.8/5
(42)
When you run the Spell Checker in a workbook,Excel automatically checks the spelling in all worksheets at once.
(True/False)
4.9/5
(29)
What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?
(Multiple Choice)
4.8/5
(40)
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.
(True/False)
4.9/5
(33)
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)