Digital Information Technology Final Exam Flash Cards Olivia Freiberg
Which code inserts the name of the tab for the current worksheet into an Excel footer?
&[Tab]
To divide the value of a cell by some number, use the ? operator.
/
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? (Formula?)
=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)
How many series of data can be shown on a pie chart?
A pie chart can include only one series of data.
Which type of cell address will be adjusted in the new location based on the relative position of the original formula's input cells? (Relative vs. Absolute Cells)
A relative cell address
If a cell is not large enough to display a number, _____ will display.
A row of hashes.
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 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.
How to Add a link to an Image:
Adding Hyperlinks to Images in Word 1. Insert the image into the document. 2. Right-click the image and select "Link" from the drop-down menu. 3. Type or paste the hyperlink address into the "Address" field.
"AD" is an example of a _____.
Advertising
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 range name cannot contain a(n):
Blank Space.
How many inches does the default tab move when you press the tab button?
By default, every time you press the Tab key, the insertion point will move 1/2 inch to the right.
To key a word in all-caps on the computer, depress the
Caps Lock
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, 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? (Look for formatting options.)
Clear all existing formatting and then apply a theme to the worksheet.
Which types of formatting can you apply to both pictures and clip art?
Colors, artistic effects, visual styles, picture effects.
You can do all the following to a picture except:
Convert it to a movie
What shows the point on the screen where the next character will be entered?
Cursor/ Insertion Point: The cursor (also known as the insertion point) is a flashing vertical bar on the screen that indicates where entered text or objects will be placed in the document.
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.
Which of the following comparison operators can be used for filtering text, numbers, and dates:
Equals and Does not equal
Which of the following are chart types supported in Excel?
Excel Chart Types: Pie, Column, Line, Bar, Area, and Scatter.
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? ( T or F )
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
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 in. 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.
Where will you find the options you need to export Excel data to a Comma Separated Values (CSV) file?
Go to File > Save As. Click Browse. In the Save As dialog box, under Save as type box, choose the text file format for the worksheet; for example, click Text (Tab delimited) or CSV (Comma delimited).
Where will you find the options you need to import data from a text file into Excel?
Go to the Data tab > Get External Data > From Text. Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open.
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.
The Bullet command is located on the _______ tab.
Home Tab
You might want to use a chart in your worksheet to:
Identify trends or patterns in the data.
In the ___________ dialog box, you can change both Line and Paragraph spacing.
In the Paragraph dialog box, you can change both line and paragraph spacing.
To add shapes and illustrations to a worksheet, you use commands on which tab of the Ribbon?
Insert
The Header and Footer commands are located on the ________tab.
Insert Tab
Which tab would you need to use to place a table in your Word document?
Insert Tab then click the Table command.
What is a page break?
Insert a page break when you want to move to the beginning of the next page in your document.
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 is an Excel feature that temporarily changes the appearance of the selected cell(s) to the format that your mouse is currently pointing to on the Ribbon. If you move your mouse away, the selected cell(s) revert to their current format.
The Auto-hide Ribbon, Show Tabs, and Commands options are available when you click which button?
Looking at the Screen > Using the Ribbon. The Ribbon Display Options button includes the following three choices: Auto-hide Ribbon, Show Tabs, and Show Tabs and Commands.
What is a margin?
Margins are the blank spaces that line the top, bottom, and left and right sides of a document. They are important because they help make a document look neat and professional. To change margins, click on the Margins button, found on the Page Layout tab.
What is the maximum length of a worksheet tab name?
Microsoft Excel does not allow worksheet name longer than 31 characters.
Which of the following is the correct order of precedence for standard math operators?
Multiplication, Division, Addition, Subtraction.
Which of the following are not valid formulas for calculating values using the data in several cells? (Be able to understand formulas in Excel)
None - all are valid formulas
How many new worksheets can you add to an Excel workbook?
Note. Although you're limited to 255 sheets in a new workbook, Excel doesn't limit how many worksheets you can add after you've created a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer's memory.
What Tab do you need to select to add a chart?
On the Insert tab, in the Illustrations group, click Chart.
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
The Column command is located on the ______ tab.
Page Layout Tab
Change the ___________ to make a document appear in landscape format.
Page Orientation
The paper orientation of this page is
Page orientation is the direction in which a document is displayed or printed. The two basic types of page orientation are portrait (vertical) and landscape (horizontal). Most monitors have a landscape display, while most documents are printed in portrait mode.
Which of the following types of chart is suited for displaying relative sizes (or percentages) of each piece of a total?
Pie
Setting the _____ to A1:L10 will print only data in those cells.
Print Area
Use the ___________ to resize a text box.
Resizing Handles
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
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 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.
Text, numeric and formula are examples of:
Text, numeric and formula are examples of: Types of data.
Which number format does not allow you to control how negative numbers display?
The Accounting Format
The Document Inspector will not identify which of the following for corrective action:
The Document Inspector will not identify which of the following for corrective action: Misspelled names of people. 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.
When the alignment is set to General, text values align to the _______ in a cell.
The Left.
The ____ box displays the active cell reference.
The Name Box
What is the name of the small Toolbar at the top of the window that can show commonly used features such as save and undo?
The Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Redo commands.
Which of the following is the Quick Analysis Tool used for?
The Quick Analysis tool helps you quickly format your data into a chart, table, or spark line. The Quick Analysis function helps you quickly format your data into a chart, table, summary formula, spark line, or highlighted figures with just a few simple steps.
What is the name of the area that contains all the tabs and commands?
The Ribbon is a user interface element which was introduced by Microsoft in Microsoft Office 2007. It is located below the Quick Access Toolbar and the Title Bar. It comprises seven tabs; Home, Insert, Page layout, References, Mailing, Review and View.
When the alignment is set to General, numeric, date and time values align to the _______ in a cell.
The Right
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 that are available?
The View tab enables you to switch between Normal or Master Page, and Single Page or Two-Page Spread views.
A _____ is the basic unit of a worksheet into which you enter data.
The correct answer is cell. The basic unit of an Excel spreadsheet where we enter data is known as a cell. Every worksheet is composed up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column.
To create a table, the following conditions must be met:
The date in the range of cells must be contiguous, and be arranged in row (not column) order
When would you use the Help feature?
The help system's purpose is to provide the answers that a user needs to understand to use the program effectively.
The ________ wavy line indicates a potential spelling error.
The red line indicates a misspelled word.
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.
To insert an Excel worksheet: (How do you add another worksheet to a workbook?)
To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.
When you insert a new worksheet using Insert, Insert Sheet on the Home tab, the new worksheet tab appears: (Where on the screen will it appear?)
To the right of the current worksheet tab.
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
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 same column such as AVERAGE and MAX.
True
The workbook properties includes the date 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 insert only images that are installed on your computer.
True
You can modify all styles and themes.
True
You can search a worksheet for every occurrence of a value (text label or number), function name, or cell reference.
True
When should you use Save As instead of just Save?
Use Save when you do not want to change the name and location of the document. Use Save as when you want to change the name, location and format of the document.
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.
Which dialog box can be used to add, modify or delete named ranges in a worksheet?
Use the Name Manager dialog box to work with all the defined names and table names in a workbook.
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 Formats option.
In order to save an existing document with a different name you need to
Use the Save as command
Ruby wants all the entries in Column D in her worksheet to display fully. What is the best method for ensuring Column Dis wide enough?
Using the AutoFit command.
How do you open another view of the active workbook?
View multiple worksheets at the same time 1. Click a worksheet that you want to view. 2. On the View tab, in the Window group, click New Window. 3. Repeat steps 1 and 2 for each sheet that you want to view.
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.
Why is word processing software an effective way to work with documents?
Word processors contain software to automatically correct common errors and identify misspellings, improving overall speed and reducing errors. They also makes it easier to create and organize new files as well as retrieve and manipulate existing ones.
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 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 use an electronic spreadsheet if you want to: (What is Excel used for?)
You should use an electronic spreadsheet if you want to: Perform a large number of mathematical calculations and display charts and graphs.
You should create a new workbook using a template when: (What are templates used for?)
You want to use a design and layout previously created, either to enter data or to use as a base for your own reports.