Business Software Applications Excel Exam
The code _____ will display the filename of the current workbook.
&[File]
The Format Cells dialog box has six tabs, including _____.
Border
A(n) __________ is a named operation that replaces the arithmetic expression in a formula.
Function
Ctrl + G is used to access the _____.
Go to a location in the worksheet command
What is the result of the expression =50+20/10*5?
60
What is the syntax for a SUM formula adding the values of cell F6 to F9?
=SUM(F6:F9)
mm/dd/yyyy is known as _____.
A date formal
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.
A1
The formula used to multiply cell A1 by cell C1 is _____.
A1*C1
If you want to create a new line within a cell, press the _____ keys to move the insertion point to the next line within the cell.
Alt + Enter
When you copy a selection of cells using drag and drop, which appears before you release the mouse button?
An outline of the new location of the selected range
The characters +, -, *, and / are examples of _____.
Arithmetic operators
_____ makes it easier to enter repetitive text in cells.
AutoComplete
As general rule, you should _____.
Center column titles, left-align text, and right-align numbers
To remove conditional formatting in Excel, click __________ after clicking the Conditional Formatting button.
Clear Rules
When you __________ a workbook, a dialog box might open, asking whether you want to save the workbook.
Close
Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a _____.
Colon
The __________ function will not include any cell in the range containing a non-numeric value in the final tally.
Count
To make A1 the active cell, you should press which of the following keys?
Ctrl + Home
You can move to the previous or next sheet by pressing the _____ keys.
Ctrl + Page Up or Ctrl + Page Down
_____ are an example of conditional formats in Excel.
Data bars
__________ removes the data from the row or column as well as removes the row or column itself.
Deleting
Header and footer elements such as worksheet name, current date, and time are _____ elements.
Dynamic
To switch to _____ mode, you double-click the cell.
Edit
An Excel formula always begins with a(n) _____.
Equals sign
According to the order of operation in Excel:
Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
Which of the following takes precedence over multiplication?
Exponentiation
A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell.
False
A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.
False
An adjacent range is a collection of separate ranges.
False
By default, AutoFill copies only the content not the formatting of the original range to the selected range.
False
By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin.
False
Functions are organized in the Function Library group on the FORMULAS tab.
False
Optional arguments are always placed first in the argument list.
False
Speed Fill enters text based on patterns it finds in the data.
False
The cell reference for the merged cell is the upper-right cell reference.
False
The name of the active workbook appears in the status bar of the Excel window.
False
The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.
False
To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function.
False
When text wraps within a cell, the column width increases so that all of the text within the cell is displayed.
False
To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.
Fill color
The _____ command searches through the current worksheet or workbook for content or formatting you want to locate.
Find
_____ enters text based on patterns it finds in the data.
Flash Fill
Italic, bold, bold italic, and underline are examples of _____.
Font styles
The __________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
Format Painter
One of the benefits of conditional __________ is that it helps you analyze data by highlighting significant trends in data.
Formatting
A(n) __________ is text printed in the top margin of each page.
Header
To go to column A of the current row, press _____.
Home
To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point.
Manual page break
A _____ is the space between the page content and the edges of the page.
Margin
One way to align text over several columns or rows is to __________, or combine, several cells into one cell.
Merge
_____ merge each of the rows in the selected range across the columns in the range.
Merge Across
The range reference for a(n) __________ range includes the range reference to each range, separated by a semicolon.
Nonadjacent
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.
Number
Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.
Numbers
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.
Orientation
_____ displays the location of the different page breaks within the worksheet.
Page Break Preview
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.
Painter
To change the order of operations, enclose part of the formula in _____.
Parentheses
A(n) __________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
Planning analysis sheet
In _____ orientation, a page is taller than it is wide.
Portrait
Setting the _____ to A1:L10 will print only data in those cells.
Print Area
The region that is sent to the printer form the active sheet is known as the __________.
Print area
Information that prints on each page, like a company name or logo, may be set as a _____.
Print title
The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.
Protection
When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness.
Red and green
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
Right
When you insert a new column, the existing columns are shifted to the _____ and the new column has the same width as the column directly to its left.
Right
Which of the following will not change the location of the active cell?
Scrolling
To move the active cell up one row, press _____.
Shift + Enter
Keyboard __________ can help you work faster and more efficiently because you can keep your hands on the keyboard.
Shortcuts
A _____ indicates a manual page break.
Solid blue line
A(n) __________ is a grouping of text and numbers in a rectangular grid or table.
Spreadsheet
A(n) __________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.
Theme
Fonts, colors, and cell styles are organized in _____ categories.
Theme and non-theme
A conditional format applies formatting to a cell when its value meets a specified condition.
True
A conditional format can make negative numbers red and positive numbers black.
True
A constant is a value in a formula that doesn't change.
True
A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command.
True
An argument can be any type of value including text, numbers, cell references, or even other formulas or functions.
True
An error value begins with a pound sign (#) followed by an error name that indicates the type of error.
True
By default, Excel displays text in a black font color.
True
Calculated values too large to fit into the cell are displayed in scientific notation.
True
Changing the number of decimal places displayed in a cell does not change the value stored in the cell.
True
Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.
True
Cutting moves the selected content, whereas copying duplicates the selected content.
True
Each header and footer has three sections - a left section, a center section, and a right section.
True
Every function follows a set of rules, or syntax, which specifies how the function should be written.
True
Excel organizes fonts into theme and non-theme fonts.
True
Formatting changes only the appearance of data - it does not affect the data itself.
True
If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer.
True
In the formula, =2+6*2, addition would be calculated after multiplication.
True
Lookup tables can be constructed for exact match or approximate match lookups.
True
Numeric data is any number that can be used in a mathematical calculation.
True
One challenge of nesting functions is to make sure that you include all of the parentheses.
True
The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data.
True
The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false.
True
The formula bar displays the value of formula of the active cell.
True
The worksheet is organized into individual cells.
True
When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.
Turn it off
