Answer Options:
Go to.
Cell Finder
Cell Address Finder
Reference Checker
Answer: Go to.
Question: In addition to the ribbon, users can change the workbook view by using the formulas bar
Answer Options:
True
False
Answer: False
Question: Conditional Formatting is performed from which tab in Excel 2019?
Answer Options:
Home
Design
Page Layout
File
Answer: Home
Question: Which feature in Excel 2019 is used to navigate to the last cell of the worksheet?
Answer Options:
Go to Last
Find
Go To Special
Replace
Answer: Go To Special
Question: Which are three ways to create a new workbook in Excel 2019?
Answer Options:
Using an existing Template
Using the Excel Workbook Maker
Using an online Template
Create a Blank workbook from Scratch
Answer: Using an existing Template, Using an online Template, Create a Blank workbook from Scratch
Question: Tables are created in Excel 2019 from which tab?
Answer Options:
Insert
Home
Design
Page Layout
Answer: Insert
Question: Which function counts cells that are empty?
Answer Options:
COUNTBLANK
COUNTA
COUNT
Answer: COUNTBLANK
Question: Which tab do cell styles exist in?
Answer Options:
Home Tab
File Tab
View Tab
Answer: Home Tab
Question: What is the purpose of a total row for a table in Excel 2019?
Answer Options:
Provides a simple way for users to generate totals without having to write formulas.
Provides a simple way for users to generate totals by writing a formula.
Provides a simple way for users to write formulas.
Generates formulas automatically(?)
Answer: Provides a simple way for users to generate totals without having to write formulas.
Question: What are the three types of sparklines? Check all that apply.
Answer Options:
Line
Win Loss
Column
Answer: All of the above (Line, Win Loss, Column)
Question: Users can customize sparklines in Excel 2019 using which items? Check all that apply.
Answer Options:
Markers
Styles
Location
Formula
Answer: Markers, Styles
Question: What are types of conditional formatting in Excel 2019? Choose two answers.
Answer Options:
Gray Scale
Data Bars
Color Scales
Sparklines
Answer: Data Bars, Color Scales
Question: Users can use Convert to Range to button in the _________ tab to change a table in Excel 2019 to a normal cell range?
Answer Options:
Design
Insert
Table
Home
Answer: Design
Question: Users can configure sparkline styles and colors from which tab in Excel 2019?
Answer Options:
Design
Home
Page Layout
Insert
Answer: Design
Question: Paste Special is only used to paste which of the following? Check all that apply.
Answer Options:
Paste Values
Paste Formatting
Paste All
Paste Formulas
Answer: All of the above
Question: The Find and Select Feature in Excel 2019 is located in which tab on the ribbon?
Answer Options:
Home
Insert
Data
Review
Answer: Home
Question: Which data format in Excel 2019 treats text as text and numbers as numbers?
Answer Options:
General
Text
Number
Basic
Answer: General
Question: Which are three ways to rename a worksheet in Excel 2019?
Answer Options:
Move a worksheet over another worksheet and it inherits its name
Select a worksheet tab and type in a new name
Select a worksheet tab, click its Format drop-down menu under the Home tab, click Rename Sheet, and type in a new name
Right-click a worksheet tab, click Rename, and type in a new name
Double-click a worksheet tab and type in a new name
Answer: Select a worksheet tab and type in a new name, Select a worksheet tab, click its Format drop-down menu under the Home tab, click Rename Sheet, and type in a new name, Right-click a worksheet tab, click Rename, and type in a new name
Question: The user does not need to highlight data within an Excel worksheet in order to remove conditional formatting.
Answer Options:
True
False
Answer: True