Excel theory test
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, ...)
