sera nguyen
Quiz by , created more than 1 year ago

tut 4-6

460
0
0
sera nguyen
Created by sera nguyen over 7 years ago
Close

excel

Question 1 of 98

1

Fill the blank space to complete the text.

Its difficult to read the exact scale on some of Simon's data.
Adding would make it easier to read.

Explanation

Question 2 of 98

1

Fill the blank space to complete the text.

indicates the sequence in which you want data ordered.

Explanation

Question 3 of 98

1

Fill the blank space to complete the text.

enables you to specify various conditions in addition to those that are based on an "equals" criterion.

Explanation

Question 4 of 98

1

Fill the blank space to complete the text.

is a unique label that describes the contents of data in column.

Explanation

Question 5 of 98

1

Simon tells Brooke that when he attempt to open a workbook, the edit links dialog box appears w/ the message "This workbook contains one or more links that cannot be updated". Brooke suggest several possible causes be of this error message. What is the possible cause?

Select one of the following:

  • one of the workbook's source files was edited

  • one of the workbook's source files was copied to a different folder

  • one of the workbook's source files was replaced with an updated file of the same name

  • the workbook was sent to him without links

Explanation

Question 6 of 98

1

Fill the blank space to complete the text.

When Ryder goes to save the workbooks, what is the required file extension?

Explanation

Question 7 of 98

1

Ryder wants to use the workbooks he has created on another computer.
what steps does he need to take?

Select one of the following:

  • He needs to copy just the workbook file to the other computer.

  • He needs to copy the individual worksheets to the other computer.

  • He needs to copy both the workbook file and the individual worksheets to the other computer.

  • He cannot copy the workbook; instead, he needs to copy the individual worksheets and recreate the workspace on the other computer.

Explanation

Question 8 of 98

1

Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the View Tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout?

Select one of the following:

  • click the Tile Horizontally option button

  • click the Tile Vertically option button

  • Click the Overlap option button

  • click the Cascade option button

Explanation

Question 9 of 98

1

Finally, Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files. what should Brooke say

Select one of the following:

  • If a destination file is open when a source file is changed, the destination file will be updated automatically.

  • Source files cannot be updated unless the corresponding destination file is open.

  • It is not possible to choose whether a destination file should reflect changes made to the source files.

  • If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes.

Explanation

Question 10 of 98

1

After Brooke has helped Simon to resolve his original problem, Simon asks her about another linked workbook he has received. The source files for this workbook have not been included, But Simon would like to use the workbook with the most recent values from the source file.
What should Brooke tell him?

Select one of the following:

  • He can open the workbook and click the Continue button in the Edit Links dialog box.

  • He can open the workbook and click the Break button in the Edit Links dialog box.

  • He can open the workbook and click the Change Source button in the Edit Links dialog box

  • He will not be able to use the workbook until obtains copies of the source files.

Explanation

Question 11 of 98

1

Fill the blank space to complete the text.

They can be used to jump to a specific cell food words with underlines or images.

Explanation

Question 12 of 98

1

Fill the blank space to complete the text.

To rearrange records in a table or range based on the data in one or more fields.

Explanation

Question 13 of 98

1

Jared wants to create a hyperlink to a location in his current workbook. He clicks the hyperlink button in the links group on the INSERT tab. What option Should he select from the Link to List?

Select one of the following:

  • Place in this Document

  • Existing File

Explanation

Question 14 of 98

1

Jared has heard that screentips can be used in conjunctions with hyperlinks.
What is the correct statement about screentips?

Select one of the following:

  • they appear whenever you place the pointer over a cell

  • You can specify the contents of a screentip when you create a hyperlink.

Explanation

Question 15 of 98

1

Jared wants to create a hyperlink to link a new document. What should he click in the Link to List?

Select one of the following:

  • Place in this Document

  • Existing file

Explanation

Question 16 of 98

1

Fill the blank space to complete the text.

Click the button marked in the accompanying figure to fix broken links.

Explanation

Question 17 of 98

1

Fill the blank space to complete the text.

A(n) group is a collection of two or more selected worksheets.

Explanation

Question 18 of 98

1

Fill the blank space to complete the text.

A 3-D cell specifies not only the rows and columns of a cell range, but also the range of worksheet names that the cell appear on.

Explanation

Question 19 of 98

1

Fill the blank space to complete the text.

A(n) is a connection between two files allowing information to be transferred from one file to the other.

Explanation

Question 20 of 98

1

Fill the blank space to complete the text.

when two source files are linked together, the workbook that contains the information is the file.

Explanation

Question 21 of 98

1

Fill the blank space to complete the text.

when two files are linked together, the file receives the information.

Explanation

Question 22 of 98

1

Fill the blank space to complete the text.

If both the and source files are open, Excel will update the link between them automatically whenever a value in the source file is changes.

Explanation

Question 23 of 98

1

Fill the blank space to complete the text.

When the destination file is and the source files are closed, the complete file path is included as part of the external reference formula that appears in the formula bar.

Explanation

Question 24 of 98

1

Fill the blank space to complete the text.

You can use the dialog box to break lines between workbooks.

Explanation

Question 25 of 98

1

Fill the blank space to complete the text.

a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.

Explanation

Question 26 of 98

1

Fill the blank space to complete the text.

A(n) is a link in a file, such as a workbook, to information within that file or another file.

Explanation

Question 27 of 98

1

Fill the blank space to complete the text.

In the Links group, click the Hyperlink button and the Hyperlink dialog box opens.

Explanation

Question 28 of 98

1

Fill the blank space to complete the text.

appear whenever you place the pointer over a hyperlink.

Explanation

Question 29 of 98

1

Fill the blank space to complete the text.

To manually a link and see the new data values, click the Update Values button.

Explanation

Question 30 of 98

1

Fill the blank space to complete the text.

To use a template that you create, The template file is typically placed in the folder.

Explanation

Question 31 of 98

1

Fill the blank space to complete the text.

After you have saved a template, you can access the template from the New Screen in view

Explanation

Question 32 of 98

1

Using multiple worksheets makes it easier to group and summarize data.
Describe features that can be applied by forming a worksheet group.

1. Enter or Edit data. Changes made to content in the active worksheet are also made in the same cells in all the worksheet group.
2. Apply fomatting. Changes made to formatting in the active worksheet are also made to all the worksheet in the group, including changing row heights or columns widths and applying conditional formatting.
3. Insert or delete rows and columns. Changes made to the worksheet structure in the active worksheet are also made to all the worksheets in the group.
4. Set the page layout options. Changes made to the page layout settings in one worksheet also apply to all the worksheets in the group, such as changing the orientation, scaling to fit, and inserting headers and footers.
5. Apply view options. Changes made to the worksheet view such as zooming, showing and hiding worksheets, and so forth are also made to all of the worksheets in a group.
6. Print all the worksheets. You can print all of the worksheets in the worksheet group at the same time.

Select one of the following:

  • True
  • False

Explanation

Question 33 of 98

1

what are the steps to inserting a hyperlink and linking to a file or webpage, a location in the current workbook, a new document, and an e-mail address.

- Select the text graphic or cell in which you want to insert a hyperlink.
- On the INSERT tab, in the Links group, click the Hyperlink button.
- To Link a file or webpage, click Existing File or Webpage in the Link to List, and then select the file or webpage from the Look in the box.
- To Link a location in the current workbook, click the Place in this Document in the Link to List, and then select the worksheet, cell or Document in the current workbook.
- To link a new document, click CREATE NEW DOCUMENT in the Link to List, and then specify the filename and path of the new document.
- To link to an email address, click E-mail Adress in the Link to List, and then enter the email address of the recipient (such as name@example.com) and a subject line for the message.
-Click the OK button.

Select one of the following:

  • True
  • False

Explanation

Question 34 of 98

1

What is an Example of when you would use a template?

A large organization may need to collect the same information from several regions. By creating and distributing a workbook template, each region knows what data to track and where to enter it. the template already includes the formulas, so the results are calculated consistently

Select one of the following:

  • True
  • False

Explanation

Question 35 of 98

1

Name at least three benefits of using a workbook template.

- Templates save time and ensure consistently in the design and content of workbooks because all labels, formatting, and formulas are entered once.
- Templates ensure accuracy because formulas can be entered and verified once, and then be used with confidence in all workbooks.
- Templates standardize the appearance and content of workbooks is inadvertently saved with new data rather than saved as a new workbook

Select one of the following:

  • True
  • False

Explanation

Question 36 of 98

1

Fill the blank space to complete the text.

Type of cell reference that refers to the cell or range of cells on multiple worksheets in the same workbook.

Explanation

Question 37 of 98

1

Fill the blank space to complete the text.

Usually represented by words with colored letters and underlines or images.

Explanation

Question 38 of 98

1

Fill the blank space to complete the text.

Divides the open workbooks evenly on the screen

Explanation

Question 39 of 98

1

Fill the blank space to complete the text.

" " indicates that a link is updated automatically.

Explanation

Question 40 of 98

1

Fill the blank space to complete the text.

" " indicated that a link has to be updated manually by the user.

Explanation

Question 41 of 98

1

Fill the blank space to complete the text.

file receives the information when two files are linked.

Explanation

Question 42 of 98

1

Fill the blank space to complete the text.

file contains the information when two files are linked.

Explanation

Question 43 of 98

1

Fill the blank space to complete the text.

contains text, formats, and formulas already built into it for your use.

Explanation

Question 44 of 98

1

Fill the blank space to complete the text.

A connection between two files allowing information to be transferred from one file to other.

Explanation

Question 45 of 98

1

Fill the blank space to complete the text.

A collection of two or more selected worksheets

Explanation

Question 46 of 98

1

Fill the blank space to complete the text.

To temporarily hide all the records that do not meet your criteria.

Explanation

Question 47 of 98

1

Fill the blank space to complete the text.

A column within an Excel range.

Explanation

Question 48 of 98

1

Fill the blank space to complete the text.

Documentation that lists the fields to be maintained for each record.

Explanation

Question 49 of 98

1

Fill the blank space to complete the text.

to keep headings visible as you work with the data in a large worksheet

pane

Explanation

Question 50 of 98

1

Fill the blank space to complete the text.

A collection of related fields that are grouped together.

Explanation

Question 51 of 98

1

What are the steps for sorting data using multiple fields?

1. Select any cell in a table or range.
2. On the Data tab, in the Sort & Filter group, click the sort button.
3. If necessary, click the add level button to insert the sort by row.
4. click the sort by arrow, select the column heading for the primary sort field, click the sort on arrow to select the type of data, and then click the order arrow to select the sort order,
5. For each additional column to sort, click the add level button, click the THEN BY arrow, select the column heading for the secondary sort field, click the column heading for the secondary sort field, click the sort on arrow to select the type of data, and then click the order arrow to select the sort order.
6. click the OK button.

Select one of the following:

  • True
  • False

Explanation

Question 52 of 98

1

What are the guidelines for creating an effective structured range of data?

-Enter field names in the top row of the range
-Use short, descriptive field names
-Format field names
-Enter the same kind of data in a field
-separate the data from the rest of the work sheet.

Select one of the following:

  • True
  • False

Explanation

Question 53 of 98

1

Fill the blank space to complete the text.

The command automatically inserts a subtotal line into the range for each group of data.

Explanation

Question 54 of 98

1

Fill the blank space to complete the text.

The entry 20,000 is the for the first condition

Explanation

Question 55 of 98

1

Fill the blank space to complete the text.

The criteria filter requires that the records displaying begin with the specified text string

Explanation

Question 56 of 98

1

Fill the blank space to complete the text.

When you want to see all the data in a filtered table, you can , or rename the filters

Explanation

Question 57 of 98

1

Fill the blank space to complete the text.

The process of hiding certain records and viewing the ones you want is called your data

Explanation

Question 58 of 98

1

Fill the blank space to complete the text.

A(n) list indicates the sequence in which you want data ordered

Explanation

Question 59 of 98

1

Fill the blank space to complete the text.

the secondary sort field in asort is called the

Explanation

Question 60 of 98

1

Fill the blank space to complete the text.

To freeze a row, select the cell below row(s) you want to freeze, click the button in the window group and then click freeze top row.

Explanation

Question 61 of 98

1

Fill the blank space to complete the text.

Each column in a range represents a(n) that describes some attributes of characteristics of a person, place, or a thing.

Explanation

Question 62 of 98

1

Fill the blank space to complete the text.

when related fields are grouped together in a row, they form a(n) , a collection of fields that describes a person, place, or thing.

Explanation

Question 63 of 98

1

Fill the blank space to complete the text.

Shows patterns or relationship between two or more sets of values. Often used in scientific studies and statistical analysis.

Explanation

Question 64 of 98

1

Fill the blank space to complete the text.

displays stock market data

Explanation

Question 65 of 98

1

Fill the blank space to complete the text.

compares three sets of values in a three-dimensional chart.

Explanation

Question 66 of 98

1

Fill the blank space to complete the text.

Compares a collection of values from several different data sets

Explanation

Question 67 of 98

1

Fill the blank space to complete the text.

similar to a scatter chart

Explanation

Question 68 of 98

1

Fill the blank space to complete the text.

Compares values from different categories. Areas under the lines contain a fill color.

Explanation

Question 69 of 98

1

Fill the blank space to complete the text.

Compares values from different categories. A value is indicated by the length of the

Explanation

Question 70 of 98

1

Fill the blank space to complete the text.

compares relative values of different categories to the whole. A value is indicated by the area of a(n)

Explanation

Question 71 of 98

1

Fill the blank space to complete the text.

often used to show trends and changes over time

Explanation

Question 72 of 98

1

Fill the blank space to complete the text.

Compares values from different categories. A value is indicated by the height of each

Explanation

Question 73 of 98

1

Fill the blank space to complete the text.

An chart takes up less space than a chart sheet

Explanation

Question 74 of 98

1

Fill the blank space to complete the text.

the covers the entire background of the chart, whereas the plot area includes only that portion markers, such as the columns in a column chart, have been placed or plotted.

Explanation

Question 75 of 98

1

Fill the blank space to complete the text.

each value from a data series is represented by a

Explanation

Question 76 of 98

1

Fill the blank space to complete the text.

are horizontal and vertical lines that help you compare data and category values.

Explanation

Question 77 of 98

1

Fill the blank space to complete the text.

a displays data values as columns with the height of each column based on the data value.

Explanation

Question 78 of 98

1

Fill the blank space to complete the text.

A(n) chart shows patterns or relationships between two or more sets of values, much like an XY chart except the size of the data marker is determined by third value.

Explanation

Question 79 of 98

1

Fill the blank space to complete the text.

you can add to identify smaller intervals between the major tick marks

Explanation

Question 80 of 98

1

Fill the blank space to complete the text.

the range of values, or , of an axis based on the values in the data source.

Explanation

Question 81 of 98

1

Fill the blank space to complete the text.

excel supports types of charts into 10 categories.

Explanation

Question 82 of 98

1

Fill the blank space to complete the text.

Mya needs to call attention to one category above all others. For this purpose, she should use a(n)

Explanation

Question 83 of 98

1

Fill the blank space to complete the text.

sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can an existing chart

Explanation

Question 84 of 98

1

Fill the blank space to complete the text.

since its important for Mya to keep percentage of her whole reviewer base in mind set, she wants to represent data as parts of a whole. what chart type would you suggest to Mya.

Explanation

Question 85 of 98

1

Fill the blank space to complete the text.

simon wants to change the charts borders. to do this, he should select

CHART TOOLS tab

Explanation

Question 86 of 98

1

Fill the blank space to complete the text.

the goal of a is to convey the maximum amount of information within a very small space sparklines

Explanation

Question 87 of 98

1

Fill the blank space to complete the text.

each data source is a collection of , which is a range of values plotted as a single unit on a chart.

Explanation

Question 88 of 98

1

Fill the blank space to complete the text.

since scientific data is often plotting two numeric values against one another, it is often times best to represent this data type with a(n) chart

Explanation

Question 89 of 98

1

Fill the blank space to complete the text.

a chart that combines two or more chart into a single graph is called a(n) chart

Explanation

Question 90 of 98

1

Fill the blank space to complete the text.

to compare values from several categories with a sequential order, such as dates and times occurring at evenly spaced intervals, you would use a(n) chart

Explanation

Question 91 of 98

1

Fill the blank space to complete the text.

in case where a label placed outside a pie might appear farther from its slice than easily readable, a(n) might be added to connect the data to its corresponding slices.

Explanation

Question 92 of 98

1

consider the impact of a poorly designed chart, Explain why it is important to have a well-designed chart, and name at least four tips for creating a good chart.

- keep it simple. do not clutter a chart with too may graphical elements
- focus on the message. design the chart to highlight the points you want to convey to readers,
- limit the number of data series. most charts should display no more than four or five data series.
- choose colors carefully, displaying different data series in contrasting colors to make it easier to distinguish one series from another
- limit your chart to a few text styles. Use a maximum of two or three different text styles in the same chart

a well-designed chart can illuminate facts that might be hidden by viewing only numbers. However, a poorly designed chart can mislead readers. misrepresent data, and make it more difficult to interpret data

Select one of the following:

  • True
  • False

Explanation

Question 93 of 98

1

simon has finished his chart but needs to save some space . what's the most effective way for andy to reduce space w/o losing important data

overlay the legend in areas w/o data

Select one of the following:

  • True
  • False

Explanation

Question 94 of 98

1

describe some of the concepts and definitions associated with loans before using a PMT function.

the cost of a loan to the borrower is largely based on three factors: the principal, the interest, and the time required to repay the loan. Principal is the amount of money being loaned. interest is the amount added to principal by the lender. you can think of the interest as a kind of "user free" because the borrower is paying for the right to use the lender's money for an interval of time. Generally interest is expressed at an annual percentage rate, or APR

Select one of the following:

  • True
  • False

Explanation

Question 95 of 98

1

when selecting a chart, its important to choose the right type of chart to represent your data. if choosing between a pie chart and a line chart, which factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

- pie chat should generally be used when the number of categories is small and the relative size of different slices can be easily determined
pie charts compare relative value from different categories to the whole. values are indicated by the size if the pie slice.
- line charts are best for categories that follow a sequential order. However, line charts will distort data that occurs at irregular time intervals, making data appear to have occurred regularly.
line charts also show trends overtime. values are indicated by the height of the line.
-pie charts and line charts assume that numbers are plotted against categories.

Select one of the following:

  • True
  • False

Explanation

Question 96 of 98

1

Mya has asked your advice. A collegue told her to remove the legend from her pie chart because it takes up too much space. what would be a better piece of advice to give Mya?

Overlay the legend on a part of the chart that's empty.

Select one of the following:

  • True
  • False

Explanation

Question 97 of 98

1

Mya has decided she needs to move her chart so that it appears below her data source. before she can move or resize her chart, she must?

select the chart

Select one of the following:

  • True
  • False

Explanation

Question 98 of 98

1

Since Mya is still reviewing her data, she wants to make sure that her chart reflects any changes she makes in her data source. she should?

do nothing since charts in excel remain linked to data sources

Select one of the following:

  • True
  • False

Explanation

Previous
Check answer
Next