Skip survey header

Microsoft Office Specialist: Excel Expert

Enjoy the following 10 question quiz from TestOut.

1. You want to have one cell at the end of each row of a series of numbers show a line chart of the values preceding it (for example, cell Z5 should show a miniature line chart of the values from B5:Y5).

What should be used to accomplish this? *This question is required.
2. Creating one cell out of two or more selected cells in Excel is known as merging. When this is done — and more than one of the cells selected contains data — which data is kept? *This question is required.
3. What does pressing the Home key on the keyboard while working in an Excel worksheet accomplish? *This question is required.
4. What is the difference between the COUNT and COUNTA functions? *This question is required.
5. The active cell has a value of -92 in it and you choose to format the column in the Accounting format. How will this value now be displayed? *This question is required.
6. One big benefit of using Named Ranges in a large worksheet is the ability to quickly navigate to that cell/range by jumping to it from the Go To dialog box. That dialog box is accessed by pressing which key? *This question is required.

7. Which keyboard shortcut brings up the File > Save As dialog box?

*This question is required.
8. Which type of chart can be used to display trends in values with a continuous surface and a 3-D presentation? *This question is required.
9. What is the minimum number of unhidden worksheets that must exist in a workbook? *This question is required.
10. Which of the following will sum the values in cells D2 to D100 if the word “Tuition” appears next to them in column E? *This question is required.
This free quiz was provided by:



 
0%