Excel 2013

What are the main differences between Accounting Number Format and Currency format? Which format has its own command on the Ribbon?

$ - Currency placed to the left of the number, accounting at the left border. negative values - currency preceded by a minus sign or in parentheses or in red. accounting in parentheses and zero values as hyphens. Accounting format is on the ribbon

enables you to copy the contents of a cell or a range of cells by dragging the fill handle over a adjacent cell or range of cells

Auto fill

What are two ways to insert a new row in a worksheet?

Click in the row you want to insert a new row above. Click the Insert arrow in the Cells group on the HOME tab and select Insert Sheet Rows. 2. Right-click the row heading for which you want to insert a new row above, and select from the shortcut menu.

Command used to keep cell active for formatting.

Ctrl + Enter

What helps determine whether you use portrait or landscape orientation for a worksheet?

Portrait for worksheets that have more rows than columns. Landscape for worksheets that have more columns than rows

What steps should you perform before entering data into a worksheet?

State the purpose of the worksheet, decide what input values are needed, and decide what outputs are needed to achieve the purpose of the worksheet.

What are four major things you can enter into a cell?

Text: phone numbers, SS#; Values: numbers used for basis of calculations; Dates: dates and times to reference date and time ranges; Formulas: arithmetic operations, values, and functions

Why would you select a "Center on page" option if you have already set the margins?

To balance the data equally between the left and right columns

Why would you use the Paste Special options in Excel?

To paste data in a different format than they are in the Clipboard. You may want to paste them to other Office programs.

the current cell is the

active cell

What are two major advantages of using an electronic spreadsheet instead of a paper-based ledger?

can lead to inaccurate values and time-consuming

The intersection of a column and a row is a

cell

to display formulas what key sequence

ctrl + ~

What visual indicators let you know which cell is the active cell?

displays a dark green border around the active cell and the cell address of the active cell appears in the Name Box.

a small green square appearing in the bottom-right corner of the active cell

fill handle

combine cell references, arithmetic operations, values, and/or functions used in a calculation.

formulas

Describe five alignment and font formatting techniques used to format labels that are discussed in this section.

horizontal and vertical alignment (even left to right and/or up and down), wrap text (fits into two or three lines so column width is better adjusted), merge and center labels, increase and decrease indent (allows items to stand out in a report when listing items), apply borders and fill color.

What is the order of precedence?

it controls the sequence of arithmetic operations. Parentheses change the operation of operations

What is the purpose of Auto fill?

lets you copy the contents of a cell or a range of cells by dragging the fill handle. Can be used for months of the year, quarters, days of the week, counting by 5's

When you move or copy a worksheet, what are some of the decisions you must make?

location of new data and is the area large enough. It will overwrite data if not large enough to fit area.

contain multiple ranges,

nonadjacent range

a rule that controls the sequence in which arithmetic operations are performed, which affects the results of the calculation.

order of precedence

the region in the worksheet to contain formulas dependent on the values in the input area.

output area

List at least five elements you can insert in a header or footer.

page number, current date, current time, file name, picture

Refers to a group of adjacent or contiguous cells

range

How can you delete cell B5 without deleting the entire row or column?

select the cell, click the Delete arrow in the Cells group and then select Delete Cells to display the Delete dialog box. Click the option to shift cells left or up and click OK.

How can you select nonadjacent ranges, such as B15:B10 and F5:F10? Why would you select nonadjacent ranges?

select the first range, press and hold Ctrl, and then select additional range(s). To apply the same formatting at the same time.

a process of selecting a cell or range of cells for entering cell references as you create formulas.

semi-selection, aka pointing

an electronic file that contains a grid of columns and rows used to organize related data and to display results of calculation, enabling interpretation of quantitative data for decision making

spreadsheet

Why would you want to print gridlines and row and column headings?

to increase readability, analyze formulas

What is the importance of formatting a worksheet?

to make it look professional. Makes finding and analyzing data easier

What is the benefit of renaming a worksheet?

to reflect the sheet contents

Why would it be useful to display formulas instead of formula results in a worksheet?

to see where the actual numbers originated?

numbers that represent a quantity or a measurable amount

value

When should you adjust column widths instead of using the default width?

when the cell is too narrow to display the complete value, and text appears to be truncated.

a collection of one or more related worksheets contained within a single file.

workbook

a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data

worksheet