MGSC 290 Final Review
Which of the following error values indicates that a cell refernce is empty, usually because cells were deleted? a. #N/A b. #VALUE! c. #REF! d. #DIV/0!
#REF!
Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied? E) F2 F) $F$2 G) $F2 H) F$2
$F2
Which of the following provides an example of a mixed reference? a. R4 b. $R4 c. $R$4
$R4
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? a. 1 or omitted b. 0 c. -1
-1
When you run a macro that was recorded with absolute references, where should the cursor be before running the macro? A) anywhere in the worksheet B) in a specific starting location C) in cell A1 D) anywhere below row A
Anywhere in the worksheet
When you insert a calculated field in a PivotTable, where is it initially placed? A) as the first field B) at the current cell C) as the last field D) below the table range
As the last field
What do trendlines demonstrate? A) totals B) averages C) maximum values D) none of the above
Averages
What name does Excel automatically assign to a new workbook that you open? A .Book1 B. Sheet1 C. Workbook1 D. Worksheet1
Book1
You can create a report from ________. A) Only tables. B) Only queries. C) A relationship between tables. D) Both tables and queries.
Both tables and queries
Which of the following functions would enable you to count the number of on-site visits made by a particular sales representative? A) REPLACEIFS function B) AVERAGEIFS function C) COUNTIFS function D) SUMIFS function
COUNTIFS function
Which of the following is a set of predefined formatting you can apply to titles, subtitles. column headings, row totals, and other ares of your worksheet? a. cell style b. range style c. worksheet style d. format painter
Cell style
Displaying ##### in a cell refers to which of the following? A) A cell that uses a name that Excel does not recognize B) A cell that tries to divide by 0 C) A cell that is not valid D) Cells are not wide enough to display the entire entry
Cells are not wide enough to display the entire entry
Which of the following tabs do you use to create a query? A) File B) Home C) Create D) Database Tools
Create
Which of the following should you add to a query to search for records that meet a specific value? A) criterion B) Like comparison C) Wildcard symbols D) expression
Criterion
Which of the following keyboard shortcuts lets you paste a paragraph in another location? a. Ctrl+C b. Ctrl+M c. Ctrl+V d. Ctrl+X
Ctrl+V
Which of the following words best describes a Z to A sort? A) ascending B) descending C) rising D) sliding
Descending
In excel, which of the following keys displays a list of range names? a. F3 b. F4 c. F5 d. F6
F3
The field in common between two tables is called the: A) Common denominator. B) Identifier. C) Linking field. D) Foreign key.
Foreign key
Which of the following options allows you to copy formatting attributes and styles from one cell to another cell or group of cells? a. fill handle b. format painter c. paste special d. format cells
Format Painter
Which of the following commands should you use to prevent column and row headings from scrolling off the screen? a. zoom options b. freeze panes command c. status bar view buttons d. merge and center command
Freeze panes command
Which of the following indicates that a cell might contain an error? a. red border b. green border c. red triangle in upper left corner of cell d. green triangle in upper left corner of cell
Green triangle in upper left corner of the cell
Which of the following is a true statement that might describe Solver?
It solves a problem in reverse, starting with the desired answer
Which of the following functions looks for data that you specify and returns the relative location of the data that matches the search? A) INDEX function B) MATCH function C) IFERROR function D) Nested IF function
MATCH function
Which of the following lets you create your own conditional formatting rule as well as edit existing rules? A) Data Bar command B) Conditional Formatting command C) Manage Rules command D) Rules command
Manage Rules Command
Which Microsoft Office applications would you use to create a send email?
Microsoft Outlook
How does excel treat criteria entered on different rows? a. AND condition b. OR condition c. FILTER condition d. BOTH condition
OR condition
Which of the following chart types use one data series to display each value as a percentage of the whole? A) column B) bar C) line D) pie
Pie
For workbooks that might contain data from a questionable source, which of the following views does the workbook open in? A) Unprotected View B) Protected View C) Unsafe View D) Safe View
Protected view
In an AND function, if the argument is text, what should you enclose the text in? A) quotation marks B) parentheses C) commas D) pound signs (#)
Quotation marks
To see the results of a query, you need to click A) See B) View C) Run D) Solve
Run
Which of the following features expands or reduces a worksheet of print on a specific number of pages? a. scale to fit b. zoom c. advanced properties d. print area
Scale to fit
Which of the following is a cloud storage area where you can store files in a private and secure online location? a. file explorer b. skydrive c. Office 2013 d. Office Web Apps
Sky Drive
Which of the following are miniature charts displayed in a cell or cell range with your data? A) sparklines B) markers C) elements D) none of the above
Sparkline
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 she shape as you type c. each shape has its own selection handles and frame d. all of the above
all of the above
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
all of the above
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 protection d. all of the above
all of the above
Which of the following charts displays the magnitude of change over time and shows the rate change? a. area b. XY c. stock d. radar
area
When you select a state abbreviation from a combo box, how does the form control record your selection? a. as a number b. as an alphanumeric character c. using the characters you selected from the combo box d. as a string of letters and numbers
as a number
By default, how does Excel align numeric entries in a cell? a. top left corner of a cell b. top right corner of a cell c. bottom left corner of a cell d. bottom right corner of a cell
bottom right corner of a cell
Which of the following displays the results of a formula? A) cell B) range C) Formula bar D) Fill Handle
cell
In an XML file, which of the following characters encloses the tags? a. curly braces b. brackets c. chevron braces d. parentheses
chevron braces
In cell D10, Rachel entered the following formula: D8+D9+D10. Which of the following terms describes what is going on with this formula? a. absolute reference b. mixed reference c. circular reference
circular reference
When typing entries for a data validation list in the Data Validation dialog box, what should you separate items with? a. # b. ; c. , d. /
commas (,)
To select non-adjacent worksheets, which key must you press? a. ctrl b. alt c. shift d. tab
ctrl
Which of the following is a true statement? a. there are three types of cell references you can use in a formula b. the type of cell reference included in a formula determines the result of a formula when it is copied c. cells that contain absolute references do not change when copied d. all of the above
d. all of the above
Which of the following terms refers to a group of data points or values? A) source data B) data point C) data series D) category label
data series
When creating a consolidation sheet, what must you do to the range of cells that will be consolidated? a. copy them b. move them c. delete them d. format them
delete them
When you need to create a new table from scratch in your database, you go to: A) Design view B) Datasheet view C) Lookup view D) Table view
design view
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
expand each outline item
Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly? a. f2 b. f4 c. f6 d. f8
f4
In an excel table, which of the following represents a column of data? a. header row b. record c. field d. table
field
Which of the following is a criterion or a specification that data must meet to be shown? a. filter b. autofilter c. criterion range
filter
Which of the following is not true about filters? a. a filter is criteria that specifies which data is shown b. A filter is criteria that specifies which data is hidden c. Filters let you switch between several scenarios for your data d. filters alter the source data range
filters alter the source data range
What must be added into a table before relationships between tables can be established? A) primary key B) foreign key C) relationships D) none of the above
foreign key
Which of the following finds a solution for one of the arguments in a formula? a. What if analysis button b. Seek command c. Backsolve command d. Goal Seek Command
goal seek command
When a macro runs, where does it carry out its commands? a. in just the current worksheet b. in just the current workbook c. in any open workbook d. in any saved workbook
in just the current worksheet
Which of the following prohibits a user from making an entry, and gives him or her the choice of either canceling the task or retrying? a. error alert b. stop warning c. warning box d. information message box
information message box
Which of the following explains the symbols, textures, or colors used to differentiate data series? A) axis B) chart area C) legend D) plot area
legend
Which of the following reports displays data about the lower and upper limits of each variable cell and how those limits impact the objective cell? a. answer report b. sensitivity report c. limits report d. feasibility report
limits report
Which of the following illustrates an accurate, statistical analysis of forecasting errors? a. mean absolute deviation (MAD) b. Mean square error (MSE) c. STDEV.S d. standard deviation
mean absolute deviation (MAD)
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 into the Values area? a. once b. twice c. multiple times d. no more than 10
multiple times
What are 3 solver components known as? a. constraints b. variables c. objective cell d. parameters
parameters
Which of the following contains a unique value for each record? A) primary key B) lookup field C) metadata D) cell number
primary key
Which of the following measure how broadly values deviate from the mean or average value in the range? a. mean absolute deviation (MAD) b. Mean square error (MSE) c. STDEV.S d. standard deviation
standard deviation
When you create an excel table, what name does excel give it initially? a. table a (a is a letter) b. table c (c is a character) c. table n ( n is a number) d. table s (s is a symbol)
table n (n is a number)
By default, what file extension is given to excel workbook files? a. .xlsm b. .slx c. .xlsx d. .xltm
.xlsx
Which of the following is the file extension given to an Excel workbook? a. .docx b. .xlsx c. .acccdb d. .pptx
.xlsx
Which of the following XML file extensions is for files that provide data scheme information? a. .xsi b. .xst c. .xsd d. .xds
.xsd
In the MATCH function, which of the following match type arguments finds the first value that exactly matches the lookup value? a. 1 or omitted b. 0 c. -1
0
How many items can the clipboard hold? a. 12 b. 16 c. 24 d. unlimited
24
The default size of a Short Text field is A) 64 characters. B) 128 characters. C) 255 characters. D) Unlimited characters.
255 Characters
How many arguments do all database functions have? a. 2 b. 3 c. 4 d. 5
3
How many types of reports can you create using the Solver Results dialog box? A) 2 B) 3 C) 4 D) 5
3
Which of the following has an answer of 11? E) 2+4*3 F) (2+4)*3 G) 3+2*4 H) (2+3)*4
3+2*4
For most pie charts, what is the maximum number of pie slices you should have? a. 2-3 b. 4-5 c. 6-7 d. 9-10
6-7
Which of the following field validation rules prevents the user from typing 0 into a field? A) <5 B) <>0 C) 'M' or 'F' D) -Not Null
<>0
which of the following characters must always start a function a. = b. ( c. $
=
Which of the following shows the correct syntax for the IF function? A) =IF(C5<50, 'TRUE') B) =IF(C5<50, 'FALSE') C) =IF(C5<50, 'True', 'False') D) =IF(C5<50, TRUE, FALSE)
=IF(C5<50, TRUE, FALSE)
An Access object you can use to create an interface to easily view, add, update, and delete data in a database is called: A) A report. B) A query. C) A table. D) A form.
A form
What does an external reference formula create? A) a link to the destination workbook B) a link to the source workbook C) a hyperlink
A link to the source workbook
What happens when you try to save a workbook with macros as a regular excel workbook? A) The workbook file is saved as usual. B) A message box displays indicating that your VBA work was saved. C) A message box reminds you that your VBA work cannot be saved in a regular workbook. D) A message box reminds you that the workbook's file size will be larger as a result of the macros.
A message box 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) A table B) A query C) A form D) A report
A query
An object you can use to create an organized and professional output of the data is called: A) A report. B) A query. C) A table. D) A form.
A report
Which of the following charts displays relationships among numeric values in two or more data series? A) area B) XY C) stock D) radar
XY
which of the following is a criterion or specification that data must meet to be shown? a. access cannot illustrate data in a chart, but excel can b. excel is capable of managing large databases c. excel includes more advanced reporting capabilities
access cannot illustrate data in a chart, but excel can
Which statement about scenario summary reports is not true? A) You cannot edit a scenario after creating a summary report. B) For a large worksheet with many scenarios, you can choose to format a scenario summary report as a PivotTable. C) In a summary report, you can hide or display details about the changing cells and the result cells. D) A scenario summary report is a generated worksheet that describes each scenario in a workbook.
You cannot edit a scenario after creating a summary report
What can pie charts graph? a. a single data series b. up to 3 data series c. up to 5 data series d. unlimited
a single data series
Which of the following is not true about VBA? a. VBA is not a programming language b. As you recored a macro, Excel converts your keystrokes into VBA c. Code describes the specific programming commands required for an automatic task to run d. Program and procedure are other names used for code
VA is not a programming language
The code behind a macro is written in a programming language that is often referred to as _____. a. VBA b. VBE c. VB d. VBB
VBA
Which of the following is a programming language that allows you to expand the abilities of excel? a. VBA b. ActiveX control c. form control d. Trust Center
VBA
Which of the following are the rules applied to data as it is entered? E) error alert message F) input message G) validation settings H) form
Validation setting
The code behind a macro is written in a programming language that is often referred to as ___________. A) Visual C++ B) Visual Basic for Applications C) Java D) Python
Visual basics for applications
By default, how is a macro recorded? A) with absolute references B) with relative references C) with mixed references D) with all of the above
With absolute refernce
Which of the following features enables you to display the contents of a cell on multiple lines? E) AutoFormat F) AutoFit G) Merge & Center H) Wrap Text
Wrap Text
What is selected when you click the button located above row 1 heading and to the left of column A heading? a. the entire column b. the entire row c. the entire worksheet
The entire worksheet
Which of the following statements is not true about protecting a workbook? A) The Mark as Final command is not a read-only property. B) Once the Mark as Final command has been used, it is easy for a user to remove the property by clicking the Edit Anyway button. C) Excel allows you to assign various security levels for your work. D) In Excel, you can set a simple command to permit a user to view a workbook but not edit it.
The mark as final command is not a read-only property
Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula? a. trace precedents b. trace dependents c. error checking d. evaluate formula
Trace Precedents
Before using the Merge and Center command, what cell should contain the data? a. upper left cell b. bottom left cell c. upper right cell d. bottom right cell
upper left cell
Which of the following shows an exclamation point in a yellow triangle? a. error alert b. stop warning c. warning box d. information message box
warning box
Which of the following statements is not true? a. Range names are used to identify a cell or group of cells b. range names can make it easier to interpret a formula c. the first character of a range name must be a letter, an underscore, or a backslash d. when you name a cell or range, the name becomes a relative reference
when you name a cell or range, the name becomes a relative reference