Exam 1: Getting Started With Excel
Exam 1: Getting Started With Excel150 Questions
Exam 2: Formatting a Workbook150 Questions
Exam 3: Working With Formulas and Functions150 Questions
Exam 4: Enhancing a Workbook With Charts and Graphs150 Questions
Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts150 Questions
Exam 6: Managing Multiple Worksheets and Workbooks150 Questions
Exam 7: Using Advanced Functions and Conditional Formatting150 Questions
Exam 8: Developing an Excel Application150 Questions
Exam 9: Working With Financial Tools and Functions150 Questions
Exam 10: Performing What-If Analyses150 Questions
Exam 11: Connecting to External Data150 Questions
Exam 12: Expanding Excel With Visual Basic for Applications150 Questions
Exam 13: Managing Your Files150 Questions
Exam 14: Getting Started With Microsoft Office 2010150 Questions
Select questions type
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A group of worksheet cells
(Multiple Choice)
4.8/5
(34)
Text is truncated when the cell that it resides in is not wide enough to display all of it.
(True/False)
4.9/5
(36)
-Referring to the figure above,the intersection of each row and column is called a cell.

(True/False)
4.9/5
(35)
You can use the Go To dialog box to navigate to a specific worksheet.
(True/False)
4.9/5
(36)
The ____________________ bar displays the contents of an active cell.
(Short Answer)
5.0/5
(42)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A named operation that returns a value
(Multiple Choice)
4.8/5
(32)
An Excel worksheet can have a maximum of ____ columns in a worksheet.
(Multiple Choice)
4.8/5
(39)
You have three teenage children to whom you have given cellular phones.You wish to record the monthly statements for each child's phone usage in Excel because the children have been given an incentive to keep their yearly bill under $1000.00.Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?
(Essay)
4.8/5
(32)
The name of the active workbook appears in the status bar of the Excel window.
(True/False)
4.7/5
(34)
The ____ command gives you precise control in setting column widths and row heights.
(Multiple Choice)
4.7/5
(34)
To change the order of operations,enclose part of the formula in ____.
(Multiple Choice)
4.8/5
(32)
Sam now wants to find out how much money he will make on his largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.
(Multiple Choice)
4.9/5
(35)
Sam decides to rename his worksheet "Sam's Ceramic Business Worksheet" but he is unable to complete the word Worksheet because ____.
(Multiple Choice)
4.8/5
(39)
The formula bar displays the value or formula of the active cell.
(True/False)
4.8/5
(30)
Each cell is identified by a cell ____________________,which is its column and row location.
(Short Answer)
4.8/5
(28)
Showing 81 - 100 of 150
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)