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
A(n)________ is a vertical group of cells in an Excel worksheet.
Free
(Short Answer)
4.9/5
(47)
Correct Answer:
column
An outlined cell in a worksheet is the active cell.
Free
(True/False)
4.7/5
(36)
Correct Answer:
True
A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.
Free
(True/False)
4.9/5
(31)
Correct Answer:
True
Which of the following does not display to the right side of a selected chart?
(Multiple Choice)
4.8/5
(26)
The Sum button resides on both the Home tab and the Formulas tab.
(True/False)
4.7/5
(37)
The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.
(True/False)
4.8/5
(39)
To indicate a range,include a dash between the two cell references.
(True/False)
4.7/5
(41)
The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.
(True/False)
4.8/5
(29)
Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.
(True/False)
4.9/5
(38)
________ is the keyboard shortcut for the Spelling command.
(Multiple Choice)
4.7/5
(37)
If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.
(True/False)
4.8/5
(37)
AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.
(True/False)
4.9/5
(37)
A(n)________ is a graphic representation of data in a worksheet.
(Short Answer)
4.9/5
(39)
Showing 1 - 20 of 97
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)