Introduction to Computers Excel 1, Introduction to Computers Excel T2, Introduction to Computers Excel T3
AZ" is an example of _______
Column Heading
The formula bar displays the value or formula of the active cell.
true
The formula used to multiply cell A1 by cell C1 is _________.
=A1*C1
In the formula =IF(A1=B1), C1, C2), the result will be C2 if ______
A does not equal B
Which of the following is not an Excel function category? A) Statistical B)Text C) Math & Trig D) Algebra
Algebra
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
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers or cell references? A) AUTOSUM B) COUNT C) COUNTA D) SUM
Count
_________ are examples of conditional formats in Excel.
Data Bars
A footer appears at the top of each printed page.
False
After you merge a range into a single cell, you cannot realign its content.
False
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line.
False
The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.
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 the content or formatting you want to locate.
Find
Italic, bold, bold italic, and underline are examples of _________.
Font Styles
Which of the following is a Math & Trig function? A) AVERAGE B) COUNT C) INT D) MIN
MIN
To avoid splitting a worksheet in awkward places, you can insert a ______ to specify a specific breaking point.
Manual Page Break
Another name for the middle value is the ______ value.
Median
Options to rotate cells in Excel are available using the _________ button in the Alignment group on the Home tab.
Orientation
A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created.
True
A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command.
True
AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.
True
Changing the number of decimal places displayed in a cell does not change the value stored in the cell.
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
Formatting changes only the appearance of data-it does not affect the data itself.
True
The background image does not affect any cell's format or content.
True
The worksheet is organized into individual cells.
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?
When text wraps within a cell, the column width increases so that all of the text within the cell is displayed.
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
Use _________ reference when you want different formulas to refer to the same cell.
absolute
The characters +, -, *, and / are examples of _________
arthritic operators
An Excel formula always begins with a(n)__________.
equals sign
The _________ category of Excel functions returns (true-false) values
logical
A ________ is the space between the page content and the edges of the page.
margins (?)
In _________ orientation, a page is taller than it is wide.
portrait
The advantage of an electronic _____ is that the content can be easily edited and updated to reflect changing financial conditions.
spreadsheet
Functions are organized in the Function Library group on the FORMULAS tab.
true
