Business Review
Which code inserts the name of the tab for the current worksheet into an Excel footer?
&[Tab]
What is the maximum length of a worksheet tab name?
31 characters
Which of the following entries will not be recognized as a date by Excel?
9//15
What should you enter a name so do you find the difference between 9 and 5?
=9-5
Which of the following formulas says: if the value in cell B6 is greater than 500, then display a value equal to B6*20; otherwise, display a zero?
=IF(B6>500,B6*20,0)
Which type of cell address will be adjusted in the new location based on the relative position of the original formula as input cells?
A relative cell address
What is the difference between a workbook and a worksheet?
A worksheet is a document divided into columns and rows, whereas a workbook is a single Excel file containing one or more worksheets.
Which number format does not allow you to control how negative numbers display?
Accounting
Which of the following are changes you can make to a chart design?
Add a chart title or legend, select a different chart layout, exchange the data rose and columns, and change the chart type.
Which of the following is not permitted as a delimiter character?
All of the above characters are permitted to be used as delimiters.
Banding a table means to:
Apply a light and dark shade of a color to alternating rows or columns of a table
Ed has created a worksheet of sales projections, and the numbers Change daily. He would like all projected sales figures over 25,000 to display in purple. What is the easiest way to accomplish this?
Apply conditional formatting to the projected sales figures.
How many new worksheets can you add to an Excel workbook?
As many as the available memory of your system will permit.
A group of cell format settings (Such as font, size, and color) which can be applied to a cell is called a(n):
Cell style
Carol has inherited a large worksheet which contains accurate data, Could've been worse but the data has been entered in various fonts, colors, and alignments. Carol's manager has asked her to give the worksheet a more businesslike appearance - one or two typefaces is okay, And so are a few colors, but they need to be more unified. Her manager has asked Carol to complete this task in 10 minutes so that the worksheet will be ready for an upcoming meeting. What should Carol do you?
Clear all existing formatting and then apply a theme to the worksheet
How do you open another view of the active workbook?
Click the New Window button
Which types of formatting can you reply to both pictures and clipart?
Colors, artistic effects, visual styles, picture effects
Which of the following are chart types supported in Excel?
Column, line, XY(scatter plot)
What is the difference between pressing Delete to delete the contents of a cell and using the delete cells command?
Deleting the contents of the cell leaves the structure of the worksheet intact. If you use the Delete Cells command, you have the option of shifting the cells after the delete action is complete.
Which of the following person operators can be used for filtering text, numbers, and dates:
Equals and Does not equal
Which key/combination activates edit mode in Excel
F2
The LEFT and MID functions are fully interchangeable. in other words, can you always use the LEFT function instead of MID, as well as using MID instead of LEFT?
False
The Remove Duplicates future will be reliably delete all rose that contain duplicate data even though the data may have minor variations such as extra blanks, commas, or different spellings.
False
You can remove the Save, Undo, and Redo buttons from the Quick Access Toolbar.
False
Which of the following are types of formatting options can you apply to a graphic object?
Fill or outline color, Reflection, Three-dimensional rotation, Shadow effects
Sarah is entering weekly sales data for week 37 of the current year, however, when she moves down to the cells where she needs to enter the data, the column headings scroll out of view and sometimes she loses track of which column she is working on. What can Sarah do to keep the column headings visible even while she is working in a distant portion of the worksheet?
Freeze the panes
Sam has painstakingly created a worksheet of sales figures for the Eastern region. His worksheet is beautifully formatted and contains accurate formulas. Now he needs to create a worksheet just like it for the Western region. How should Sam proceed?
He should create a copy of the Eastern worksheet, rename the copy western, and then enter the figures as appropriate.
Dean needs to print a worksheet for distribution at a meeting. The worksheet currently includes sensitive information that Dean needs to see, but which should not be seen by the meeting attendees. What is the easiest way for a dean to print an appropriate version of the worksheet for his meeting?
Hide with the rows or columns that contain the sensitive information before printing the worksheet
You might want to use a chart in your worksheet:
Identify trends or patterns in the data
To add shapes and illustrations to a worksheet, you use commands on which type of the Ribbon?
Insert
Which of the following is the Quick Analysis Tool used for?
Insert charts, spark lines, pivot tables, and condition formatting.
When the alignment is set to General, text to values aligned to the ____ in a cell.
Left
Which of the following are types of sparkling charts?
Line, Column and Win/Loss
Which feature temporarily changes the appearance of selected cell(s) to the format that your mouse is currently pointing to on the Ribbon?
Live Preview
The Document Inspector will not identify which of the following for corrective action:
Misspelled names of people
Which of the following is the correct order of precedence for standard math operator?
Multiplication, division, addition, subtraction
Which dialog box can be used to add, modify or delete named ranges in a worksheet?
Name Manager dialog box
Which of the following are not valid formulas for calculating a statistical that are you using the data in several cells?
None- all are valid formulas
A hyperlink in a workbook can be used to:
Open a different workbook that is stored on your computer, jump to another cell in the same worksheet, launch and Internet webpage.
Denise needs to print a report that will be inserted into a larger report, and therefore needs the page numbering to begin at 312. In which tab of the Page Setup dialog box can she specify this beginning page number?
Page
You should use an electronic spreadsheet if you want to:
Perform a large number of mathematical calculations and display charts and graphs.
Which of the following types of chart is suited for displaying relative sizes(or percentages) of each piece of a total?
Pie
If you want to access Ribbon using the keyboard, you should:
Press the Alt or F10 key
The Auto-hide Ribbon, Show Tabs and Commands Options are available when you click which button?
Ribbon display options
When the alignment is set to General, numeric, data and time values align to the ____ in a cell.
Right
Amanda has just updated her Budget 2016 Workbook with new values for 2017. She wants to save her revise file as Budget 2017. Which command should she use?
Save as
Before you can change the shape fill color of a graphic object you must:
Select it
Before submitting a worksheet full of accounting formulas to his boss, Ken wants to make sure that he has entered all of the formulas correctly. There are a lot of them. What is the easiest way to perform this check?
Set the options for the worksheet to show the formula in every cell instead of calculated results
Andrea needs to print a 7-page report of inventory figures. The column headings print only on the first page of the report. What should she do to ensure the column headings print on every page?
Set the row with the column headings as a print title
Where will you find the options you need to import data from a text file into excel?
The Data Tab
Where will you find the options you need to export Excel data to a Comma Separated Values (CSV) file?
The Save As dialog box
Where will you find the options you need to export Excel data to a Comma Seperated Values (CSV) file?
The Save As dialog box
To create a table, the following conditions must be met:
The data in the range of cells must be contiguous, and be arranged in row(not column) order
When converting a range of data to a table, why do you need to tell Excel whether or not the data has headers?
To ensure that the first row of data is treated as the column headers and not included with the data
When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab appears:
To the right of the current worksheet tab.
Which of the following correctly identifies the different parts of the following reference: Tours!B4
Tours is the name of the worksheet and B4 is the cell reference.
Multiple levels of sorting are useful whenever the column you were using for sorting has multiple rows with the same value
True
Once you have added a set of subtotals (for example, SUM) for a column of numeric data in a range of cells, you can also add more subtotals for the same columns such as AVERAGE and MAX.
True
The workbook properties includes the data and time when the workbook was last modified and saved
True
You can add any Excel command to the Quick Access Toolbar including those that are not in the Ribbon tab that is currently active.
True
You can search a worksheet for every occurrence of a value (text label or number), function name, or cell reference.
True
if you have a worksheet that contains both a chart and the data for the chart, you have the ability to select only the chart to print on its own.
True
Text, numeric and formula are examples of:
Types of data
You need to share your Excel 2016 workbook with a colleague who uses Excel 2003. What should you do?
Use the Check Compatibility Tool to inspect the workbook for any compatibility issues with Excel 2003, then save your workbook and Excel 97-2003 format
Suppose you use the Copy and then the Paste command to copy the contents of cells A1 to cell B1, but you do not want to copy the cell formatting to cell B1. what can you do to fix it?
Use the Paste Special command instead, and select the Values option.
How do you select different areas of a worksheet at the same time?
Use the ctrl key as you click to select other cells
Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for ensuring Column D is wide enough?
Using the Autofit Command
What is the difference between clicking the Format Painter once and clicking it twice?
When you click it once, you can apply the formatting attributes to only one other cell or range, where as we clicked it twice, you can apply the formatting attributes to as many cells or cell ranges as you want until you turn it off.
The Accessibility Checker Tool will not identify which of the following for corrective action:
Worksheet cells that do not have volume controls to assist people who are hearing impaired
What of the following are benefits of previewing a worksheet prior to printing?
You can avoid wasting paper due you to page layout settings
You should create a new workbook using a template when:
You want to use a design and layout previously created, either to enter data or to use as a base for your own reports.
A range name cannot contain a(n):
blank space
