Exam 1: Creating a Worksheet and a Chart
Exam 1: Creating a Worksheet and a Chart49 Questions
Exam 2: Formulas,functions,and Formatting36 Questions
Exam 3: Working With Large Worksheets, charting, and What-If Analysis64 Questions
Exam 4: Financial Functions, data Tables, and Amortization Schedules20 Questions
Exam 5: Working With Multiple Worksheets and Workbooks37 Questions
Exam 6: Creating, sorting, and Querying a Table62 Questions
Exam 7: Creating Templates, importing Data, and Working With Smartart, images, and Screenshots50 Questions
Exam 8: Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers57 Questions
Exam 9: Formula Auditing, data Validation, and Complex Problem Solving30 Questions
Exam 10: Data Analysis With Power Tools and Creating Macros60 Questions
Exam 11: User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel74 Questions
Select questions type
To print worksheet contents across the length of a page,you can use portrait orientation.
Free
(True/False)
4.8/5
(34)
Correct Answer:
False
When you double-click a cell's right column border,which of the following occurs?
Free
(Multiple Choice)
4.9/5
(20)
Correct Answer:
D
On which tab and button are document properties located for editing?
Free
(Multiple Choice)
4.8/5
(29)
Correct Answer:
A
Your worksheet is too wide to fit on one portrait page.What is the best way to fix this problem?
(Multiple Choice)
4.7/5
(38)
Which of the following is the temporary Windows storage area that holds selections you copy or cut?
(Multiple Choice)
4.9/5
(35)
Which of the following lets you search for a function or select one from a category?
(Multiple Choice)
4.9/5
(30)
You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.
(True/False)
4.9/5
(29)
Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?
(Multiple Choice)
4.9/5
(32)
If you discover an error immediately after you have confirmed a cell entry,what of the following would you use next?
(Multiple Choice)
5.0/5
(38)
You can use the I-beam pointer to copy cell contents into adjacent cells.
(True/False)
4.8/5
(30)
To see a preview of how a pasted value will look,which of the following would you use?
(Multiple Choice)
4.9/5
(25)
To combine multiple cells into one combined cell,which of the following do you use?
(Multiple Choice)
4.9/5
(34)
Where can you see a preview of how your worksheet will look when printed,including headers?
(Multiple Choice)
4.8/5
(32)
To select a single worksheet cell so you can work with it,which of the following would you do?
(Multiple Choice)
4.9/5
(30)
Which of the following functions would you use to calculate the arithmetic mean of a price list?
(Multiple Choice)
4.9/5
(38)
You can edit cell contents in the Formula bar or in the cell itself.
(True/False)
4.9/5
(35)
To fit all worksheet content on one page,you can set page scaling in Backstage view.
(True/False)
4.9/5
(43)
To return cell contents to its default font and style,you can use the _____ command.
(Multiple Choice)
4.9/5
(40)
Showing 1 - 20 of 49
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)