"Excel" Test Review

20 terms by thelalliers

Create a new folder

Advertisement Upgrade to remove ads

Questions from the Microsoft Office 2010 Excel exam.

formula

This bar displays entries as they are made and edited in the Excel workbook window. (EX1.5)

=SUM(A1:D1)

Which of the following functions is written in the correct syntax? (EX1.39)

themes

The predefined sets of formatting choices that can be applied to an entire workbook are called what? (EX2.16)

data

You can switch the rows and columns of a chart using what section of the Chart Tools Design tab? (EX2.38)

panes

You can display different sections of a worksheet at the same time by creating: (EX3.34)

formatting

Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called ____. (EX1.50-68)

relative

Whenever a formula containing ____ references is copied, the referenced cells are automatically adjusted by Excel. (EX1.39)

freeze the titles

Excel allows you to ____, so that Excel displays the titles on the screen, no matter how far down or to the right you scroll. (EX3.37-40)

data series

In a chart, the ____ is the related data points that are distinguished by different colors or patterns, called data markers, and displayed in the plot area. (EX2.25)

insert

Once you have selected worksheet data, the commands to insert a chart type are located on the ____ tab in the Charts group. (EX2.24-28)

split window

The ____ feature allows you to divide a worksheet window into sections, making it easier to view different parts of the worksheet at the same time. (EX3.34)

cell

The intersection of each column and row is called a ____. (EX1.7)

error checking

You can check formulas for errors by clicking the ____ button in the Formula Auditing group on the Formulas tab on the Ribbon. (EX3.4-7)

embedded objects

Excel Charts that are inserted into a worksheet are called ____. (EX2.9 & EX2.29)

Causes cells with two decimal places to align vertically correctly

What effect does the Accounting Number Format have on the selected cells? (EX1.62-63)

click Save As on the File menu

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

left-aligned

When a cell entry is positioned at the far left in the cell, it is considered ____. (EX1.51-53)

range

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. (EX1.31)

recalculates all

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

CTRL key while pressing the ACCENT MARK (`)

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set