One-click use of your favorite excel tools by adding

Assignment Help Operation Management

Reference no: EM132087535

1. You can provide one-click use of your favorite Excel tools by adding them to the

Title bar

Quick access toolbar

Fromula bar

Fast action toolbar

2. A workbook that has "compatibility mode" added to the end of its name is one that

may be opened by all brands of spreadsheet software

has had all of its calculations confirmed as "compatible"

is an older MS Excel file format

is usable for many purposes

3. In MS Excel 2010 and later, a workbook may be saved in the (select all that apply)

.xlsx file format

.pdf file format

.xls file format

4. An MS Excel workbook is a

a file

spreadsheet where calculations are done

book the teaches how to work with a spreadsheet

one page of a spreadsheet

5. An MS Excel worksheet is a (select all that apply)

matrix lettered columns and numbered rows

collection of one or more worksheets

database of lettered columns and numbered rows

database of numbered columns and letters rows

6. In MS Excel, text data may consist of (select all that apply)

alphabetic characters (a-z, A-Z)

numeric characters (0-9) and an optional period

other characters (for example: ?, ", &, #)

7. In MS Excel, numeric data may consist of

alphabetic characters (a-z, A-Z)

numeric characters (0-9) and an optional period

special characters (for example: ?, ", #, &)

all of the above

answers 1 & 2

8. The cell reference A1 is a

Absolute reference

Mixed (relative row, absolute column) reference

Mixed (absolute row, relative column) reference

Relative reference

9. The cell reference $A1 is a

Absolute reference

Mixed (relative row, absolute column) reference

Mixed (absolute row, relative column) reference

Relative reference

10. The cell reference $A$1 is a

Absolute reference

Mixed (relative row, absolute column) reference

Mixed (absolute row, relative column) reference

Relative reference

11. Use "Save As"

everytime you save a file

only the first time you save a file. After that you must use "Save"

- never use "Save As" - always use "Save"

the first time you save a file and anytime after that you want to change its name, location or type

12. The file-type of a file

is indicated by the file's extension

must be either .xls or .xlsx

can be changed by editing the file's extension

will automatically change if you open the file in a different program than the one that created it

13. A digital signature

is a fancy font that looks like you signed it by hand

records the number of times a document has been accessed

restricts access to those who know the signature

demonstrates the authenticity of a digital message or document

14. The fill handle (select all that apply)

is in the lower right-hand side of a cell or an area

may be used to fill cells with data

may be used to clear cells

15. To adjust a cell range in a formula (select all that apply)

edit the Formula bar

drag the cell range border

select the cells for new range

16. A syntax error in a formula may be the results of (select all that apply)

a typographical error

incorrect cell reference

using the wrong formula

17. Formula auditing

is used by accountants

is used by the IRS

is a color-coded editing system

all of the above

answers 1 & 2

18. In MS Excel cell references may be (select all that apply)

relative

absolute

mixed

19. An absolute reference

adjusts when you copy a formula

does not adjust when you copy a formula

contains one relative and one absolute reference

all of the above

answers 1 & 2

20. A relative reference

adjusts when you copy a formula

does not adjust when you copy a formula

contains one relative and one absolute reference

all of the above

answers 1 & 2

21. A mixed reference

adjusts when you copy a formula

does not adjust when you copy a formula

contains one relative and one absolute reference

all of the above

answers 1 & 2

Reference no: EM132087535

Questions Cloud

Used by general mills to identify market segments to serve : Which major segmentation variable was used by General Mills to identify market segments to serve?

Relationship development-management in effective leadership : What is the role of relationship development and management in effective leadership, and how are these concepts used in improving leadership effectiveness?

Retail store operation to sell health-food products : Assume you have the job of setting up an organization structure for a new company which will be a retail store operation to sell health-food products.

Determining accurate inventory decisions : The Economic Order Quantity (EOQ) model is helpful in determining accurate inventory decisions.

One-click use of your favorite excel tools by adding : You can provide one-click use of your favorite Excel tools by adding them to the

In strategic capacity planning : In strategic capacityplanning, what other capital intensive resources should Robert Nardelli cut aswell as reducing labor force?

What is break-even point : What is the break-even point? How many units must be sold to average $0.25 profit per unit?

How can increasing the products awareness to their customer : How can increasing the products awareness to their customer and improve the shopping experiences. The affect of the company by the event.

What patagonia does to encourage feedback from social media : Identify ways that this company focuses on listening to their customers . Discuss what Patagonia does to encourage feedback from social media.

User Account

All Pages