Question

Microsoft Office 2013: Excel Multiple Choice Questions

Instructions: Circle the best answer.

1. Which of the following can be used to sum all the values in the cells in column A?
a. =SUM(all:A)
b. =ADD(A)
c. =SUM(a:a)
d. =SUM(A)

2. Imported data that maintains a refreshable link to its external source is called _____.
a. external data
b. linked data
c. nested data
d. delimited data

3. A _____ file contains data fields of equal length with spaces between the fields.
a. delimited
b. text
c. fixed-width
d. query

4. The _____ dialog box allows you to choose in which cell to import the text and to specify properties of the imported text.
a. Format Painted
b. Import Data
c. Basic Text
d. Standard Import

5. After a text file is imported, Excel can update the data whenever the original text file changes using the _____ button.
a. Sync
b. Load Data
c. Update
d. Refresh All

6. Webpages use a file format called _____, which is a language that browsers can interpret.
a. HTTP
b. EPS
c. HTML
d. XML

7. The Text format brings in only text that has not been processed, formatted, or manipulated, also known as _____ data.
a. raw
b. plain
c. simple
d. delimited

8. You _____ a workbook by adding comments to cells that contain complex formulas or to cells containing content that may not be understood easily.
a. format
b. import
c. extract
d. document

9. The _____ tool allows you to create shadowed, skewed, rotated, and stretched text on a chart sheet or worksheet and apply other special text formatting effects.
a. Object Formatter
b. WordArt
c. Text Manager
d. Special Effects

10. You can _____ a shape, which means you can move the shape to an upper level.
a. escalate
b. resize
c. promote
d. upgrade

Microsoft Office 2013: Excel Short Answer

Instructions: Fill in the best answer.

1. A(n) _______________ is a special-purpose workbook you can create and use as a pattern for new, similar workbooks or worksheets.

2. When you _______________ data, you bring in data from various external sources into an Excel worksheet.

3. A(n) _______________ file contains data with little or no formatting.

4. A(n) _______________ is a way to qualify the data to import by specifying a matching condition or asking a question of a database.

5. When you import or copy data and want to switch rows and columns, you can _______________ the data.

6. Some spreadsheet specialists refer to copying formulas as _______________.

7. The Replace command replaces the found search string with new data. You can use it to find and replace one occurrence at a time, or you can use the _______________ button to replace the data in all locations at once.

8. A(n) _______________ graphic is a customizable diagram that you use to pictorially present
lists, processes, and relationships.

9. Many SmartArt graphics include more than one shape, such as a picture, text box, or combinations, grouped in _______________.

10. A(n) _______________ is a portion, usually of one object or section of a window, of the
screen.

Microsoft Office 2013: Excel – True/False
Instructions: Circle T if the statement is true or F if the statement is false.
1. When testing formulas for errors, you should always select some dummy data that tests the limits of the formulas. .
T
F

2. With a view-only file, you can open and access the file normally, but you cannot make permanent changes to it. .
T
F

3. When you open a file based on a template, Excel names the new workbook using the template name with an appended letter a. .
T
F

4. XML is versatile and simple and can be used to describe most any type of data. .
T
F

5. Excel allows you to import data made available in many formats, including text files, Access tables, webpages, Word documents, and XML files. .
T
F

6. A delimited file contains data fields separated by a selected character, such as a comma. .
T
F

7. A web query selects data from the Internet to add to the Excel worksheet. .
T
F

8. The Convert Text to Columns Wizard is a powerful tool that allows you to manipulate up to 256 columns at a time. .
T
F

9. To create an exact copy of a formula without replication, hold down the ALT key while dragging the fill handle. .
T
F

10. The data you search for using the Find command sometimes is called the search string. .
T
F

Microsoft Office 2013: Excel Multiple Choice

Instructions: Circle the best answer.

1. A _____ report is an interactive chart that allows users to change the groupings that graphically present data.

a. forecast slice
b. PivotChart
c. TableChart
d. R-squared

2. Using a _____ on certain Excel charts allows you to illustrate how one set of data is changing in relation to another set of data.

a. focus
b. baseline
c. trendline
d. series

3. A(n) _____ is the symbol in a chart that represents a single value from a worksheet cell.

a. data marker
b. PivotTable
c. option
d. column field

4. PivotTables use two types of fields: _____.

a. subgroup and summary
b. chart and pivot
c. field and table
d. data and category

5. The default summary function in a PivotTable is the _____ function.

a. COUNT
b. SUM
c. ADD
d. NUM

6. The _____ summary function for a PivotChart or PivotTable provides the largest value in the data source.

a. Max
b. Count
c. Average
d. Biggest

7. When you update cell contents in Excel, you also update all of the following EXCEPT _____.

a. related tables
b. formula calculations
c. PivotTables
d. charts

8. The default chart type for a PivotChart is a _____ chart.

a. scatter
b. pie
c. bubble
d. clustered column


9. Changes to category fields in a PivotChart report are correspondingly made to _____ in the PivotTable report.

a. column fields
b. row fields
c. total cells
d. summary cells

10. PivotTables are dynamic by nature. To save a configuration, make a copy of the sheet, and use the _____ command to keep changes from being made to the worksheet copy.

a. Read only
b. Disable changes
c. Hide
d. Protect sheet

Microsoft Office 2013: Excel Short Answer

Instructions: Fill in the best answer.

1. A(n) _______________ is a visual way to show how two variables relate to each other.

2. A(n) _______________ report is an interactive view of worksheet data that gives users the ability to summarize the data by selecting categories in which to group their data.

3. _______________ are graphic objects that contain buttons you tap or click to filter the data in PivotTables and PivotCharts.

4. _______________ helps predict data values that are outside of a data set.

5. The _______________ value is a number from 0 to 1 that measures the strength of a trend.

6. PivotTable _______________ are drawn from columns in the worksheet data.

7. Viewing a PivotTable report for only a subset that meets a selection criterion is known as _______________.

8. The _______________ summary function for PivotCharts and PivotTables provides the number of data values in the data source.

9. The _______________ summary function for PivotCharts and PivotTables estimates of the variance of all of the data to be summarized in the data source.

10. A(n) _______________ is a field with values not entered as data, but determined by computation involving data in other fields.

Microsoft Office 2013: Excel True/False

Instructions: Circle T if the statement is true or F if the statement is false.
1. Chart types that do not examine the relationship between two variables, such as pie and doughnut charts, which examine the contribution of different parts to a whole, cannot include trendlines.
T
F

2. An R-squared value of 1 means the estimated values in the trendline correspond exactly to the actual data.
T
F

3. Charts with trendlines must start the vertical axis at the number 0.
T
F

4. Data fields correspond to columns in the original data.
T
F

5. You can only create PivotTable reports on the same worksheet as the data to be analyzed.
T
F

6. Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.
T
F

7. PivotTables do not update automatically when you change the underlying data for the PivotTable report.
T
F

8. A PivotChart report always must be associated with a PivotTable report.
T
F

9. By default, a PivotChart report will be created on a new sheet in the same workbook as the associated PivotTable report.
T
F

10. Changes to series fields in a PivotChart report appear as changes to column fields in the PivotTable report.
T
F

Microsoft Office 2013: Excel Multiple Choice

Instructions: Circle the best answer.

1. _____ allows you to examine formulas to determine which cells are referenced by those formulas and examine cells to determine which formulas are built upon those cells.
a. Slice checking
b. Formula auditing
c. Scenario validation
d. Group constraints

2. A _____ is a limitation on the possible values that a cell can contain.
a. trail
b. goal
c. constraint
d. tag

3. Excel’s _____ is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model.
a. Scenario Manager
b. Audit Master
c. Formula Inspector
d. Summary Builder

4. A cell containing a formula that references other cells is said to have _____.
a. traces
b. dependents
c. constraints
d. precedents

5. When a cell contains a _____ reference, it means that one of its defining values is itself.
a. nested
b. circular
c. precedent
d. dependent

6. Which of the following indicates that you have a value that is not available to a formula or function?
a. #AVAIL!
b. #NAME!
c. #N/A!
d. #NULL!

7. The _____ error code indicates no common cells in two ranges a formula identifies as having an intersection.
a. #NULL!
b. #AVAIL!
c. #NAME!
d. #N/A!

8. _____ allows you to solve complex problems where a number of variables can be changed in a worksheet in order to meet a goal.
a. Formula seeking
b. Trace editing
c. Trial and error
d. Solver


9. Each version of Excel includes varying features, so you should use the _____ to determine if the features in your workbook are compatible with earlier versions of Excel.
a. Error Checker
b. Formatter
c. Compatibility Checker
d. Version Manager

10. _____ is a feature of Excel that allows you to restrict access to workbooks.
a. Scenario Solver
b. Information Rights Management
c. Information Center
d. Audit Worksheet

Microsoft Office 2013: Excel Short Answer

Instructions: Fill in the best answer.

1. _______________ allows you to set cells so that the values they accept are restricted in terms of type and range of data.

2. When trying to solve some problems, you can make an educated guess if you are familiar with the data and the structure of the workbook. This process is called _______________.

3. A(n) _______________ shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those constraints.

4. A cell that references another cell is said to be a(n) _______________ of that referenced cell.

5. The _______________ allows you to keep an eye on cells that you have identified as being related; this allows you to observe changes to the cells even when viewing a different worksheet or workbook.

6. _______________ seeking will change the value of a cell until a single criterion is met in another cell.

7. _______________ programming is a complex mathematical process used to solve problems that include multiple variables and the minimizing or maximizing of result values.

8. Changing cells, or _______________ cells, are the cells modified by Solver to solve the problem.

9. The Solver _______________ summarizes the problem that you have presented to Solver. It shows the original and final values of the target cell along with the original and final values of the changing cells (adjustable cells) that Solver adjusted to find the answer. Additionally, it lists all of the constraints that you imposed on Solver.

10. _______________ are named combinations of values that are assigned to variables in a model.


Microsoft Office 2013: Excel True/False

Instructions: Circle T if the statement is true or F if the statement is false.

1. The trial and error method for solving problems is best used for very complex problems.
T
F

2. Tracer arrows are drawn from one cell to another, identifying cells that are related to other cells through use in a formula.
T
F

3. When all levels of precedents or dependents have been identified, Excel will sound a beep if you try to trace another level.
T
F

4. The error code #VALUE! indicates that a cell reference is not valid.
T
F

5. Excel can automatically identify cells that contain formulas that are mathematically correct, but logically incorrect.
T
F

6. Goal seeking allows you to manipulate up to 256 cells in order to reach a goal.
T
F

7. Regardless of the technique Solver uses to solve a problem, it requires three different types of input from the user: the objective, the variable cells, and the constraints.
T
F

8. A constraint that is binding is one that limited the final solution in some way.
T
F

9. Once you have viewed two or more scenarios in a row, you can use the Undo and Redo commands to switch between them, as an alternative to using the Scenario Manager.
T
F

10. The Compatibility Checker should be used before sharing a workbook publicly or when you suspect extraneous information remains in hidden rows and columns, hidden worksheets, document properties, headers and footers, or worksheet comments.
T
F

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Instructions: Circle the best answer.

1. Which of the following can be used to sum all the values in the cells in column A?

a. =SUM(all:A)
b. =ADD(A)
c. =SUM(a:a)
d. =SUM(A)
The answer is option C.

2. Imported data that maintains a refreshable link to its external source is called _____.

a. external data
b. linked data
c. nested data
d. delimited data
The answer is option A.

3. A _____ file contains data fields of equal length with spaces between the fields.

a. delimited
b. text
c. fixed-width
d. query
The answer is option C.

4. The _____ dialog box allows you to choose in which cell to import the text and to specify properties of the imported text.

a. Format Painted
b. Import Data
c. Basic Text
d. Standard Import
The answer is option B.

5. After a text file is imported, Excel can update the data whenever the original text file changes using the _____ button.

a. Sync
b. Load Data
c. Update
d. Refresh All
The answer is option D....

This is only a preview of the solution. Please use the purchase button to see the entire solution

Assisting Tutor

Related Homework Solutions

Foreign Affair Discussion (720 words)
Homework Solution
$10.00
Administration
States
Nuclear Weapons
Range Missiles
World Politics
Government
Attacks
Wars
Financial Support
Economics
Environment
Bombs
Linear Systems in Matlab
Homework Solution
$83.00
Mathematics
Computer Science
Programming
Matlab
Linear Systems
String
Tension
Mass
Displacement
Physics
Equilibrium
Force Balance Equation
Gravity
Vectors
Matrices
Variables
Plots
Interesting Intercultural Experiences (980 words)
Homework Solution
$30.00
Culture
Studies
Psychology
Management
Advertising
Intercultural Communication
Companies
Americans
Language
Food
Customs
Clothing
Youth Challenge International
New York City
Economy
Business
Trading
Industry
Education
Society
Student Ex
Health Administration Questions
Homework Solution
$20.00
Administration
Patients
CPT Codes
ICD-9-CM Codes
ICD 9 Volume III Codes
Health
Keratosis
Biopsy
Burn
Lumbar Puncture
Laboratory
Medicine
Infections
Cardiac Arrest
Anesthetic
Principal Procedure
Significant Procedure
International Relations Discussion (650 words)
Homework Solution
$20.00
Administration
International Relations
Discussion
Female Leaders
Gender Stereotypes
Marketing
Leadership Skills
Government
Politics
Indira Gandhi
Angela Merkel
Hillary Clinton
Awards
Ceremonies
Social Activities
Medical Coding Questions
Homework Solution
$20.00
Medical Coding
Administration
Health
Emergency Department
Kidney Machine
HCPCS Codes
CPT Codes
Services
Code A4642
Get help from a qualified tutor
Live Chats