Exam 1: Excell: Creating a Worksheet and Charting Data
Exam 1: Introduction to Microsoft Office 2016 Features90 Questions
Exam 1: Excell: Creating a Worksheet and Charting Data97 Questions
Exam 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks90 Questions
Exam 3: Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools79 Questions
Exam 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets99 Questions
Exam 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering98 Questions
Exam 6: Excell: Creating Charts, Diagrams, and Templates100 Questions
Exam 7: Excell: Creating Pivottables and Pivotcharts91 Questions
Exam 8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas96 Questions
Exam 9: Excell: Using Macros and Visual Basic for Applications97 Questions
Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables96 Questions
Exam 11: Excell: Collaborating With Others and Preparing a Workbook for Distribution95 Questions
Select questions type
You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.
(True/False)
4.9/5
(36)
Auto Fill generates and extends a series of value into adjacent cells in a worksheet.
(True/False)
4.9/5
(32)
Sparklines are tiny charts located within a cell that provide a visual trend summary of data.
(True/False)
4.9/5
(37)
Text or numbers located in a cell in a worksheet are referred to as ________.
(Short Answer)
4.9/5
(34)
The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.
(True/False)
4.7/5
(35)
Which of the following is the default number format in Excel 2016?
(Multiple Choice)
4.8/5
(26)
________ is the term for specifying the appearance of cells and overall layout of a worksheet.
(Short Answer)
4.9/5
(24)
________ is a procedure that determines which digit to the right of a number will be the last to be displayed.
(Multiple Choice)
4.8/5
(37)
The spelling checker in Excel performs similarly to other Microsoft Office programs.
(True/False)
4.9/5
(35)
The default number format for cells is the ________ number format.
(Multiple Choice)
4.7/5
(29)
When a cell is part of an active formula,it is surrounded with ________.
(Multiple Choice)
4.8/5
(30)
The shortcut key for accessing the Spelling command is ________.
(Short Answer)
4.8/5
(37)
When you type in a cell and the cell to the right contains data,the text in the cell to the left is truncated.
(True/False)
4.7/5
(30)
Showing 61 - 80 of 97
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)