CIS Final

In the Print dialog shown in the accompanying figure, the ____ instructs Excel to print the worksheet currently on the screen or the selected worksheets.

Active sheet(s) option button

To import data stored on a Web site use a ____.

Web query

________ are a collection of worksheets.

Workbooks

The ____ button, in the accompanying figure, allows you to view the page in larger or smaller sizes in the Preview window

Zoom

What effect does the Comma Style format have on the selected cells?

causes the cells to display with two decimal places and commas as thousands separators

To save a previously saved workbook with a new name or on a different drive, ____.

click the Save button on the Quick Access Toolbar

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

The process of finding and correcting errors in a worksheet is called ____.

debugging

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the

destination area

Which of the following is a suggested decision to make when you plan a workbook?

determine the necessary functions and formulas needed

To check the spelling of the text in a single cell, ____ to make the formula bar active and then click the Spelling button on the Review tab on the Ribbon.

double-click the cell

A(n) __________ chart is drawn on the same worksheet as the data.

embedded

Longer worksheet names also can mean that ____ sheet tabs will show.

fewer

Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called __________.

formatting

The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.

formulas version

As with column widths, when you decrease the row height to 0, the row is ____.

hidden

Saving the workbook frequently is important for the following reason:

if you lose power it could be lost.

When a cell entry is positioned at the far left in the cell, it is considered __________.

left aligned

In Excel, a number can contain the characters __________.

0 1 2 3 4 5 6 7 8 9 $ % E e + - ( ) , /

How many chart types does Excel offer?

11

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.

1932

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________.

6E15

When Excel starts and the blank worksheet displays on the screen, all of the columns have a default width of ____.

8.43 characters, or 64 pixels

In excel 2007, which of the following formulas are invalid:

=MIN(A2-A3)

All of the following are valid Excel arithmetic operators except ____.

>

o start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.

ALT+ENTER

Click ____ in the Conditional Formatting gallery to display the New Formatting Rule dialog box.

New Rule

When you click the __________, located in the upper-left corner of the window as shown in the accompanying figure, Excel displays the Office Button menu.

Office Button

Which view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page Layout View

In the accompanying figure, the Page Setup button displays the ____ dialog box.

Page Setup

__________ is a scam in which a perpetrator sends an official looking email that attempts to obtain a users personal and financial information

Phishing

The speed of data transfer has become important lately because:

Pictures and audio are dense with information

In access, a field that identifies a particular record in a table is called a:

Primary key

Excel does not display the Print dialog box shown in the accompanying figure when the ____ is used.

Print button on the Quick Access Toolbar

In Access, the wildcard symbols available for use in a query are the:

Question mark (?) and astericks (*)

In the accompanying figure, the __________ , located by default above the Ribbon, provides easy access to frequently used commands.

Quick Access Toolbar

__________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

Range

You can ensure correctness in your formulas by carefully checking them using ____.

Range Finder

The person or persons requesting the worksheet should supply their requirements in a __________ document.

Requirements

Hiding the ____ will allow a larger portion of the worksheet to be visible.

Ribbon

In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.

Ribbon

When you open an Excel file, the application name (Microsoft Excel) is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n) __________.

ScreenTip

An operating system such as MS Windows, Mac OS or Linux manages:

Security

In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print the selected range.

Selection option button

What name does Excel give the first blank worksheet?

Sheet1

Dividing a cell into more than one cell is called __________.

Splitting

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.

Standard

A(n) __________ is a list of additional commands associated with the selected command.

Sub-menu

On the Ribbon each __________ surrounds a collection of groups.

Tab

In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________.

Text

In the accompanying figure, what will be printed when you click the OK button?

The active worksheet

While Excel is saving your file, it briefly displays a message on the status bar indicating __________.

The amount of the file saved

When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.

Trace Error

What effect does the Accounting Number Format have on the selected cells?

causes cells with two decimal places to align vertically correctly

In Excel, functions can be entered using any of the following methods except the ____.

Function command on the Tools menu

In the accompanying figure, the __________ tab is called the primary tab of the Ribbon.

Home

Which keyboard key moves the insertion point to the beginning of data in a cell.

Home

Secured web pages being with:

Https

Using the ____ button on the Ribbon instructs Excel to display additional decimal places in a cell.

Increase Decimal

The commands to insert a chart are located on the __________ tab, as shown in the accompanying figure.

Insert

Which key on the keyboard toggles between Insert mode and Overtype mode?

Insert

The ____ button lists formatting options following an insertion of cells, row, or columns.

Insert Options

If you prefer using the keyboard, instead of the mouse, you can press the ALT key on the keyboard to display a(n) __________.

Key tip badge

The number of worksheets that a workbook can contain is __________.

Limited by computer memory

Combining two or more cells together is called __________ cells.

Merging

In the acccompanying figure, the __________ button and __________ button next to the Help icon, are used to minimize and restore the worksheet within the Excel window.

Minimize, Restore

How many file formats does Excel offer for saving a workbook?

More than 30

Popular ________ software includes word processor and spreadsheet software

Application

In the accompanying figure, by using the __________ area on the status bar, you easily can obtain a total, an average, or other information about the numbers in a range.

AutoCalculate

___ means that the width of the column will be increased or decreased so the widest entry will fit in the column.

Best fit

What is the title of the blank workbook that opens when you first start Excel from the Windows Start menu?

Book 1

To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.

CTRL key while pressing the ACCENT MARK (`)

The __________ button on the Home tab is the only command that clears both the cell entry and the cell formatting.

Clear

If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column's width.

Column Width

The intersection of each column and row is called a __________.

Column-row

Access is a:

Database management system

How do you activate Range Finder to verify a formula in a cell?

Double-click in the cell

In the accompanying figure, what is the first step in renaming the worksheet?

Double-click the worksheet tab.

In the Print dialog box shown in the accompanying figure, the ____ instructs Excel to print all the worksheets with content in the workbook.

Entire workbook option button

To alert excel that you are entering a formula and not text, type an _________ proceding the formula

Equals sign (=)

You can check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon.

Error Checking

E-mailing a workbook from Excel sends the workbook as a(n) ____ in the e-mail.

attachment

file name can have a maximum of 255 characters, including spaces. The only characters not allowed are the __________.

less than symbol (<), greater than symbol (>), and vertical bar (|) asterisk (*), question mark (?), quotation mark (") backslash (\ ), slash (/), colon (:)

The __________ toolbar, which appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet.

mini

The formulas version verifies that you entered formulas, rather than ____, in formula-based cells.

numbers

To rename sheets, double-click the sheet tab in the lower-left corner of the window, type the new sheet name, and then

press the ENTER key

Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.

recalculates all

To instruct Excel to display a hidden column, position the mouse pointer to the ____.

right of the column heading boundary where the hidden column is located and then drag to the right

In the accompanying figure, to move between worksheets, use the ____ to the left of the sheet tabs.

tab scrolling buttons

If a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks ____.

the remainder of the worksheet, including notes and embedded charts

Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook.

worksheet

Excel opens a new workbook with three __________ , as shown in the accompanying figure.

worksheets