Excel

What code does Excel insert when you click the Current Date button in the Header and Footer Tools Design tab?

&(date)

When you save a workbook in a Excel 97-2003 format, the ___ extension is applied

.xls

By default, Excel 2010 workbooks are saved with the _____ extension

.xlsx

How many rows can an Excels 2010 workbook contain?

1,048,576

Excel stores up to ___ actions that can be undone or redone using buttons on the Quick Access toolbar

100

A header contains ____ sections

3

A formula is said to contain a ___ reference when it references a cell spanning two or more worksheets

3-D

By default, Excel column widths are set at ___ characters and rows heights at ___ points

8.34; 15

Which of the following is an example of a formula with a 3-D reference?

=SUM('Qtr4'!E4)

Which of the following examples makes use of a Range

=Sum(D2:R2)

When you use the Formula AutcoComplete list box to enter a formula, the first portion of the function is inserted in the active cell, and the required syntax for the arguments appears in

A Screentip

You can edit a chart by right clicking one of its elements to display

A context sensitive shortcut menu

Without pointing to it, how can you tell if a cell contains a comment?

A dialog red triangle appears in the upper right corner

When you sort a table by one of its Columns from largest to smallest what appears in the filter button for the sort column?

A down pouring black arrow

What picture appears on the Microsoft Office Excel Help button near the upper right corner of the screen?

A question mark

Normally, what does the average function take as its argument?

A rag be of cells containing numeric values

Inserted rows are placed ____ the selected rows and inserted columns are placed to the ___ of the selected columns

Above; left

Excel's spelling check feature begins checking at the

Active cell

What does the Add Level button I the sort dialog box do?

Adds another row to the dialog box so you can sort by additional columns

Excel's accounting number format adds____ to the value in the cell

All of the above

The default setting in Excel's print dialog box are to print one copy of

All pages in the active worksheet

This keyboard movement come and move the active cell one screen to the left

Alt + Page up

_____ is the command to insert a line break within a cell

Alt+Enter

In page break preview, frayed out cells

Are not within the print area

How are time values stored in Excel?

As decimal numbers that represent the portion of the day

When you click the insert worksheet button, where is the new worksheet placed?

At the end of the existing sheets

By default, Excel aligns values

At the right edge of the column

When you type data in a row immediately below an existing table, Excel

Automatically expands the table and applies the same formatting

When you change the color of the fill in a cell, you are changing its

Background

In page break preview page breaks are shown as ___ lines

Blue solid or broken

Excel templates contain text that you type over and replace with your own texts this text appears in the templates in an italic font and is enclosed in

Brackets ()

What does Excel's Freeze pane option do?

Causes the specified rows and columns to remain fixed while scrolling

Which of the following methods can be used to print more than one worksheet at once?

Change the setting to print entire workbook. Change the setting to print active sheets in the backstage view

Column, line, pie, bar, are and scatter are types of excel

Charts

How do you open the Zoom dialog box?

Click over the 100% label at the left edge at the zoom slider bar

After you have filtered a table, how do you get Excel to once again display all the records?

Click the clear filter Click the select all check box on the filtered columns drop down list A or b

How do you create a shape in your worksheet using the shapes button?

Click the desired shape, and then click and drag in the worksheet to draw the shape

How can you displays a list of range names to make editing or deleting them easier?

Click the name manager button in the defined name group on the formulas tab

If you do not want to widen a column what can you do to fit the text into the column?

Click the wrap text button in the Alignment group

To search the Internet for all types of media, use the ___ button in the Insert tab

Clip Art

Does the Ctrl+F4 keyboard shortcut do

Close a workbook

The clear all option in the Clear button removed the ___ from the active cell

Contents, formats, and comments

What does the Format Painter feature do?

Copies formats from a selected cell to another cell

You can copy the contents of a cell by using either the copy and paste function or to fill handle feature

Copy and paste copies to continents to the clipboard fill handle does not

When the active cell contains a formula dragging the Fill handle causes Excel to

Copy the formula and change to cell references relative to each destination location

Use the button in the Picture Tools Format tab to cut an inserted Clip Art image or picture to remove unwanted parts

Crop

Holding down this key while dragging a sheet tab will create a copy of the worksheet in the new position

Ctrl

You can group multiple no adjacent worksheets by holding down the ___ key while clicking each tab

Ctrl

Keyboard shortcut open the print dialog box

Ctrl + P

The keyboard shortcut for cutting the selection and placing it on the Clipboard is

Ctrl + X

The keyboard shortcut for repeating a command us

Ctrl+Y

Which of the following is not one of the groups of shapes listed on the shapes button?

Cycle

Excel's split window feature allows you to view___ at the same time

Different sections of the same way shape

To create an absolute cell address, type this character in front of the cell column letter or row number that you do not want to change

Dollar sign

When changing a column width by dragging the boundary lineup the right or left, a___ is displayed to indicate the new width

Dotted line

To copy a format from the active cell and paste it multiple times to other cells begin by ___ the format painter button

Double clicking

This action sets the width of a column to fit the longest entry in in the column

Double clicking the boundary line

What is displayed in the drop down list when. You click a filter arrow button in an Excel table?

Each unique value that exits in the column. All of the above

The selected data source dialog box allows you to modify your chart by

Editing axis labels. Adding or deleting a data series. Adding or deleting cells in the original source range. All of the above

One way to access Help resources in Excel is to point to a button in a tab and then press the ___ function key

F1

This keyboard shortcut displays the Save As dialog box

F12

When editing a cell address, pressing ___ causes Excel to insert dollar symbols in front of the row and column nine r immediately to the left of the insertion point

F4

What is the black square at the bottom right corner of an active cell?

Fill handle

A ___ is used to display only certain records within a table that meet the specified criteria

Filter

When you format a range of cells as a table, Excel displays ___ in the first row of the table

Filter arrows

Excel's PMT function returns a payment amount for a loan based on a

Fixed period. Constant payment. Constant interest rate. All of the above

The ___ is the typeface used to display and print data. It is measured in ___ is

Font; points

This part of the Excel screen displays the contents of the active cell

Formula bar

When you point at the border of a selected range cells, the mouse pointer changes to a white arrow with the move icon attached. The move icon is represented by a

Four-headed arrow

Excel features built-in, preprogrammed formulas called

Functions

Which cell format is used by default in Excel?

General

In which tab will you find the insert button

Home

When a chart is selected three contextual chart tools tabs become available. Which of the following is not one of them?

Insert

Which of these buttons can be used to find an excel function by typing a description of the formula?

Insert Function

Immediately after you have drawn a text box in your worksheet, a ___ appears inside the box, indicating you can begin typing the text

Insertion point

How does Excel place comments in a worksheet?

It anchors them to the active cell

By default, how does Excel handle the users access to online help features?

It checks for a live internet connection whenever the help feature is activated

Which of the the following statements describes how the Borders button changes?

It updates to display the most recently selected border style

How does the Average function deal with empty cells and containing a zero value?

It uses the zero values in the calculation but ignores the empty cells

Dates in Excel are stored as a serial number starting with ___ as 1 and inCreasing sequentially

January 1, 1900

A ___ is an entry in a cell that helps the reader understand the values in the corresponding column or row.

Label

The Find&Replace dialog box can be used to search for and replace

Labels, values and formats

In an Excel worksheet, columns are referenced with____ while rows are referenced with____

Letters, numbers

This type of Excel chart is used to depict trend and change over time intervals

Line

What is the first argument required by Excel's built in IF function?

Logical _ test

On which tab of the page setup dialog box will you find options for centering your worksheet horizontally and or vertically on the page?

Margins

To center text between the top and bottom of a cell, click the ___ button in the Alignment group on the Home tab

Middle Align

When included a formula which of the following operators does Excel calculate first?

Negation

The options for choosing a template are contained in the

New tab backstage view

You can decrease the number of decimal places displayed in a number by clicking the Decrease Decimal Button, which is located in the____ in the ___ tab

Number; Home

How many data series does a pie chart generally use?

One

Ctrl+F is the keyboard shortcut for

Opening the Find and Replace dialog box

The ___ button in the Alignment group in the Home tab can be used to rotate text within cells

Orientation

Which file format will preserve Excel fonts and formatting when worksheets are shares with users who do not have Excel on their computers?

PDF and XPS A and b

The themes group is located in the ___ tab

Page Layout

Which view displays horizontals and vertical rules to assist with measurements?

Page break preview

___ view allows you to see your worksheet along with the print settings

Page layout

This type of Excel chart is especially useful in showing a data points size in proportion to the total of all points in the data source range

Pie

When you hold down the Ctrl key and drag a selected range of cells, a ____ attached to the pointer indicates that the source contents are being ___

Plus sign; copied

Which button in the File Print Backstage view allows you to change the page orientation from portrait to landscape ?

Portrait orientation

One of the arguments needed in the PMT function is pv. What does pv stand for?

Present value

You want to specify rows and column to repeat on each printed page if your worksheet. Begin by clicking this button in the page setup group in the page layout tab

Print Titles

Which of the following options is/are available by clicking Print o the File tab?

Printer, settings, preview of how the worksheet will look when printed. All of the above

The Excel print option is available from the Quick Access toolbar

Quick print

A group of adjacent cells in an Excel worksheet is called a

Range

By default when a formula is copied and pasted from one cell to another, Excel automatically changes the cell address to reflect the destination location this is referred to as___ addressing

Relative

When copying or moving cells, if data already exits in the destination cells, Excel

Replaces the contents

To insert a comment, click the new comment button in the comments group in the __ tab

Review

How do you activate the worksheet shortcut menu?

Right click the worksheet tab

By default, Excel aligns date entities at the ___ of the column

Right edge

Which of the following statements correctly describes the relationship between row height and font size

Row height is automatically increased size accommodate an increased in font size

When you convert a file to a different format in Excel 2010 you do this in the

Save as dialog box

When navigating a worksheet, which of the following methods does not move the position of the active cell?

Scrolling with the scroll bar

The first step in creating an excel chart is to

Select the range of cells containing the data to be charted

To change margins in your worksheet, click the Margins gallery in the ___ category in the Print tab Backstage view

Settings

Which of the following characters can not be used when creating a range name?

Space

Small charts that illustrate changes in a row or column of a data and fit in a cell are called

Sparkline

To which function category do these Excel built in functions belong : COUNT, MAX and AVERAGE?

Statistical

Excel provides__ so that you can easily create a professional, consistent worksheet appearance

Styles

Opening an Excel file created in a version earlier than 2007 or 2010 causes Excel to

Switch to compatibility mode, in which you can work with the file in its origin format

By default, Excel sorts data alphanumerical my, which means entries are sorted in this order

Symbols first, then numbers then letters

To Ungroup grouped worksheets click Ungroup sheets in the

Tab shortcut menu

Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called

Templates

Suppose a cell in your worksheet contains this formula: B$*0.5. How would this formula change if it were copied to another cell?

The column will change but the row will remain fixed at row 7

What happens when you click the increase indent button

The contents of the active cell are indented approximately one character width

All formulas in Excel begin with

The equals sign (=)

One component of an Excel function is the argument. What is an argument?

The values identified within the functions parentheses

What happens if you type a format in a table column?

The word total is added to the leftmost cell in the row below the table All of the above

What happens when you change the value of a cell that is referenced elsewhere in a formula?

The worksheet is automatically recalculated so that all values are current

What happens when you click and drag a sheet tab in Excel?

The worksheet is moved to a different position in the workbook

Selecting which of the formatting options will always change the entire worksheet?

Themes

This Excel feature can be used to replace a word in the worksheet with another word of similar meaning

Thesaurus

A new Excel workbook initially contains

Three worksheets named sheet 1 , sheet 2 and sheet 3

Section 1 suggests that when working with formulas in Excel it is a good idea to create proof formulas.

To check the computations in your formulas

A chart can be modified when it is checked and its border becomes

Translucent

The freeze pane buttons is located in the group in the ___ tab

Window; View

Information created in Excel is saved in a file called a

Workbook

The portion of the excel screening containing the lettered columns and numbered rows is called the

Worksheet area

The default file format for an Excel 2007 Excel 2010 workbook is

XML