Excel 2007 Advanced Post Test
15 Questions
| Total Attempts: 189
Questions and Answers
- 1.Once you hide a row, it remains hidden as long as the workbook is active.
- A.
True
- B.
False
- 2.When a worksheet is printed, the grid lines that surround the cells are printed by default.
- A.
True
- B.
False
- 3.You can rotate cell contents in Excel so that they appear at any angle or orientation.
- A.
True
- B.
False
- 4.After you merge a range into a single cell, you can't realign its content.
- A.
True
- B.
False
- 5.Formatting changes only the appearance of data- it does not affect the data itself.
- A.
True
- B.
False
- 6.The ____ button is equivalent to using the sum button.
- A.
COUNT
- B.
ADD
- C.
AutoSum
- D.
AddSum
- 7.Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
- A.
True
- B.
False
- 8.After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry
- A.
Shift
- B.
Tab
- C.
Esc
- D.
Alt
- 9.You use ______ filters to find all objects with a value greater than X or acquired after a certain date
- A.
Custom
- B.
Criteria
- C.
Index
- D.
Pivot
- 10.You can create at most one Excel table in a worksheet
- A.
True
- B.
False
- 11.When you clear a filter, all filters in the worksheet are cleared
- A.
True
- B.
False
- 12.To sort data in an Excel worksheet you can use the ______.
- A.
Sort A to Z and Sort Z to A buttons
- B.
QuickSort Options
- C.
Sort command on the Formulas tab
- D.
Any of the above
- 13.An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
- A.
True
- B.
False
- 14.Put the following five steps in the order in which you would perform them to use the Paste Special function: 1. Select and copy a range 2. Click the Paste button arrow in the Clipboard group 3. Specify exactly what you want to paste 4. Click Paste Special to open the dialog box 5. Select the range where you want to pase the Clipboard contents
- A.
1, 2, 4, 3, 5
- B.
1, 2, 4, 5, 3
- C.
1, 5, 2, 4, 3
- D.
1, 5, 2, 3, 4
- 15.The Paste Options button allows you to________.
- A.
Keep source formatting
- B.
Copy formatting only
- C.
Copy values only
- D.
All of the above
Otherwise known as excel spreadsheets, this is a one of the complex computer packages to learn and master, especially the advanced part of it. The ability to do math and calculations using excel makes it confusing. Test your...
Questions: 50 | Attempts: 3101 | Last updated: May 18, 2021
-
Sample Question_______ tab, in the Editing group, click Find & Select, and then click Go To.
Knowledge Excel Level 3 (Advanced)
Questions: 10 | Attempts: 692 | Last updated: Feb 28, 2013
-
Sample QuestionHow many conditions can the sumif check for?
Questions: 22 | Attempts: 6041 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Back to top