Microsoft Excel

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

When you run the Spell Checker in a workbook, Excel automatically checks in all worksheets at once. T or F

False

To change the name of a worksheet, you rename the ____.

Sheet tab

Which function inserts the total of a range

Sum

Cell protection

Techniques that ensure users do not inadvertently change values that are critical to the worksheet

How can you remove data labels from a chart?

Uncheck the box beside Data Labels in Chart Elements

When you select a cell range, the cells must be adjacent to each other. T or F

False

PMT Function

The financial function that calculates the payment schedule required to repay a loan based on constant payments and constant interest rates

Logical test

The first part of an IF function, if the logical test is true, then the seconds part of the function is applies; if it is false, then the third part of the function is applied.

What formula totals cells B6, B7, B8, B9, and B10 most efficiently

The formula =SUM(B6:B10)

merge

To combine, such as several cells into one cell

A student wants to insert a column sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click insert tab, select sparkline type of choice from the sparklines group and then select ok. T or F

True

Data table

A range of cells that shows the resulting values when one or more input values are varied in a formula; in a chart, a grid containing the chart data.

chart sheet

A separate sheet in a workbook that contains only a chart, which is lined to the workbook data.

worksheet

A single sheet in a workbook file that is laid out in in a grid of rows and columns

In the formula =b6*$B$2, which of the following describes $b$2?

Absolute cell reference

To align currency symbols and decimal points in a column of numbers, you can apply the ___ number format.

Accounting

What should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart tools ? Design tab > Type group > Change Chart Type > All Charts > X . Clustered column > ok?

Column

You double-click the format painter button when you want to ___

Copy a cell's format to more than one cell

Bertie wants to show data labels inside a text bubble shape. What option can she click on after clicking on the arrow next to data labels under chart elements?

Data Callout

data series

Data from a column or row in a sheet the set of values represented in a chart.

What is true about inserting cells in a worksheet?

Excel automatically adjusts cell references to reflect new formulas locations

Bart needs to apply a sparkline style to a sparkline chart. To do so, he can click on the following: Sparkline chart > Design > Style (choose a style). T or F

False

Changing a worksheet window to Normal View changes the contexts of the worksheet

False

Decreasing a cell's indent moves its contents to the right one space.

False

In formulas, Calculations in square brackets are calculated first. T or F

False

The Comma Style format adds a comma and a dollar sign to a cell value. T or F

False

To preserve an exact cell address in a copied formula, you can use a relative cell reference. T or F

False

To print a worksheet contents at cross the portrait orientation. T or F

False

When you change cell contents to italics, you are changing the cell's alignment. T or F

False

When you enter a value in cell, it is automatically left-aligned. T or F

False

You can use the I-beam pointer to copy cell contents into adjacent cells. T or F

False

You have selected a cell with a formula. What can you use to copy that formula to an adjacent cell?

Fill handle

formula bar

The area above the worksheet grid where you enter or edit data in the active cell.

active cell

The cell currently selected in the active sheet.

cell

The column letter and row number location that identifies a cell within a worksheet or table such as A1.

edit mode

The mode in which you can make changed to a cell's content directly in the cell.

destination area

The range of cells to which you are pasting.

If you discover an error immediately after you have confirmed a cell entry, what can you do?

The undo button on the Quick Access toolbar

Currency is an example of a number format. T or F

True

to enter data in a cell using examples already in your workbook, you can use the flash fill feature. T or F

True

Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek.. from the drop down menu. What is the X procedure.

What-IF analysis

What is true when you delete a cell?

When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells

when should you use relative cell references?

When you want to preserve the relationship tot eh formula location

How can you remove split panes in a worksheet you are working on?

Click the View tab in the Ribbon, then click the split button in the Window group

in-cell editing

Editing the contents of a cell directly in the cell.

To enter a range of text based on examples that are already in your worksheet, what can you use?

Flash Fill

Relative cell reference

In a formula, a cell address that automatically changes to reflect the new location when the formula is copies or moves; the default type of referencing use in Excel worksheets; also called a relative reference.

Absolute cell reference

In a formula, a cell address that refers to a specific cell and does not change when you copy the formula.

SUM function

In excel, a function that adds all the numbers in a range of cells.

What would you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X?

Insert Pie or doughnut chart

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Page Break Preview

copy area

The cell(s) being copied.

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click insert tab, select Line Sparkline from the Sparklines group and then OK . T or F

True

The easiest way to insert the SUM function is to use the AUTOSUM button on the home tab. T or F

True

To Move a worksheet, you can drag its sheet tab to the left or right

True

To apply formats to data when it meets criteria you can specified you can use conditional formatting. T or F

True

To format the cell value 44.54 as 44.540, you can use the increase decimal button

True

To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER. T or F

True

To rotate cell contents, you use the Alignment tab in the Format cells dialog box. T or F

True

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze top row. T or F

True

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in a formula?

$A$5

The default worksheet text is __ -ping calibri

11

These score of students in a subject in inserted in B2 cell and the passing score for the subject is 60. What function will you insert in C3 cell to check if the student has passed or failed?

=IF(B2>=60, "Pass", "Fail")

fill handle

A black square that appears in the lower-right corner of a selected cell or range; used to fill adjacent cell with duplicate or similar data.

name box

A box to the left of the formula bar that shows the cell reference or name of the active cell.

relative reference

A cell reference that changes when the formula containing that reference is moved to a new location.

Mixed cell reference

A cell reference that changes when the formula containing that reference is moves to a new location.

source area

A chance of cells you are cutting or copying.

Two-input data table

A data table in which you can vary the value in two cells and then see the recalculated results

Goal seek

A feature that reverses the trial-and-error process by allowing you to specify an output value and then working backwards to find the input value needed to reach that goal

PV function

A function that returns the present value of an annuity.

FV Function

A function that reuters the future values of an investment based on scheduled payments and an unchanging interest rate.

range

A group of cells in a rectangular block in a worksheet, also called a cell range.

Cell name

A name assigned to a cell or cell range that can be used in formulas

function

A named operation that replaces the action of an arithmetic expression.

One-input data table

A range of cells that shows resulting values when one input value in a formula is changed

Amortization schedule

A schedule that shows loan balances and the payment amounts applies to principal and interest for each payment period.

What-if analysis

A way to explore the impact that changing input values has on calculated values and output values.

AutoCalculate area

An area on the Excel status bar where you can view a total, an average, or other information about a selected range.

In the Formula =SUM(A6:A9), what describes A6

Argument

What inserts a function into a cell?

AutoSum button

What feature inserts a function that totals the cells above or to the left of the selected cell?

AutoSum function

What function would you use to calculate the arithmetic mean of a price list?

Average

You have cut the range A1:A5, and want to paste it to C1:C5. what do you do?

Before you paste it, you only need to select c1 and After you paste it, the information is deleted from the original location.

To select nonadjacent cells or ranges on a worksheet, you can press and hold ___ while selecting each one

CTRL

To accept a suggested spelling for that instance only, what would you click?

Change

To return to cell contents to its default font and style, you can use the ___ command

Clear formats

To help you easily identify sheets in a workbook, you can add ___ to the sheet tab.

Color

To format a range so that all values greater than $500 appear in red, what can you use?

Conditional formatting

To copy a cell's formatting to another cell, what can you use?

Format Painter

To apply a cell style, you would use the cell styles command on the ___ tab

Home

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

If it needs an absolute cell reference

The spell checker flags your company's name is misspelling. What can you do to stop the spell checker from flagging later occurrence in the documents?

Ignore all

IF function

In Excel, a function that assigns a value to a cell based on a logical test

NOW function

In Excel, a function that returns a number that corresponds to the system date and time. Beginning with December 31, 1899.

Format symbols

In Excel, a symbol that assigns a format to numbers as they are entered.

Where can you see a brief description of a selected function?

Insert function dialogue box

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations

To combine multiple cells into one combines cell, what would you do?

Merge and Center button

To rotate cell contents to an exact value, you change its ___

Orientation

What type of chart can you not add axis titles on?

Pie Chart

Where can you see a preview of how your worksheet will look when printed, including headers?

Print tab in backstage View

In the formula = A8*$A$1, which the following describes A8

Relative cell Reference

Nisha wants to freeze all rows above row 4 in worksheet she is working on to keep them visible while scrolling though the rest of the worksheet. What clicks does she need to make

Row 4 > View tab > Windows group > freeze panes > freeze panes

Steffie wants to change the margins of a worksheet to normal to align it better on a printed page. to do this, what can she do after selecting the worksheet for this purpose.

Set width and height to automatic and scale to 100% in the scale to fit group on the page layout tab

You can edit cell contents in the Formula bar or in the cell itself. T or F

True

You can use the Delete key to clear cell contents. T or F

True


Kaugnay na mga set ng pag-aaral

1: Completing the Application, Underwriting, and Delivering the Policy

View Set

Alcoholism Final Problem Questions

View Set

Chapter 11 Principles of Pharmacology

View Set

Chapter 18: Questioned Documents

View Set