NEW
Font size
WorksheetsMicrosoft Excel 2019 Final Exam Review
Total questions: 41
Worksheet time: 21mins
Which of the following keyboard shortcuts will help you replace data?
Ctrl+F
Ctrl+G
Ctrl+H
Ctrl+R
The word Jan was entered in cell A1, Apr was entered in cell B1, and you then used AutoFill to automatically fill cells C1 and D1. What would cell D1 contain?
Oct
May
Jun
Jul
In which of the following tabs will you find the Insert Function command?
Home
Insert
Page Layout
Formulas
Where on screen will you find the Formula bar?
On the Formulas tab
In the Status bar
In the Title bar
Underneath the ribbon
Where will you find AutoSave?
On the ribbon
File > Save
File > Save As
The Quick Access Toolbar
To paste data so that the formula is removed leaving the result only, which Paste option would you use?
Transpose
Formulas
Values
Formatting only
Altering column widths to the exact size needed to display all the cell contents in that column is known as which of the following?
AutoFill
AutoFit
AutoCalculate
Automatic update
Most formatting options are available for use from which tab on the ribbon?
Page Layout
Insert
Home
Review
Which built-in cell style would you use to apply a dark green font color with a light green fill color to selected cells?
Title
Good
Calculation
Hyperlink
Which command can you use to hide column or row data that doesn't match the defined criteria?
Sort
Filter
Conditional Formatting
Custom Sort
Which of the following commands will clear all filters in a worksheet?
Home tab, Editing group, Clear Formats
Data tab, Sort & Filter group, Clear
Data tab, Sort & Filter group, Filter
Home tab, Editing group, Sort & Filter, Filter
What is the answer to the following calculation: 5+2*(20-10)/2?
65
35
15
20
Which of the following options specifies cell B5 as an absolute reference?
$B$5
#B#5
%B%5
(B5)
In the Function Library, which of the following categories will you find the MAX and MIN functions?
Logical
Financial
Math & Trig
Statistical
If sales are larger than $5,000 the salesperson receives a bonus of 10 percent of total sales; otherwise the salesperson receives a 2 percent bonus of sales. Which of the following formulas reflect this logical statement?
=IF(sales<5000,sales*2%,sales*10%)
=IF(sales<5000,sales*10%,sales*2%)
=IF(sales>5000,sales*2%,sales*10%)
=IF(sales>5000,sales*10%,sales*2%)
Cell A2 contains the text “apples are red.” Applying the function =PROPER(A2) would result in which of the following answers?
APPLES ARE RED
Apples Are Red
aPPLES aRE rED
apples are red
Using the Paste Values option allows you to change a workbook in what way?
Remove excess worksheets.
Insert hyperlinks to external files.
Replace functions with the actual data.
Change the case of text.
Which of the following chart types is useful for comparing individual values between a small set of data?
Bar chart
Column chart
Line chart
Pie chart
Which of the following options emphasizes differences in data by changing the appearance of cells based on criteria?
Conditional formatting
Data bars
Sparklines
Charts
Chart Title, Axis Title, Data Labels, and Data Table are all examples of ____________.
Chart elements
Quick Layouts
Quick Styles
Sparklines
How many tabs are there in the Page Setup dialog box?
2
3
4
5
Conditional formatting changes the ________________ of designated cells based on criteria.
content
appearance
formulas
relationship
If you add seven days to an existing date that was a Monday, using the WORKDAY function, and within those seven days, there's one national holiday, what is the resulting day of the week?
Monday
Tuesday
Wednesday
Thursday
If you use the Ctrl+; keyboard shortcut to enter data into a cell, what would Excel actually enter into the cell?
The current date and time
The current time
The current date
The current hour
If you enter 1 as the return type in the WEEKDAY function, what number represents a Monday?
1
2
3
4
Which function has the syntax (logical_test1, value_if_true1, logical_test2, value_if_true2…)?
Nested IF
AVERAGEIF
IF
IFS
In which group on the ribbon will you find Remove Duplicates?
Data Types
Data Tools
Text
Formula Auditing
Which tab in Excel Options allows you to set your error-checking rules?
Data
Proofing
Formulas
Advanced
What is the default Confidence Interval setting when creating a Forecast Sheet?
85%
90%
95%
100%
Which group on the ribbon contains Goal Seek and Scenario Manager?
Forecast
Data Tools
Queries & Connections
Get & Transform Data
To create a chart with a dual axis, what type of chart should you use?
Column chart
Combo chart
Line with markers chart
Area chart
Which of the following doesn't belong to the NPER function syntax?
Rate
Pmt
Pv
Value_if_true
Where can you find tools for working with macros, such as Record Macro and the Visual Basic command?
The Data tab on the ribbon
The Developer tab on the ribbon
The context menu in the worksheet
Excel Options
Which of the following allows you to run a macro after opening a workbook?
Enable Macros
Enable Content
Enable VBA
Allow Content
When you open a workbook with a macro, which of the following displays a security warning?
The Macro dialog box
The Excel status bar
The Visual Basic Editor
The Message Bar
PivotTables allow you to _______________ large amounts of data so that it's more easily evaluated and understood.
format
organize
clean
correct
What are the movable parts of a PivotTable?
Cells
Rows
Categories
Fields
What are the parts in a PivotChart that allow you to filter the PivotChart?
Slicers
Filters
Field Buttons
Expand/Collapse Buttons
When does AutoRecover save your work?
It saves every time you select the AutoRecover option.
AutoRecover saves at a timed interval set by the user
The option randomly saves your work depending on usage.
Your work will be saved every 100 keystrokes.
When protecting a workbook, which of the following isn't an option?
Always Open Read-Only
Encrypt with Password
Protect Workbook Structure
Check for Accessibility Issues
Which of the following is the first step in protecting a worksheet?
Identify those cells you want to allow others to edit
Access the Review tab.
Change the workbook to Read-Only status.
Select the Backstage view.
