Study guide period 7 Ahmad Pressie
Which code inserts the name of the tab for the current worksheet into an Excel footer?
&[Tab]
How many inches does the default tab move when you press thetab button?
1/2 inch
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? Look up Date Formats)
9//15
What should you enter in a cell to 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)
If a cell is not largeenough to display a number, _____ will display.
A #
A _____ is the basic unit of a worksheet into which you enter data
A cell
Which type of cell address will be adjusted in the new location based on the relative position of the original formula's input cells?
A relative cell address
What is the difference between a workbook and a worksheet?
A single page in a file prepared with an electronic spreadsheet tool such as Microsoft Excel or Google Sheets is referred to as a worksheet. An Excel file with one or more worksheets is referred to as a workbook.
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 rows and columns,and change the chart type.
You can do all the following to a picture except:
Alter the coloring
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.
A group of cell format settings (such as font, size and color) which can be applied to a cell is called a(n):
Cell styles
The Bullet command is located on the _______ tab.
Home
What shows the point on the screen where the next character will be entered?
INSERTION POINT or CURSOR
You might want to use a chart in your worksheet to:
Identify trends or patterns in the data.
The Header and Footer commands are located on the ________tab.
Insert
To add shapes and illustrations to aworksheet, you use commands on which tab of the Ribbon?
Insert
Which of the following is the Quick Analysis Tool used for?
Insert charts, sparklines, pivot tables, and conditional formatting.
What Tab do you need to select to add a chart?
Insert tab
When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab appears:
Inserting or Deleting WorksheetsWhen inserting a new worksheet using the Insert command in the Cells group of the Home tab the worksheet is inserted to the left of the active worksheet.
Change the ___________ to make a document appear in landscapeformat.
Layout
When the alignment is set to General, text values align to the _______ in a cell.
Left
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 identifywhich of the following for corrective action:
Misspelled names of people.
Which of the following is the correct order of precedence for standard math operators?
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 values using the data in several cells?
None - all are valid formulas
To create a table, the followingconditions must be met:
The data in the range of cells must be contiguous, and be arranged in row (not column) order
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 needto export Excel data to a Comma Separated Values (CSV) file?
The data table
Which tab would you need to use to place a table in your Word document?
The insert tab
The ________ wavy line indicates a potential spelling error.
The red line
What is the name of the area that contains all the tabs andcommands?
The ribbon
Where will you find the options you need to export Excel data to a Comma Separated Values (CSV) file?
The save as dialog box
What Tab do you need to select to see the document views thatare available?
The view tab
To divide the value of a cell by some number, use the_____operator.
To do this task, use the / (forward slash) arithmetic operator. For example, if you type =10/5 in a cell, the cell displays 2.
When converting a range of data to atable, why do you need to tell Excel whether or not the data hasheaders?
To ensure that the first row of data is treated as the column headers and not included with thedata.
How do you add another worksheet to a workbook?
To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, click Insert, and then click Insert Sheet.
If you have a worksheet that containsboth a chart and the data for the chart, you have the ability to selectonly the chart to print on its own.
True
Multiple levels of sorting are useful whenever the column you are 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 samecolumn such as AVERAGE and MAX.
True
The workbook properties includes the dateand time when the workbook was last modified and saved.
True
You can add any Excel command to theQuick Access Toolbar including those that are not in the Ribbon tabthat is currently active.
True
You can modify all styles and themes.
True
You can search a worksheet for everyoccurrence of a value (text label or number), function name, or cell reference.
True
Text, numeric and formula are examples of:
Types of data.
How many new worksheets can you add to an Excel workbook?
Unlimited
When should you use Save As instead of just Save?
Use Save as when you want to change the name, location and format of the document.
Suppose you used 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.
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 in excel 97-2003 format
How do you select different areas of a worksheet at the same time? (Which key do you hold?)
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, whereas when you click 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 notidentify 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 to page layout settings.
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 Dean to print an appropriate version of the worksheet for his meeting?
You may want to hide rows or columns when you want to prevent other users from seeing the data in these hidden rows or columns. In other situations, you may be improving the readability of your worksheet by reducing the number of rows or columns of data to print together on a single page, or to hide cells that only contain intermediate calculations for otherwise complex formulas.
You should create a new workbook using a template when: (What are templates used for?)
You want to use a design layout previously created, either to enter data or to use as a base for your own reports
What is a page break?
a point at which a piece of continuous text is split into two pages.
Why is word processing software an effective way to work withdocuments?
automatically correct common errors and identify misspellings, improving overall speed and reducing errors.
A range name cannot contain a(n):
blank score
The Column command is located on the ______ tab.
layout
The _____ box displays the active cell reference.
name
Use the ___________ to resize a text box.
resizing handles
The paper orientation of this page is
the direction of rectangular paper for viewing and printing.
What is a margin?
the part of a page or sheet outside the main body of printed or written matter
When would you use the Help feature?
to provide the answers that a user needs to understand to use the program effectively.
Carol has inherited a large worksheet which contains accurate data, but the data has been entered in various fonts, colors, and alignments. Carol's manager has asked her to give the worksheet a more business-like 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 ten minutes so that the worksheet will be ready for an upcoming meeting. What should Carol do?
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 of the following comparison operators can be used for filtering text, numbers, and dates:
The Save As dialog box
Which types of formatting can you applyto both pictures and clip art?
Colors, artistic effects, visual styles, picture effects
Which of the following are chart types supported in Excel?
Column, line, XY (scatter chart).
What is the difference between pressing Delete to delete the contents of a cell and using the Delete Cells command?
Deleting the contents of a 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.
What is Excel used for?
Excel is used to store, analyze, and report on large amounts of data. It is often used by accounting teams for financial analysis,
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 feature will reliably delete all rows that contain duplicate data even though the data may have minor variations such as extra blanks, commas, or different spellings.
False
You can insert only images that are installed on your computer.
False
Which of the following are types offormatting 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 lose strack of which column she is working in. Whatcan 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.
How many series of data can be shown on a pie chart?
One
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 an Internet web page
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
In the ___________ dialog box, you can change both Line andParagraph spacing.
Paragraph
Which of the following types of chart is suited for displaying relative sizes (or percentages) of each piece of a total?
Pie
The Auto-hide Ribbon, Show Tabs, and Show Tabs and Commands options are available when you click which button?
Press Ctrl+F1
Setting the _____ to A1:L10 will print only data in those cells.
Print Area
When the alignment is set to General, numeric, date 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 revised file as Budget 2017. Which command should she use?
Save as
In order to save an existing document with a different nameyou need to
Save as
Before you can change the shape fillcolor of a graphic object, you must:
Select it
How to Add a link to an Image:
Select the cells. Press CTRL+C. Go to a target cell. From home ribbon select Paste > As picture > Picture link option
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 the 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.
To key a word in all-caps on the computer, depress the
Shift key
"AD" is an example of a _____.
TV, radio, & newspaper advertisements.
What is the name of the small Toolbar at the top of thewindow that can show commonly used features such as save and undo?
The Quick Access Toolbar
