Explain Conditional Formatting.

Formats only cells that meet specific criteria

Explain the Filter function in Excel.

Extract a subset of data from original data.

How would you edit a macro or write macro code while working on an Excel worksheet?

Using the Visual Basic Editor in the Visual Basic Application.

What are the three syntax of a formula?

=SUM(A1:A5), (1) = (2) Function (3) Argument

Explain the difference between an Excel Workbook and an Excel Worksheet.

Workbook is the file; worksheet has cells, columns and rows

What is the purpose of PEMDAS (Please Excuse My Dear Aunt Sally)?

Order of operations for solving mathematical equations

Explain the Sort function in Excel.

Arranges data in alphabetical or numerical order; ascending or descending

studbud

Microsoft Excel Quiz

24 termsStudBud Administration675 plays

To introduce general concepts and functionality of the #Microsoft #Excel program.

Flashcards24 cardsFPractice quizPHost liveL

Questions 24

Answers

1
Explain Conditional Formatting.
Formats only cells that contains functions
Formats only cells that contains formulas
Cells are automatically formatted from styles group
Formats only cells that meet specific criteria
2
What is a chart considered that is in the same worksheet as its data?
Combined
Embedded
Targeted
Nested
3
What is an Excel chart displayed on its own sheet tab in an Excel Workbook?
Embeded Chart
Chart Sheet
Sheet Chart
Chart Table
4
Explain the Filter function in Excel.
Extracting a pie chart from original data.
Extract complete data from original data.
Extracting an embedded chart from original data.
Extract a subset of data from original data.
5
What is the default file extension for an Excel Workbook version 2016?
.xls
.xlss
.xlsx
.xltx
6
How would you edit a macro or write macro code while working on an Excel worksheet?
Using the Visual Basic Editor in the Visual Basic Application.
Using the Java Script Editor in the Visual Basic Application.
Using Microsoft Sharepoint application.
Using the HTML programming language for web development.
7
Compares values over time or categories horizontally.
Pie chart.
Column chart.
Bar chart.
Line chart.
8
What are the three syntax of a formula?
=SUM(A1:A5)
(1) = (2) Formula (3) Argument
(1)^ (2) Formula (3) Derivative
(1) = (2) Function (3) Argument
9
Summary report based on a selected cell range in worksheet displaying different views of data.
Name Range
Excel Table
Column Chart
Pivot Table
10
Miniature charts in a cell or range of cells that provides a visual representation of data.
Trendlines
Pie chart
Sparklines
Bar chart
11
Data can be entered in a worksheet in which two ways?
Labels and Functions
Labels and Values
Labels and Dates
Formatted and Values
12
Compares continuous trends over time.
Line chart.
Pie chart.
Bar chart.
Column chart.
13
Compares values over time or categories vertically.
Line chart.
Column chart.
Pie chart.
Bar chart.
14
Explain the difference between an Excel Workbook and an Excel Worksheet.
Workbook is the file; worksheet is the table
Workbook is the file; worksheet has cells, columns and rows
Workbook is the spreadsheet; worksheet is the table
Workbook has cells; worksheet has cells, columns, and rows
15
What is the purpose of PEMDAS (Please Excuse My Dear Aunt Sally)?
The random order of equations.
Order of operations for solving intense equations
Order of operations for solving mathematical equations
Order of operations for populating mathematical equations
16
Which options are considered valid formulas?
C7-A5
=Sum(A1:A5)
=A1+A2+A3+A4+A5
C7*A5/B2
17
What is the purpose of recording macros in an Excel worksheet?
To automate repetitive tasks.
To diffuse repetitive tasks.
To complicate repetitive tasks.
To automate infrequent tasks.
18
Name the three basic cell references.
Relative, Absolute, Mixed
Relational, Absolute, Mixed
Relative, Exact, Mixed
Relative, Absolute, Median
19
What are two ways data can be sorted?
Top to bottom; bottom to top
Ascending and Descending
Alphabetical and Numerical
Labels and Values
20
Explain the Sort function in Excel.
Arranges data in listing or numerical order; ascending or descending
Arranges data in alphabetical or numerical order; ascending or descending
Arranges data in bulleted or numerical order; ascending or descending
Arranges data in alphabetical or equal order; ascending or descending
21
Using the cell location of the result as part of the formula is considered?
Absolute Reference
Mixed Reference
Circular Reference
Relative Reference
22
In Excel, columns are represented by ___ and rows are represented by ___.
Vertical and horizontal
Landscape and portrait
Letters and numbers
Values and Labels
23
Compares series that make up a whole.
Column chart.
Bar chart.
Pie chart.
Line chart.
24
Where would you build a library of macros?
Macros-only workbook.
Macros-related workbook.
Macros-enabled workbook.
Macros-Excel workbook.

Microsoft Excel Quiz Flashcards | StudBud