Multiple choice test covering Excel 2007 data tables Pivot Tables and charts
Byte
Gig
Bit
Hertz
Kilobyte
Rate this question:
Sort by location ascending, then by salary ascending.
Sort by location ascending, then by salary descending.
Sort by salary descending, than by location ascending.
Sort by location descending, then by salary ascending.
Rate this question:
10
1000
256
8
64
Rate this question:
Insert a comment in the upper-left corner of the list.
Insert a blank row between the field names and the data.
Insert a blank row and a blank column between the list and other data in the sheet.
Type a row of dashes (---) after the last row of the list.
Rate this question:
The list is sorted by city, with New York first.
The rows where the location is New York are written to another worksheet.
The rows where the location is not New York are deleted.
The rows where the location is not New York are hidden.
Rate this question:
Sort by Sales, in ascending order.
Sort by sales, in descending order.
Sort by sales, in either ascending or descending order, then by Location.
Sort by Location, in either ascending or descending order.
Rate this question:
Branch office is the primary key and should be in ascending order.
Salary is the primary key and should be in descending order.
Salary is the primary key and should be in ascending order.
Branch office is the primary key and should be in descending order.
Rate this question:
Click the cell(s) you changed, and then use the Refresh PivotTable command.
Click the PivotTable, and then use the Refresh command.
PivotTables are automatically updated once you alter the data.
Once created, PivotTables cannot be updated.
Rate this question:
The field names must be entered in the forst row of the list.
The field names will change from record to record.
Each field name must be unique.
The fields will be in the same order in every record.
Rate this question:
Click the arrow next to the Sales Rep field and remove the employees name.
Make the emloyee's data points and axis titles invisible.
You can't delete the rep from the chart without first deleting the data.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.
Rate this question:
Have one column entry for the salary field, with >50000 in one row and
Have two column entries for the salary field, with >50000 in one column and
Have two column entries for the salary field, with >50000 in one column and
It is not possible to set up the criteria range to enable this.
Rate this question:
All managers in New York.
All managers regardless of location and all employees in New York.
All managers except those in New York.
All managers except those in New York and all New York employees
Rate this question:
HTML files
Database files.
ASCII files
Graphic files
Rate this question:
###########
The #REF! error message
A circular reference
The #DIV/0 error message
Rate this question:
File
Table
Record
Field
Range
Rate this question:
One
Two
Three
Unlimited
Rate this question:
You cannot accomplish what the question asks.
Sort the list by office, generate subtotals, resort by title, and then generate subtotals again. Use the COUNT summary function for both subtotals.
Sort the list by office, then by title and generate subtotals in both fields. Use the COUNT summary function for both fields.
Sort the list by office, then by ttle. Generate subtotals on the office field using the COUNT function. Generate subtotals on the title field using the COUNT field and then clearing the check box to replace the current subtotals.
You used an OR instead of an AND in your criteria range.
You have a blank row in the criteria range.
You have a blank row in the list.
You mistyped the field names in the criteria range.
Rate this question:
Edit Names comand
Go To command
View Names command
List Names command
Rate this question:
A
$
_
8
B
Rate this question:
Binary
HTML
ASCII
XML
Octadecimal
Rate this question:
File
Table
Database
Worksheet
Group
Rate this question:
Field
Group
Table
Query
Record
Rate this question:
Quiz Review Timeline (Updated): Apr 28, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Excel 2007 Intermediate Course Short Quiz
This short quiz for the Excel 2007 Intermediate Course assesses key functionalities such as formula calculation, cell operations, and data management. It verifies understanding of...
Questions:
13 |
Attempts:
427 |
Last updated:
Mar 17, 2023
|
Excel 2007 (Pre Test)
The 'Excel 2007 (Pre Test)' assesses user proficiency in using Excel 2007, covering topics like addition of rows and columns, Goal Seek, function syntax, chart updating, cell...
Questions:
15 |
Attempts:
118 |
Last updated:
Mar 11, 2024
|
Spreadsheet Styles, Themes And Tables Quiz #6
Spreadsheet Styles, Themes and Tables Quiz #6 explores Excel 2007 features like Quick Styles, Live Preview, and custom cell formatting. It assesses understanding of interface...
Questions:
14 |
Attempts:
127 |
Last updated:
May 01, 2024
|
Excel 2007 Advanced Post Test
The 'Excel 2007 Advanced Post Test' assesses advanced skills in Excel 2007, including data formatting, cell content rotation, and use of the AutoSum feature. It is designed to...
Questions:
15 |
Attempts:
289 |
Last updated:
Mar 20, 2023
|
2nd Yr MS EXCEL 2007
Some people have had computers with them but are still unable to make maximum use of the excel sheet. As a second year student you should by now know how to use Microsoft...
Questions:
39 |
Attempts:
422 |
Last updated:
Sep 05, 2023
|
Computer Applications- Microsoft Excel: Microsoft Excel 2007 Basics
Explore the fundamentals of Microsoft Excel 2007, including interface navigation with the Office Button, understanding cells, rows, and columns, and data entry techniques. This...
Questions:
15 |
Attempts:
600 |
Last updated:
Apr 18, 2023
|
Wait!
Here's an interesting quiz for you.