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