# Excel 2

Total word count: 657
Pages: 2

### Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
 Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location. True Once the office clipboard reaches it’s maximum of 24 items, how does it handle the new items that are copied or cut. The clipboard automatically deletes the oldest item on the clipboard In the formula =(G15-G14)*\$M\$3/4, which mathematical operation is performed first? (G15-G14) With Auto fill, dragging the fill handle on a cell copies the cells contents or continues a series of data into adjacent cells. True The file extension .xltx indicates what type of Excel file? Excel template According to the order of precedence for arithmetic operators, operations contained within parentheses are preformed last False All functions begin with the formula prefix. = (equals sign) To insert cells, click the Insert list arrow in the cells group on the ______ tab, then click Insert Cells. HOME Allows the user to move or copy data from one cell to another without using the Clipboard. Predesigned workbook files that contain labels, values, formulas, and formatting. The Excel function that returns the number of cells in a range containing numeric data. Absolute cell reference. Mixed cell reference The type of cell reference used to preserve the relationship to the formula location. The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only." A statistical function. drag-and-drop method Template COUNT \$G\$6 G6 Relative Page list arrow AVERAGE The default file extension for Excel 2016 Workbook is _______. .xlsx In the formula =ROUND(D4:F4,0), what does the zero indicate? The number of the decimal places in the rounded number An absolute cell reference changes the cell references when the formula is copied in a new location. False When cells or rows are inserted or deleted in an Excel Worksheet, how are cell references affected by the insertion or deletion? Cell references are already adjusted Which formula contains a mixed cell reference? =(\$A6+\$A\$7)*0.20 To continue a sequence in adjacent cells, such as months of the year, use the ______ feature of Excel. Fill handle Which type of cell reference preserves the exact cell address in the formula? Absolute An Excel complex formula uses more than one arithmetic operator. True Which of the following is NOT a paste list arrow option Pasting cell sectors The COUNTA function is used to count the number of cells in a range that contain which type of data? All of the above Which method of entering a function requires the user to know the name and initial characters of a function? Manually typing the function Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula? (F4) When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign. False An Excel user should use a relative cell reference when it is important to ____. Preserve the relationship to the formula location Which of the following is a complex formula? =(B4/B8)*10 In Excel, MAX and AVERAGE are examples of ____. Functions Functions can be entered for formulas using all of the following methods except ____. Typing the function argument Predefined formulas in Excel are called functions and can be accessed using the Insert Function button. True =D8+E8*0.5 is a complex formula. True You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address. \$ Which keyboard shortcut turns on Edit mode? (F2) When cells are copied using Excel’s copy function, what happens to the data in the copied cells? The data remains in its original location. Which tab and group will allow the insertion of rows and columns in a worksheet? Home tab, Cells group A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary. Relative

### More flashcards like this

#### NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

#### NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

#### NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price