Microsoft Excel 2007 Analysis Trivia Quiz
Excel 2007 Analysis
- 1.The Insert Function dialog box tells you how to use functions.
- A.
True
- B.
False
- 2.The function arguments dialog box tells you how to use functions.
- A.
True
- B.
False
- 3.The ____________________ criteria filter requires that the records displaying begin with the specified text string.
- 4.In PivotTable terminology, the fields that you summarize are known as ______________ fields.
- 5.A(n) _______________ is a range of values that spans the vertical axis in a column chart.
- 6.If you want to use your PivotTable to combine items into groups, which of the following would not be true?
- A.
Items that appear as row labels cannot be grouped
- B.
Items that appear as column labels can be grouped
- C.
If items are dates, they can be grouped automatically using the Grouping dialog box
- D.
If items are numbers, they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu
- 7.A field name is also called a(n) _____________
- 8.The process of hiding certain records and viewing the ones you want is called ____________ your data.
- 9.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
- 10.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
- 11.With the Last Quarter criteria filter, quarters are defined as, for example_________.
- A.
April, May, June
- B.
March, April, May
- C.
May, June, July
- D.
March, April, May, June, July
- 12.When you designate a range as a(n) ______, Excel provides the same operations as are available for a structured range of data
- A.
Table
- B.
Catalogue
- C.
Index
- D.
Roster
- 13.You can create at most one Excel table in a worksheet
- A.
True
- B.
False
- 14.The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.
- A.
True
- B.
False
- 15.When you clear a filter, all filters in the worksheet are cleared
- A.
True
- B.
False
- 16.You can use a table's sizing handle to add columns or rows to a table
- A.
True
- B.
False
- 17.A(n)_____________________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
- 18.When you are in _________ mode, some keyboard shortcuts will work differently.
- 19.A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
- 20.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
- 21.
Item ______ in the figure indicates the fields you want to summarize.- A.
1
- B.
2
- C.
3
- D.
4
- 22.60%-Accent is an example of a cell _____.
- A.
Size
- B.
Style
- C.
Border color
- D.
Height
- 23.Removing the contents of a cell is known as ____ a cell.
- A.
Clearing
- B.
Emptying
- C.
Editing
- D.
Deleting
- 24.The amount of money being loaned is known as the _____.
- A.
Mortgage
- B.
Principal
- C.
Loan amount
- D.
Proposed principal
- 25.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
Related Topics
Recent Quizzes
Back to top