NEW
Font size
S
M
L
XL
WorksheetsMicrosoft Excel 2019 Advanced
Total questions: 54
Worksheet time: 5hrs 30mins
Name
Class
Date
1.
Which of the following buttons in the Info portion of Backstage View opens a menu which contains the command to check for accessibility issues?
a)
Protect Workbook
b)
Check for Issues
c)
Browser View Options
d)
Password
2.
Which of the following tools can be used to inspect a document for hidden data and personal information?
a)
Document Inspector
b)
Accessibility Checker
c)
Compatibility Checker
d)
Conditional Inspector
3.
Which of the following file types should be chosen when saving a workbook as a template?
a)
Custom Office Template
b)
Excel Template
c)
Excel 97-2003 Workbook
d)
Compatibility Template
4.
Which of the following locations in the New portion of Backstage View should be clicked to view a workbook template you created?
a)
Business
b)
Personal
c)
Featured
d)
Design
5.
Which of the following types of form controls should Mark enter if he wants the control to run a macro when clicked?
a)
List box
b)
Spin button
c)
Check box
d)
Button
6.
Which of the following tabs must be present on the Ribbon to insert form controls?
a)
Form
b)
Control
c)
Data Form
d)
Developer
7.
Which of the following tools can be used to create a data form?
a)
Form Tool
b)
Form Wizard
c)
Form Genie
d)
Form Template
8.
Which of the following tabs contains the command to add a sparkline to a worksheet?
a)
File
b)
Home
c)
Insert
d)
Data
9.
Which tab on the Ribbon holds the command to open the formula view?
a)
Home
b)
Page Layout
c)
Data
d)
Formulas
10.
Which of the following is NOT a comparison operator?
a)
> greater than arrow
b)
< less than arrow
c)
>= greater than arrow, equal sign
d)
/ slash
11.
Which of the following tabs contains the commands to add a text box or shape?
a)
Home
b)
Page Layout
c)
Insert
d)
Formulas
12.
Which of the following is a feature which updates the web page each time a change is saved on the source worksheet or workbook?
a)
Publish to web
b)
Refresh
c)
AutoRepublish
d)
AutoComplete
13.
Which of the following is a workbook designed with a standard structure and format which makes it easier to capture, organize and edit information?
a)
Style set
b)
Layout
c)
Data sheet
d)
Form
14.
Which of the following can be added to a chart to show data trends?
a)
Text box
b)
Screenshot
c)
Trendline
d)
Formulas
15.
Which of the following form controls can be used to place related controls in one visual unit?
a)
Label
b)
Group box
c)
Button
d)
Check box
16.
Which of the following form controls could be used to turn on or off a value which indicates a choice?
a)
Label
b)
Group box
c)
Spin button
d)
Check box
17.
Which of the following is a small chart in the background of a worksheet cell which provides a visual representation of data?
a)
Mini-chart
b)
Sparkline
c)
Slicer
d)
Trend line
18.
Which tab holds the command to create a PivotTable?
a)
Home
b)
Developer
c)
Insert
d)
Page Layout
19.
Which of the following can be used to plot one or more data series on a secondary axis?
a)
PivotTable
b)
Dual-Axis chart
c)
Moving average chart
d)
Conditional formatting
20.
Which tab on the Ribbon contains the commands for importing information into Excel?
a)
Home
b)
Data
c)
Review
d)
View
21.
Which group contains the options to import data?
a)
Get External Data
b)
Connections
c)
Sort and Filter
d)
Data Tools
22.
Which of the following formulas adds together values greater than 5000 in cells C2 through C17?
a)
=SUMIF(C2:C17,“5000”)
b)
=SUMIF(C2:C17,“>5000”)
c)
=SUMIF(C2:C17,“<5000”)
d)
=SUMIF(C2:C17,“=5000”)
23.
Which of the following formulas counts the values in cells A1 through A17 which contain Mabry and Branding in cells B1 through B17?
a)
=COUNTIFS(“Mabry”,A1:A17,“Branding”,B1:B17)
b)
=COUNTIFS(A1:A17,“Mabry”,B1:B17,“Branding”)
c)
=COUNTIFS(A1,A17,“Mabry”,B1,B17,“Branding”)
d)
=COUNTIFS(B1:B17,“Mabry”,A1:A17,“Branding”)
24.
Which of the following formulas would return the last three characters found in cell A5?
a)
=RIGHT(text,A5,3)
b)
=RIGHT(A5,text3)
c)
=RIGHT(3,A5)
d)
=RIGHT(A5,3)
25.
To complete conversions, you should use which of the following functions?
a)
REFRESH
b)
CONVERT
c)
TRANSLATE
d)
UPDATE
26.
points to a specific cell and does not change when copied; includes dollar signs in the reference name
a)
Absolute Cell Reference
b)
Worksheets
c)
Workbook
d)
Text Data
27.
function used to perform operations or calculations
a)
Arguments
b)
Absolute Cell Reference
c)
Worksheets
d)
Workbook
28.
feature which updates the web page each time a change is saved on the source workbook or worksheet
a)
AutoRepublish
b)
Arguments
c)
Absolute Cell Reference
d)
Worksheets
29.
runs macros which perform a specific action when clicked
a)
Buttons
b)
AutoRepublish
c)
Arguments
d)
Absolute Cell Reference
30.
address of a cell indicating its column and row location
a)
Cell Reference
b)
Buttons
c)
AutoRepublish
d)
Arguments
31.
turns on or off a value which indicates a choice
a)
Check Boxes
b)
Cell Reference
c)
Buttons
d)
AutoRepublish
32.
tests whether conditions are true or false and makes logical comparisons between expressions
a)
Conditional Formulas
b)
Check Boxes
c)
Cell Reference
d)
Buttons
33.
provides a convenient way to enter or display one complete row of information in a range or table without scrolling horizontally
a)
Data Form
b)
Conditional Formulas
c)
Check Boxes
d)
Cell Reference
34.
range which contains the data to be displayed in the chart
a)
Data Source
b)
Data Form
c)
Conditional Formulas
d)
Check Boxes
35.
recognized formats for date and time values
a)
Date and Time Data
b)
Data Source
c)
Data Form
d)
Conditional Formulas
36.
function requiring two values, a date and the number of months which need to be added or subtracted
a)
EDATE
b)
Date and Time Data
c)
Data Source
d)
Data Form
37.
document designed with a standard structure and format which makes it easier to capture, organize and edit information
a)
Form
b)
EDATE
c)
Date and Time Data
d)
Data Source
38.
expression which returns a value
a)
Formula
b)
Form
c)
EDATE
d)
Date and Time Data
39.
view of workbook contents which displays formulas instead of resulting values
a)
Formula View
b)
Formula
c)
Form
d)
EDATE
40.
named operation which returns a value
a)
Function
b)
Formula View
c)
Formula
d)
Form
41.
puts related controls into one visual unit
a)
Group Boxes
b)
Function
c)
Formula View
d)
Formula
42.
identify the purpose of a cell or text box
a)
Labels
b)
Group Boxes
c)
Function
d)
Formula View
43.
displays options from which the user can choose
a)
List Box
b)
Labels
c)
Group Boxes
d)
Function
44.
contains both relative and absolute references
a)
Mixed Cell Reference
b)
List Box
c)
Labels
d)
Group Boxes
45.
numerical value which can be used in a mathematical calculation
a)
Number Data
b)
Mixed Cell Reference
c)
List Box
d)
Labels
46.
allows a single selection from a list of options
a)
Option Buttons
b)
Number Data
c)
Mixed Cell Reference
d)
List Box
47.
used to analyze, explore and present data
a)
Pivot Table
b)
Option Buttons
c)
Number Data
d)
Mixed Cell Reference
48.
address of a cell range based on its relative position
a)
Relative Cell Reference
b)
Pivot Table
c)
Option Buttons
d)
Number Data
49.
tiny charts in a worksheet cell which provide a visual representation of data
a)
Sparkline
b)
Relative Cell Reference
c)
Pivot Table
d)
Option Buttons
50.
increases or decreases a value such as a number, time or date
a)
Spin Button
b)
Sparkline
c)
Relative Cell Reference
d)
Pivot Table
51.
grid of rows and columns in which text and numbers are entered and results are calculated
a)
Spreadsheet
b)
Spin Button
c)
Sparkline
d)
Relative Cell Reference
52.
combination of letters, numbers and some symbols which form words and sentences
a)
Text Data
b)
Spreadsheet
c)
Spin Button
d)
Sparkline
53.
file used to store worksheets
a)
Workbook
b)
Text Data
c)
Spreadsheet
d)
Spin Button
54.
sheets containing formulas, functions, values, text and graphics which make up a workbook
a)
Worksheets
b)
Workbook
c)
Text Data
d)
Spreadsheet
Reset
