MGSC V5
Which of the following functions counts the number of cells in a range that contain any data type, text, or numbers? o
?(Not "COUNTBLANK or COUNTIF" E2-108)
Which of the following appears when you move your pointer over the center of a cell?
?(Not "Move Pointer" E1-11)
What would you call a table added to the bottom of your chart that contains the values of each data series?
?(Not "source data" E3-175)
Which of the following is a true statement that might describe Solver? A) It solves a problem in reverse, starting with the desired answer. B) It is used to create and test new formulas. C) It starts with a problem and then finds a solution. D) all of the above.
A
Which of the following statements is not true about VBA? A) VBA is not a programming language. B) As you record a macro, Excel converts your keystrokes into VBA code. C) Code describes the specific programming commands required for an automatic task to run. D) Program and procedure are other names used for code.
A
Which of the following statements is not true about calculated fields?
A calculated field is a field in the source data.
An Access object you can use to create an interface to easily view, add, update, and delete data in a database is called:
A form
What happens when you try to save a workbook with macros as a regular Excel workbook?
A message reminds you that your VBA work cannot be saved in a regular workbook
Which of the following finds data in your database by allowing you to ask a question?
A query
An object you can use to create an organized and professional output of the data is called
A report
What can pie charts graph?
A single data series
Which of the following statements about circular references is false?
A workbook cannot be saved with a circular reference.
How does Excel treat criteria entered on the same row?
AND condition
A function that is used to define more than one condition that must be met for a true result
AND function
Which of the following calculates the average deviation of the absolute values in a range?
AVEDEV
A worksheet object that is similar to a form control but more flexible and robust
ActiveX Control
Which of the following is required before workbooks can be compared and merged?
All of the above
Which of the following statements is true about macro-enabled templates?
All of the above
Which of the following statements is true about saving macros?
All of the above
Insert the SUM function
Alt + =
Insert chart object
Alt + F1
Open the VBE window
Alt + F11
Which of the following must you press to enter a manual line break in a cell?
Alt+Enter
Which of the following is not true when using Goal Seek?
An absolute value is typed in the To value box.
When you run a macro that was recorded with absolute references, where should the cursor be before running the macro?
Anywhere in the worksheet
This chart displays the magnitude of change over time and shows the rate of change
Area
When you select a state abbreviation from a combo box, how does the form control record your selection?
As a number
When you insert a calculated field in a PivotTable, where is it initially placed?
As the last field
How many rows must the criteria range of an Advanced Filter have?
At least 2
Which of the following creates groups based on formulas that are located in a consistent pattern in data list?
Auto Outline command
Which of the following features resizes column width or row height to accommodate the width or height of the largest entry?
AutoFit
Which of the following is not an option on the PivotTable Tools Design tab?
AutoFit column widths on update
Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?
AutoNumber
What does an external reference formula create? A) a link to the destination workbook B) a link to the source workbook C) a hyperlink D) all of the above
B
Which of the following can you do right after you create a dynamic consolidation? A) collapse each outline item B) expand each outline item C) convert the outline to plain text D) delete the outline
B
Which of the following is not true about a new field name? A) It should be unique B) It is limited to 128 characters C) It can include letters, numbers, and most special characters. D) It cannot include a period, exclamation mark, accent grave, or square brackets.
B
Cell address changes when copied (Relative)
B2
Which of the following is not a constant in the formula =45*B3-7?
B3
The VLOOKUP and HLOOKUP functions contain an argument called range lookup that allows you to find an exact match to your lookup value without sorting the lookup table. If range_lookup is FALSE (for an exact match), the table_array does not need to be sorted. If TRUE or omitted, an approximate match is returned. So without sorting the lookup table, you may have a wrong result because Excel uses
Binary search
What name does Excel automatically assign to a new workbook that you open?
Book1
You can create a report from
Both tables and queries
By default, how does Excel align numeric entries in a cell?
Bottom right corner of a cell
Applies a feature to selected text
Button
Which of the following functions counts the number of cells in a range based on specified criteria?
COUNTIF
Which of the following displays the result of a formula?
Cell
In an XML file, which of the following characters encloses the tags?
Chevron braces <>
Occurs when a formula includes the cell address of the formula
Circular Reference
Which of the following methods do not return to the Excel worksheet from the VBE window?
Click Window on the toolbar and choose Microsoft Excel.
When typing entries for a data validation list in the Data Validation dialog box, what should you separate items with?
Commas
If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results?
Consolidate command
Unhide row
Ctrl + Shift + (
Complete an array formula
Ctrl + Shift + Enter
Any macro shortcut
Ctrl + Shift + any alphabetic character
Underline
Ctrl + U
Paste
Ctrl + V
Close
Ctrl + W
Cut
Ctrl + X
Redo
Ctrl + Y
Undo
Ctrl + Z
Toggle between formula view and results view
Ctrl + ~
Which of the following keyboard shortcuts opens the Format Cells dialog box?
Ctrl+1
Which of the following keystroke combinations completes a formula?
Ctrl+Enter
Which of the following is the keyboard shortcut for inserting a hyperlink?
Ctrl+K
Which of the following keystrokes are considered completion keys when executing functions as array formulas?
Ctrl+Shift+Enter
Which of the following keyboard shortcuts cuts cells or a cell range?
Ctrl+X
In macros, what are comment lines used for? A) describe the code B) show the shortcut C) separate sections D) all of the above
D
What happens when you click in a SmartArt shape and begin typing? A) The entry appears in the shape and in the text pane. B) The label is sized to fit the shape as you type. C) Each shape has its own selection handles and frame. D) all of the above
D
When importing data records from Excel, which of these must be true? A) The Excel file must have been created by the same user. B) The Excel file must contain the same number of fields as in the Access file. C) The Excel fine must be delimited. D) The first row of the Excel file must contain the field names from the Access table.
D
Which of the following can you sort Excel data by? A) text data B) number data C) cell fill color D) all of the above
D
Which of the following statements is true about editing and formatting grouped worksheets? A) When you group sheets, most editing commands that you perform affect every sheet in the group. B) When you group sheets, most formatting commands that you perform affect every sheet in the group. C) It is important that you carefully plan your commands for grouped worksheets. D) all of the above
D
Which of the following statements is true about protecting workbooks with a password? A) You can protect workbook structure with a password. B) You can protect workbook structure without a password. C) If you use a password, you must enter that password to remove the protection. D) all of the above
D
Which of the following statements is not true about importing data? A) Importing data refers to the task of obtaining data from another file format B) The delimiter in a text file is used to separate the data C) A tab could be a delimiter D) A text file in a compressed (zipped) folder could be imported via Text Import Wizard
D. A text file in a compressed (zipped) folder could be imported via Text Import Wizard
Which of the following authors is not one of the authors of our textbooks. A) Nordell B) Wood C) Easton D) Jelen
D. Jelen
Which of the following database functions counts cells in the field that are not empty that meet the criteria?
DCOUNTA
Which of the following database functions displays the largest value in the field that meets the criteria?
DMAX
The number values located on top of the bars in a column chart
Data Label
Displays a table of the values of each data series based on your selected source data cells
Data Table
Which of the following tabs provides information about your database and additional functions to help you manage the database?
Database Tools
Which of the following allows you to enter, modify, delete, or view data records?
Datasheet view
Which of the following is used to enter records into a table?
Datasheet view
Which of the following should you press to delete a selected chart element?
Delete
Which of the following is not a procedure to prepare a consolidation worksheet?
Delete formulas that will be used on the consolidated worksheet.
When you need to create a new table from scratch in your database, you go to
Design View
What must you click to display the Windows desktop, which is similar to previous versions of Windows?
Desktop App Tile
A new window that opens to display additional features
Dialog Box
Displays the various options available for a feature
Drop-down list
Places formulas on your consolidated sheet and formats that sheet as an outline
Dynamic Consolidation
A pop-up message that appears after an error is entered
Error alert message
Which of the following tools steps through each part of a formula and displays an outcome for each part so that an error can be isolated?
Evaluate Formula
How should you save a file if you want it to be compatible with older versions of Microsoft Excel?
Excel 97-2003 Workbook
Which of the following is not true when building date and time calculations?
Excel uses a 12-hour day in time calculations.
Help on VBE error
F1 + selected code
In Excel, which of the following keys opens the Save As dialog box?
F12
Edit mode (insertion point appears within the cell)
F2
Open Paste Name dialog box (insert range name)
F3
Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?
F4
Quickly inserts dollar signs
F4
Which of the following functions determines the future value of a series of payments at the same interest rate for a specified period of time?
FV function
Represents a column of data
Field
When you set field properties, the available properties vary based on the:
Field Data Type
The label in the header row
Field Name
When you limit entries to a certain range of values or making sure entries match a specified format, you use:
Field Validation Rules
Which of the following is not true when inserting a calculated field?
Field names display with double quotation marks.
Which of the following simplifies the process of entering the months of the year in a worksheet?
Fill Handle tool
Which of the following functions are helpful in limiting the number of records that display in your datasheet?
Filter
Which function category analyzes money transactions such as loans, bond purchases, depreciation, and mortgage amoritization?
Financial
The field in common between two tables is called the
Foreign Key
An object that you can use to execute commands or perform actions in a worksheet
Form Control
Allows you to copy formatting attributes and styles from one cell to another cell or group of cells
Format Painter
Properties that are embedded in the file such as the user name at time of creation, the original file location, the date and time, user comments, and more
Metadata
Another context menu that displays when you right-click text, a cell, or an object in your file
Mini Toolbar
If you want to analyze a field in a PivotTable as a value and as a ratio or percentage, how many times can you add the field in the Values area?
Multiple times
This function returns a number that corresponds to the system date and time beginning with January 1, 1900
NOW
A function within a function
Nested Function
How does Excel treat criteria entered on different rows? A) AND condition B) OR condition C) FILTER condition D) BOTH condition
OR condition
A cell with a formula that has your desired result
Objective cell
Which of the following is not a function listed in the Consolidate dialog box?
PMT
Adjusts breaks within your workbook using the drag and drop technique
Page Break Preview
Which of the following Page Setup options lets you change the orientation of a worksheet to Portrait or Landscape?
Page Layout
Which of the following views lets you apply headers and footers and view the layout of the spreadsheet prior to distribution?
Page Layout view
What are the three Solver components known as?
Parameters
Which of the following is the default paste option?
Paste
This chart uses one data series to display each value as a percentage of the whole
Pie
his chart displays comparisons among individual values at a specific period of time
Pie
Which of the following is not a True statement?
Pie charts do not have Quick Layouts and Quick Styles.
Which of the following is a cross tabulation report based on list-type data?
PivotTable
What should you do before you begin to record a macro?
Practice what you want to do.
Which of the following contains a unique value for each record?
Primary Key
Which of the following buttons open the Format Control dialog box?
Properties
Located above the Ribbon on the upper left of each Office application window; contains buttons you can use to apply commonly used features such as Save, Undo, Redo, and Open
Quick Access Toolbar
Which of the following print options sends the contents of the current object immediately to the printer?
Quick Print
In an AND function, if the argument is text, what should you enclose the text in?
Quotation Marks
This chart displays a frequency of multiple data series relative to a center point
Radar
Each row of data
Record
Which of the following groups all sheets in a workbook?
Right-click any sheet tab and choose Select All Sheets
Which of the following ungroups all sheets in a workbook?
Right-click any sheet tab and choose Ungroup Sheets
To see the results of a query you need to click
Run
This function adds or totals cells only if they meet the specified criteria
SUMIFS
To select part of a window or screen for a screenshot, which of the following options should you select from the illustrations gallery?
Screen Clipping
To select adjacent worksheets, which key must you press?
Shift
Insert Worksheet
Shift + F11
Open Insert Function dialog box
Shift + F3
An advanced analysis tool that finds the highest, lowest, or specific result for a formula by changing the values in other cells within the limitations that you set
Solver
Which of the following should you use to perform a multiple column sort?
Sort dialog box
Miniature charts displayed in a cell or cell range with your data
Sparklines
This form option lets you view data in two ways on the same form by combining both a columnar display and a datasheet display
Split Form
Have both a button you click to apply a feature and an arrow you click to display a drop-down list of options
Split buttons
Measures how broadly values deviate from the mean or average value in the range
Standard Deviation
This chart displays three series of data to show fluctuations in stock prices from high to low to close
Stock
Which of the following functions uses a lookup table that is organized in columns?
VLOOKUP
The rules applied to data as it is entered
Validation settings
The code behind a macro is written in a programming language that is often referred to as
Visual Basic for Applications
Which of the following statements is not true about screenshots?
When capturing an image from a web site, it is not necessary to obtain permission from the author of the web site.
Which of the following is not a true statement?
When you use the point method to create an external reference, it is built with mixed references.
By default, how is a macro recorded?
With absolute references
Enables you to display the contents of a cell on multiple lines
Wrap Text
Which of the following commands lets you display a label on multiple lines within a cell?
Wrap Text
Where does Excel automatically save and store the Personal Macro workbook?
XLSTART folder
This chart displays relationships among numeric values in two or more data series
XY
Which of the following statements is not True
You can create a combination chart from the Home tab.
Which of the following statements is not True?
You can hide a worksheet even if there is only one sheet in the workbook.
Which of the following is not true when assigning a macro to a button?
You can resize a button, but you cannot move the button.
Which of the following is true of adding conditional formatting to a report?
You can select multiple fields and apply the same rule to all selected fields.
Which of the following statements is not true about using the SmartArt Tools tabs?
You cannot change to a different image.
Which of the following statements concerning invalid data is not true?
You cannot set validation after data is already entered.
Which of the following symbols must you use when defining a parameter query?
[ ]
When worksheets are grouped, what displays in the title bar?
[Group]
What is Microsoft SharePoint?
a family of products that allows for collaboration and simultaneous work by groups of people via the Internet
When linking workbooks using a formula, what type of link is created?
a link to the source workbook
Which of the following can you apply after you select a chart element?
all of the above
Which of the following can you sort Excel data b
all of the above
Which of the following guidelines will make your tables easier to use and navigate?
all of the above
Which of the following statements is true about Highlight Cells Rules?
all of the above
Which of the following terms relate to VBA?
all of the above
As long as a workbook is open, where are the macros available?
any open workbook
When you select a state abbreviation from a combo box, how does the form control record your selection?
as a value
How many rows must the criteria range of an Advanced Filter have?
at least 2
Which of the following is a horizontal or vertical boundary that identifies what is plotted?
axis
When is the best time to set data validation?
before data is entered
By default, how does Excel align text in a cell?
bottom left corner of a cell
Which of the following grouping options would you want to use to group records by the first character of a field?
by partial value
Which of the following gets its value from a calculation instead of a value that is entered into a field?
calculated field
Which of the following is a complete set of elements that is displayed in a chart?
chart layout
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes what is going on with this formula?
circular reference
Which of the following occurs when a formula includes the cell address of a formula?
circular reference
What must you do to change the row height of a table?
click and drag the row border
Which of the following should you do to the database file when you are finished working on it?
close
Which of the following can you add to a form to automate user tasks?
command button
Which of the following statements is not true for comments?
comments print by default
Which of the following is data that is the same in each query and allows for a relationship between queries?
common field
Which of the following summarizes data from multiple worksheets using a mathematical or statistical function?
consolidated worksheet
Which of the following is a separate summary sheet in a workbook?
consolidation worksheet
In Access, what are the fields, labels, and buttons called?
controls
What would you call the number values located on top of the bars in a column chart?
data label
Which of the following is a single value or piece of data from a data series?
data point
Which of the following terms refers to a group of data points or values?
data series
What are data records displayed in
datasheet
When creating a consolidation worksheet, what must you do to the range of cells to be consolidated?
delete the contents
Which of the following words best describes a Z to A sort?
descending
In addition to selecting the rule type and conditions, what else must you select when building a rule?
desired formatting
Which of the following activates edit mode?
either pressing F2 or double-clicking a cell
Which of the following can you do immediately after you create a dynamic consolidation?
expand each outline item
In a table, which of the following must be identified as the primary key?
field
Which of the following represents an individual column in a text file?
field
In Access, which of the following is used to relate, or connect, tables?
fields
Which of the following lets you refine which data is displayed in a chart?
filter
What must be added into a table before relationships between two tables can be established?
foreign key
Which of the following options in the Totals category of the Group, Sort, and Total pane determines which section displays the totals?
show in header or footer section
Which of the following displays in the upper right corner of a cell after a comment has been added?
small red triangle
Which of the following must you do for the Subtotal command to work?
sort the rows by the field to be totaled
Which of the following includes data that is referenced in a dependent workbook?
source workbook
Which of the following is not an example of SmartArt objects?
text effects
Which of the following is a document that includes basic data, no formatting, and commas or other characters to separate the data into fields?
text file
Which of the following can't be added to the Info pane in the Backstage view of a Microsoft Excel file?
timing
Which of the following is added to the design grid of a summary query?
total row
Which of the following is not true when creating an error alert?
type a required titlr
What does Access call a form that doesn't have a connection to a data source?
unbound form
When troubleshooting a macro, which of the following should you do if the workbook is protected?
unprotect the workbook
Which of the following are the rules applied to data as it is entered?
validation settings
By default, how is a macro recorded
with absolute references
Open a new blank workbook
Ctrl + N
Open existing workbook from backstage view
Ctrl + O
Ctrl + P
Next Worksheet
Ctrl + Page Down
Previous Worksheet
Ctrl + Page Up
Save
Ctrl + S
Which of the following is the constant in the formula =D5*85%?
85%
Which of the following field validation rules prevents the user from typing 0 into a field?
<> 0
Which of the following is not used as an identifier in formulas?
=
Which of the following formulas correctly adds the values in cells E4 and E5?
=E4+E5
The correct syntax for the IF function
=IF(C5<50, TRUE, FALSE)
Which of the following shows the correct syntax for the NPV function?
=NPV(rate,value1,value2,...)
If APR in the cell C8 is 6.5% and Loan Term in the cell F4 is 7 year, which of the following is the right formula using PMT function?
=PMT(C8/12,F4*12,Loan_Amount)
Which of the following shows the correct syntax for the REPLACE function?
=REPLACE(old_text,start_num,num_chars,new_text)
Which of the following displays in a cell when you click AutoSum?
=SUM ()
Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?
? (Not " Between #10 and 20#")
When using the NPV function, which of the following statements is not true?
? (Not " For a year with neither a positive or negative cash flow, type a zero (0) for the ValueN argument.")
When printing, what are Excel's default top and bottom margin settings?
? (Not "1" E1-50)
Which of the following keyboard shortcuts opens a new blank workbook?
? (Not "Ctrl + O" E1-3)
Which of the following is not accomplished using the Query Tools tab?
? (Not "Edit a query")
Which of the following is a color-coded editing tool that applies different colors to each cell or cell range within a formula?
? (Not "Evaluate Formula" E2-89)
Which of the following functions assumes that cash flows occur at the end of each period?
? (Not "FV Function") E6-383
Which of the following features displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells?
? (Not "Formula Autocompleteor Formula Auditor" E2-110)
Which of the following is a true statement that might describe Solver?
? (Not "It solves a problem in reverse, starting with the desired answer.")
Which of the following functions can be formatted to show both the current date and time?
? (Not "NOW" E2-111)
Which of the following shows a preview of data that will be imported when building a query for a database table?
? (Not "Query Editor or Query Settings Pane")
Which of the following Page Setup options lets you set margins for headers and footers?
Margins
Illustrates an accurate statistical analysis of forecasting errors
Mean absolute deviation
Which of the following is not true when typing text in a shape?
? (Not "Text appears in the shape and in the text pane." E5-311)
When using the NPV function, which of the following statements is not true?
? (Not "The NPV function has two required arguments." E6-383)
Which of the following statements is False?
? (Not "There is no default color to sheet tabs." E1-38)
Which of the following criteria can you use to sum sales for all items that begin with the letter p?
? (Not "[*"p]" E2-124)
In the Design grid, what must you delete in order to delete a field?
? (Not "none of the above")
Which of the following statements is True?
? Not " Adding a series to the data source changes the data range in the worksheet." E3-178
Which of the following statements is true?
? Not "Consolidation by category is neither static nor dynamic." E5-298
Which of the following is a visual filter for a date field in a PivotTable?
? Not "Number Filters" E8-524
What must you do to enter a number as a label in a cell?
Type an apostrophe before the number.
Before using the Merge & Center command, what cell should contain the data?
Upper-left cell
A programming language that allows you to expand the abilities of Excel
VBA
Which of the following runs in a window that is separate from Excel?
VBE
Which of the following encompasses all of the other items?
shape style
When you run a macro that was recorded with absolute references, where should the active cell be before running the macro?
? Not "in a specific starting location")
Move to cell A1
Ctrl + Home
Italics
Ctrl + I
Which of the following is a set of predefined formatting you can apply to titles, subtitles, column headings, row totals, and other areas of your worksheet?
? (Not "worksheet style" E1-26)
Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?
#
Which of the following wildcard characters matches any single numeric digit?
#
Displays when cells are not wide enough to display the entire entry
#####
Which of the following error values indicates that the formula divides by zero (0) or an empty cell?
#DIV/0!
A value or an argument is missing
#N/A
Which of the following error values indicates that the formula refers to an intersection of two cell ranges that do not intersect?
#NULL!
Which of the following error values indicates that the formula uses an invalid numeric entry?
#NUM!
A cell reference is empty, usually because cells were deleted
#REF!
An incorrect data type is used (i.e. a label is used instead of a value)
#VALUE!
The cell address does not change when copied (Absolute)
$B$2
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
$F$2
Contains a column reference that is absolute and a row reference that will change when copied (Mixed)
$F2
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
$F2
Which of the following is a valid 3D cell reference?
'Inventory#'!$B2
How does Access store a "Yes" response for the Yes/No data type?
-1
How does Access store a Yes response for the Yes/No data type?
-1
In the MATCH function, which of the following match_type arguments finds the smallest value that is greater than or equal to the lookup_value?
-1
Access Database file type
.accdb
Access Template file type
.accdt
Word Document file type
.docx
Word Template file type
.dotx
PowerPoint Template
.potx
PowerPoint Presentation file type
.pptx
Rich Text Format file type
.rtf
Excel Workbook file type
.xlsx
Excel Template file type
.xltx
Which of the following XML file extensions is for files that provide data scheme information?
.xsd
Which of the following extensions does Excel assign to templates?
.xtlx
In the MATCH function, what Match_type argument finds the first value that exactly matches the lookup_value?
0
In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value?
0
In the MATCH function, what MATCH_type argument finds the largest value that is less than or equal to the lookup_value?
1 or omitted
Which of the following has an answer of 4?
10-(3*2)
Which of the following has an answer of 14?
2+4*3
In OR functions and AND functions, how many LogicalN arguments can you use?
255
The default size of a Short Text field is
255 characters
How many types of reports can you create using the Solver Results dialog box?
3
Which of the following is a valid criterion for the Currency data type?
5
Insert a hyperlink
Ctrl + K
Displays when you right-click text, a cell, or an object such as a picture, drawing object, chart or SmartArt
Context Menu
Which of the following tabs do you use to create a query?
Create
To select non-adjacent worksheets, which key must you press?
Ctrl
Which of the following is always the first key in a macro shortcut?
Ctrl
Insert dialog box (cell ,row, or column)
Ctrl + (+)
Hide column
Ctrl + 0
Open Format Cells dialog box
Ctrl + 1
Hide Row
Ctrl + 9
Select all files in a folder
Ctrl + A
Display your worksheet in formula view
Ctrl + ACCENT MARK
Bold
Ctrl + B
Copy
Ctrl + C
Manual line break in a cell
Ctrl + Enter
Open an existing workbook from the Open dialog box
Ctrl + F12
Switch to an open workbook
Ctrl + F6
Which of the following is helpful for inserting formulas and editing data?
Formula bar
Which of the following statements is not True?
Formulas are case sensitive
Prevent column and row headings from scrolling off the screen
Freeze Panes Command
Which of the following commands should you use to prevent column and row headings from scrolling off the screen?
Freeze Panes Command
Displays a collection of option buttons
Gallery
Finds a solution for one of the arguments in a formula
Goal Seek
First row of the table with descriptive titles or labels
Header Row
Which of the following functions displays a specific, custom error message?
IFERROR
Which of the following functions displays the combo box result in a worksheet cell?
INDEX
This function displays the contents of a cell at the intersection of an identified column and row
INDEX Function
Which of the following comparison operators means "contained in this list of values"?
In
Which of the following cannot be performed when worksheets are grouped?
Insert a graphic
Where is the Take a Screenshot command located?
Insert tab, Illustrations group
When entering a criterion expression, which of the following tools helps suggest a list of possible values?
IntelliSense
Which of the following statements is not True?
It is best to name a range with a cell reference such as A7.
Which of the following statements about arrays is false?
It is not possible to use more than two arrays in a formula.
Which of the following statements is not True?
It is possible to change some bar charts into column charts, but not all.
What is true of a workbook that is opened or copied from an online source?
It will open in Protected View.
Which of the following paste options is the same as the "Paste" option?
Keep Source Formatting
Use to quickly apply formatting or perform actions
Keyboard Shortcut
Which of the following input mask characters requires a user to enter a letter?
L
Which of the following functions retrieves a value from a range or table of cells located in another area of the worksheet?
LOOKUP
In this view, you can alter the design of a form and see the effects of the changes in real time
Layout View
When you use wildcards in Field Validation rules, which of the following wildcard combinations could not achieve "Sunny" as valid input?
Like "S####"
This chart displays trends in data over time
Line
Which of the following displays a list of data values from which the user can choose?
Lookup field
Small recorded programs that carry out routine, repetitive tasks
Macro
Which of the following lets you create your own conditional formatting rule as well as edit existing rules?
Manage Rules command
This function automatically inserts the date
TODAY
Which function displays columnar data in rows and vice versa?
TRANSPOSE
This report layout displays the fields in a table (row and column) format
Tabular
An identifier such as <customer>
Tag
Opens on the left or the right of the Office application window
Task Pane
When creating a cell hyperlink, which of the following is not true when selecting a Place in this Document option?
The Cell Reference and Defined Names groups cannot be expanded.
Which of the following statements about the Developer tab and the Form button are not true?
The Developer tab is displayed on the Ribbon by default.
For a 1:M relationship, you create the foreign key in _______ generally.
The M table
Which of the following statements is true about the Subtotal command?
The Subtotal command is in the Outline group on the Data tab.
Which of the following statements is not true about the Use Relative References button
The Use Relative References button is shaded when it is off.
What is selected when you click the button located above the row 1 heading and to the left of the column A heading?
The entire worksheet
Which of the following is a true statement about foreign keys?
The foreign key field is always the primary key of another table.
Which of the following statements is not True?
The top and bottom margin settings must be less than the header and footer values or the worksheet data prints over the header and footer text.
How many arguments do all database functions have?
Three (database, field, and criteria)
Which of the following use ranking or averages to format cells?
Top/Bottom Rules
Which of the following is not a Report Layout for a PivotTable?
Totals and Filters form
Displays arrows that point to the cells that contain a formula
Trace Dependents
Which of the following Formula Auditing tools displays arrows to all cells that use the active cell directly or indirectly in a formula?
Trace Dependents
Displays arrows that point to the cells referenced in the selected formula
Trace Precedents
A chart element that demonstrates averages in your data and that can be used to forecast data by plotting future approximate averages
Trendline
In an Excel table, which of the following contains descriptive titles or labels?
header row
Which of the following is a character such as an exclamation point that marks or signifies a component of an external reference?
identifier
Which of the following refers to the task of obtaining data from another software program or another file format?
importing data
When a macro runs, where does it carry out its commands or enter data?
in the current workbook
Which of the following increases the distance between the cell contents and the left boundary of a cell?
indent
When modifying a form, which of the following views is best when you want to resize a field or label, change colors or text alignment, or apply different formats?
layout view
Which of the following criterion will search for songs with the title of "Love for All Seasons", "Love This Pain", and "Love Will Find a Way"?
like "love*"
Where is a macro stored?
module
In a two-variable data table, where do the row input values start?
one column to the right of the column values and one row above the first column value
Which of the following relationships describes one row of data in Table A associated with many rows of data in Table B?
one-to-many
Where are a report's title, the current date, and page numbers typically placed in a report?
page header and page footer areas
Which of the following would you change in order to view a report using a landscape orientation?
page orientation
Which of the following is a field that contains a unique value for each record?
primary key
Which of the following describes the section of the worksheet that prints?
print area
Which of the following is used to find data in a database?
query
In an Excel table, which of the following represents a row of data?
record
What should you do before creating a new scenario in Excel?
save the current data in a worksheet as a scenario
Which of the following is a saved set of values in a worksheet?
scenario
Which of the following appears when you move your pointer over the center of a cell?
selection pointer
