Information that are not needed at a particular time

Assignment Help Operation Management

Reference no: EM13807507

Question 1: If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information.

hide
delete
freeze
format

Question 2: Which of the following best describes a page break?

Freezes only the top row
The sequence in which pages print
Indicates where data starts on a new printed page
Stops the printer from printing

Question 3: To create a table from an existing range of data, _____.

click within the range, click the Table Tools Design tab, and then select Convert to Table
select any cell in the worksheet and then click Existing Range in the Tools group
click in a cell and on the Home tab, and click the Insert arrow in the Cells group
click the Insert tab and then click Table in the Tables group

Question 4: Which of the following best describes the Excel filtering feature?

Helps to clean the data before printing in Backstage view
Displays data in chronological order
The process of displaying only records that meet specific conditions
Arranges dates in alphabetical order

Question 5: To apply a red background color to cells for employees who have sales greater than $1,000, you can use _____.

a PivotTable
a multiple level sort
conditional formatting
a range name

Question 6: In addition to sorting and filtering cells by content, you can sort and/or filter by _____.

top/bottom rules
conditional formatting
icon sets
the data bar

Question 7: When data is grouped, the margin area displays the _____.

aggregate columns
group headings
collapse and expand buttons
group totals

Question 8: _____ are created to organize and summarize data in PivotTables.

Categories
Types
Titles
Levels

Question 9: Data mining techniques such as PivotTables can detect _____ of data.

patterns
categories
styles
groups

Question 10: The Insert Calculated Field dialog box requires you do all the following EXCEPT _____.

enter formulas using field names instead of cell references
enter a description column heading for the calculated field
build formulas using mathematical operands such as +, -, and *
enter formulas using cell references

Question 11: Excel applies basic formatting to PivotTables such as _____.

subtotals in italics
primary row labels in bold
primary row labels in italics
subtotals in red

Question 12: The _____ enables you to move to a cell quickly by typing the desired cell reference in it and pressing Enter.

Formula bar
F4 function key
Go to dialog box
Find and Replace dialog box

Question 13: To go to the top of your spreadsheet quickly, use the _____ key(s).

Ctrl+End
Arrow
Ctrl+Home
Esc

Question 14: Click the _____ to sort or filter the chart representation based on the values.

Axis Field arrows
Report Filter arrows
Values arrows
Legend Field arrows

Question 15: Pivot Charts look best when they use basic charts, such as a _____.

column chart
scatter chart
radar chart
surface chart

Reference no: EM13807507

Questions Cloud

Infant and child development observation paper : Infant and Child Development Observation Paper

History about the internet : Write 3 paragraph on the history about the internet, how it was developed , when wast it made etc

Determine the test statistics and calculate its value. : Determine the test statistics and calculate its value.

The conflict between continuity : Describe the controversy in psychology about the conflict between continuity and change of 1. personality. What are some of the traits that are likely to change? Unlikely to change? How can people best deal with the dilemma of continuity and change?

Information that are not needed at a particular time : If there are certain columns of information that are not needed at a particular time but might be needed later, _____ the unneeded columns to allow users to focus on only the essential information.

Fascist tendencies in the u.s. : It is unrestrained by public and world opinion, with the tightest constellation of Right-Wing people that seem determine to be at war." Do you believe there are Fascist tendencies in the U.S.

Write a report about a specific book which is cry freedom : Write a report about a specific book which is Cry Freedom by john briley. The report is a two paper report quetions. just easily answer the questions in the paper.

Explain how each is a backup disaster recovery : Make a case for setting up a single, separate DNS server at each location and explain how each is a backup disaster recovery (DR) for the other

The environmental protection agency : Describe the sample and check that the sample meets the necessary assumptions.

User Account

All Pages