Excel theory test

Ace your homework & exams now with Quizwiz!

Which of the following is an absolute cell reference?

$B$6

Because Excel follows the standard mathematical order of operations, it will calculate the formula =4+2*3 to which of the following?

10

Which of the following cell entries would not be treated as text by Excel?

12.5

In Excel, which of the following formulas will return a result of 33?

=(5+6)*3

Imagine that cells C1:C7 contain the hours an employee worked each day for one week. Cell B3 contains the employee's hourly wage. You want to insert a formula in cells D1:D7 that will calculate the employee's earnings for each day. Which of the following formulas, when entered in cell D1 and then copied down the rest of the column, will give you the correct results?

=C1*$B$3

Which of the following is the correct formula for adding the contents of cell C2 to the contents of cell C3?

=C2+C3

Which of the following formulas should you use to find the total of a range of values located in rows 5 through 15 of column F of an Excel worksheet?

=SUM(F5:F15)

Which of the following functions will cause the current date to display in the active cell?

=TODAY()

Which of the following cell entries will not produce the current date?

=TODAY{}

What type of software application is Microsoft Excel?

A spreadsheet program

To print a worksheet with the formulas displayed, you may first need to do which of the following?

Adjust the orientation or margins

To change the way a value is displayed in a cell, you can

Apply a format

With the buttons in the Alignment group on the Home tab, you can do all of the following except

Apply conditional formatting

In Excel, dates are stored _____ so they can be used in calculations.

As sequential serial numbers

You can customize Excel's _____ feature to correct typos you make often, such as transposing two letters in your name.

Autocorrect

Which of the following is not a correct example of a cell range?

B4:8J

To use the Auto Fill feature, make a cell active and then hover the mouse pointer over the lower right corner until the mouse pointer becomes a

Black crosshair

If you move a formula containing a relative reference and an absolute reference to a new location, what will happen?

Both cell references will remain the same

Suppose that cell D3 is the active cell. To make cell A1 active, you can press F5 and then type A1, or you can press

CNTRL+Home

Assume that you own a store and need to calculate the number of sales transactions that took place in one day. Which of the following functions should you use?

COUNT

Using the _____ key allows you to select multiple items, including multiple worksheet tabs.

CTRL

You can apply a format to multiple cells scattered aournd a worksheet by clicking one of the cells, pressing and holding the _____ key, and then clicking the other cells one by one.

CTRL

Use the keyboard shortcut ____ to display formulas

CTRL+'

Press _____ to finish an entry without moving the active cell to another cell.

CTRL+Enter

To apply several formatting settings at once, use the

Cell Styles gallery in the Styles group on the Home tab.

In Excel, the column letter and row number that identifies each cell can be called by each of the following terms except

Cell range

To delete a row, select any cell in the row, click the Delete arrow in the _____, and then click Delete Sheet Rows.

Cells group on the home tab

After using Excel's Merge & Center feature, be sure to

Check all formatting to see if any has changed

Which of the following options is not available on the Clear button in the Editing group on the Home tab?

Clear Errors

Apply _____ to help readers spot trends and patterns in data.

Conditional formatting

When you type 6/12 into a cell, Excel automatically applies the _____ format.

Date

If a cell is not wide enough to display a long text entry and the cell to the right of it also contains text, what will Excel do?

Display as much of the entry as fits in the original cell

Which of the following methods is most efficient for handling multiple sets of related data?

Divide the data into several worksheets in the same workbook

How can you automatically adjust the width of a column to fit the size of the longest entry?

Double click the right border of the column heading

Press _____ to clear the scrolling marquee that surrounds a cell range you have selected and cut.

ESC

To fill a row of cells with the entry in the leftmost cell, click the Fill button in the _____ and then click the Right option.

Editing group on the home tab

To open a cell for editing, you can double-click the cell or press _____.

F2

To create an absolute cell reference, you can type dollar signs ($) before the column and row references, or you can press _____ after typing the cell reference.

F4

After you merge a range of cells, the cell reference that appears in the Name box is the address for the _____ cell(s) in the merged range.

Far left

The Borders button is located in the _____ group on the Home tab.

Font

Change the fill color of a cell or range of cells by clicking the Fill Color arrow in the

Font group on the home tab

To change the height of a row, begin by clicking the

Format button in the Cells group on the Home tab.

To copy the format settings from one cell to another, use the _____ tool.

Format painter

If the contents of a cell display only partially in the cell, you can look at the _____ to see the entire contents.

Formula bar

To insert a function in the active cell, you can use the buttons in the function library group on the ____ tab.

Formulas

The ____ function permits you to test a condition and perform different computations based on the result

IF

What should you do if you accidentally delete a row or column?

Immediately click the undo button

By default, the Accounting format displays negative values

In parentheses

Where is the Autosum button?

In the editing group on the home tab

If a large number in a cell displays as a series of pound signs (###), you must _____ for the contents to display properly.

Increase the column width

If you don't know the exact name of the function you need, you can enter a description of what you want to do using the

Insert function dialog box

How many cells can an Excel worksheet contain?

It depends on the RAM

Which of the following best describes Excel's Auto Fill feature?

It enables you to copy an entry across a row or down a column or create a series of entries across a row or down a column.

Which of the following is not one of the advantages mentioned in Chapter 3 of using the color palette supplied by the theme?

It reduces the size of a workbook file

If you do not type the year when entering a date, what does Excel do?

It uses the current year

Which of the following is not a default setting for the Accounting format?

Left alignment

When you increase the font size of the text in a cell, you may need to

Manually adjust column width or row height

If you want to center the title in cell C3 across columns C, D, and E, drag to select the range C3:E3 and then click the

Merge & Center button

The AVERAGE function is located in the Statistical category, which can be accessed by clicking the _____ button in the Function Library group on the Formulas tab.

More functions

To create a copy of Sheet1, right-click the Sheet1 worksheet tab, click _____, click the Create a copy check box, and then click OK.

Move or Copy

Chapter 2 suggests that key data referenced by formulas throughout a worksheet should be placed _____ to make them more accessible.

Near the top of the sheet

To change the format of a value, click the Number Format arrow in the

Number group on the home tab

Which function should you use to calculate your payments for a car loan?

PMT

When you click the Header & Footer button on the Insert tab, Excel switches to _____ View.

Page Layout

Changing the theme of a worksheet changes all the following characteristics except

Page setup

Most Excel functions require that one or more arguments be surrounded by which of the following?

Parentheses

Which of the following formatting buttons is not found in the Font group on the Home tab?

Percent style

Which of the following types of cell entries is left-aligned by default?

Phone numbers

Which of the following printing options is not available in the Settings section of the Print backstage area?

Print text only

To rename a tab, _____ the tab, click Rename, type the new name, and then press Enter.

Right-click

How can you change the color of a worksheet tab?

Right-click the sheet tab, point to Tab Color, and then click the color you want.

You can remove the data from a range of cells using any of the following methods except which one?

Select the range and then press F1.

To display all the formulas in a worksheet at once, click the _____ button in the Formula Auditing group on the Formulas tab.

Show Formulas

Which of the following characters can be used in a worksheet name?

Space ( )

To preview the result of an autosum function, drag over a range of cells and then check the

Status bar

What does Excel's spelling checker feature review?

Text

Use the Outline button to place a border around

The entire selected range

How can you move the active cell from cell B5 to cell K43?

Type k43 in the name box

After you complete a fill, options on the Fill button allow you to modify the fill. These options include all of the following except which one?

Undo Fill

Which of the following line styles is not among those available when you click the More Borders option on the Borders button?

Wavy

When you open Excel you can create a blank

Workbook containing one worksheet

Rather than type a cell reference into a formula, you can _____ to add it to the formula.

click the cell on the worksheet

To adjust the default column width for a workbook, start by

clicking the Format button and then clicking Default Width.

Excel _____ if a cell is not wide enough to display a long number.

displays a string of pound signs (####)

When pasting a range of cells, click the Paste Options button and then select the Transpose option to

paste the cells vertically if they were originally horizontal and vice versa.

Accountants often emphasize a row of data totals in an Excel worksheet by

placing a single border at the top and a double border at the bottom.

Font size is measured in

points

To insert a column, _____ and then click Insert.

right-click the column heading

How are columns labeled in an Excel worksheet?

with capital letters (A, B, C, ...)


Related study sets

Configuring a basic Apache Server

View Set

The Skeletal System - Adv. Biology

View Set

Spring Study Guide (World History)

View Set

🍾🥂🍾best questions 2nd respiratory 🍾🥂🍾

View Set

BUS230 - Human Resources Quiz #1

View Set