PC Office Excel

Quiz yourself by thinking what should be in each of the black spaces below before clicking on it to display the answer.

Help!

Question

Answer

An Excel complex formula uses for than one arithmetic operator.

True

🗑

Predefined formulas in Excel are called functions and can be accessed using the Insert Function Button.

True

🗑

An Absolute cell reference changes the cell references when the formula is copied to a new location

False

🗑

Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells.

True

🗑

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5)

False

🗑

Which type of cell reference preserves the exact cell address in a formula?

Absolute

🗑

Excel templates make creating a professional looking spreadsheet easier by including all of the following except ______ in the template.

Formulas Formatting Labels DATA

🗑

Excel templates include which of these categories?

Budgets Time sheets Expense Reports ALL OF THE ABOVE

🗑

To continue a sequence in adjacent cells, such as months of the year, use the _____feature of excel.

Fill Handle

🗑

In Excel, MAX and AVERAGE are examples of _____.

Functions

🗑

When cells are copied using the Excel's copy function, what happens to the data in the copied cells?

The data remains in its original location

🗑

When cells or rows inserted or deleted in an Excel worksheet, how are the cell references affected by the insertion or deletion?

Cell references are automatically adjusted

🗑

An Excel user should use a relative cell reference when it is important to ______.

Preserve the relationship to the formula location.

🗑

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?

🗑

The file extension .xltx indicates what type of Excel file?

Excel Template

🗑

The default file extension for a Excel 2010 workbook is ______.

.xlsx

🗑

Which tab and group will allow the insertion of rows and columns in a worksheet?

Home Tab Cells Group

🗑

All functions begin with the formula prefix ____.

equals sign =

🗑

Which method of entering a function requires the user to know the name and initial characters of a function?

manually typing the function

🗑

Once the Office Clipboard reaches the maximum of 24 items, how does it handle new items that are copied or cut?

The clipboard automatically deletes the oldest item on the clipboard.

🗑

Charts are updated automatically in Excel whenever data changes.

True

🗑

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

True

🗑

In Page Layout view, the dotted line indicates the print area.

True

🗑

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

Spreadsheet

🗑

In Excel, a worksheet is contained in a file called a _____.

Workbook

🗑

______below the worksheet grid let you switch from sheet to sheet in a workbook.

Sheet Tabs

🗑

All Excel formulas begin with the____.

equal sign =

🗑

The Excel operator for exponent is ___.

🗑

The Excel operator for division is ___.

🗑

A ____ is an entry in a cell that contains text such as "2011 sales" or "Travel Expenses."

Label

🗑

A_____ is a built in formula that uses arguments to calculate information.

Function

🗑

Excel recognizes an entry as a value if it is a number or it begins with ____.

+ = $ ALL OF THE ABOVE

🗑

You can use the _____key on the keyboard to navigate a worksheet.

Arrow

🗑

You can edit the contents of the active cell by ______.

Just starting to type

🗑

You can use the ______slider on the status bar to enlarge your view of specific areas of your worksheet.

Zoom

🗑

A dark rectangle that outlines the cell in which you are working

Cell Pointer

🗑

Provides a brief description of the active command or task in progress.

Status bar

🗑

Identified by the coordinates of the intersecting column and row

Cell Address

🗑

Work done in a virtual environment

Cloud Computing

🗑

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

False

🗑

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

True

🗑

To format a cell or range, first you select it, and then you apply the formatting using the _____ or a a keyboard shortcut.

Ribbon

🗑

The default Accounting number format adds dollar signs and _______decimal places to the data.

two

🗑

You can apply attributes and alignment options using the _____dialog box.

Format Cells

🗑

Double-Clicking the column line to the right of a column activates the ____feature for the column.

AutoFit

🗑

You insert a comment in a a worksheet by using the ______tab on the Ribbon.

Review

🗑

A small, _____ triangle appears in the upper-right corner of a cell containing a comment.

Red

🗑

The formatting due to ____formatting is automatically updated if you change data in the worksheet.

Conditional

🗑

##### in a cell mean that the ______.

column is too narrow to display the value completely

🗑

Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.

To hide a column, click on the column name.

To hide the entire table, click on the "Hide All" button.

You may also shuffle the rows of the table by clicking on the "Shuffle" button.

Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Created by: srentrop