Excel – Flashcard
Unlock all answers in this set
Unlock answersquestion
T/F: A template opens as a new workbook with the template name and a letter
answer
False
question
T/F: You can apply one-, two-, and three-color scales to a range
answer
False
question
T/F: The multiplication symbol in a formula is a /.
answer
False
question
T/F: To multiply by a percent, you must key the decimal equivalent of the percent
answer
False
question
T/F: You can control the order of precedence in a formula with parentheses
answer
True
question
T/F: Division is calculated before addition in a formula without parentheses
answer
True
question
T/F: Column widths adjust automatically when you display formulas
answer
False
question
T/F: An absolute reference does not adjust when the formula is copied to another cell
answer
True
question
T/F: To complete most functions, you must include their arguments
answer
True
question
T/F: icon sets display an image in the range based on the value
answer
True
question
T/F: The SUM function calculates a text value as 1.
answer
False
question
T/F: The first character for all functions is a left parenthesis
answer
False
question
T/F: The TODAY function does not have arguments
answer
True
question
T/F: When creating a custom format for a date, use ? to show days and *to show months
answer
False
question
T/F: Most statistical functions ignore text in their calculations
answer
True
question
T/F: You can copy data from one worksheet to another with the Fill handles
answer
False
question
T/F: You can repeat the most recent command by pressing ctrl+R
answer
False
question
T/F: You must always key quotation marks around text that you key in a Function Arguments dialog box as value if true and value is false results
answer
False
question
T/F: The AND and OR functions usually show the same result
answer
False
question
T/F: All financial functions include a rate argument
answer
False
question
T/F: Arguments in a function are separated by commas
answer
True
question
T/F: The Cell Styles gallery includes styles for values as well as labels
answer
True
question
T/F: The PMT function determines how much your money will grow over a period of time
answer
False
question
T/F: The Print Titles option can repeat rows or columns on each page of a worksheet
answer
True
question
T/F: The INT and Round functions use the same arguments
answer
False
question
T/F: An integer is a whole number, a nondecimal number
answer
True
question
T/F: Excel uses a serial number system for dates
answer
True
question
T/F: A nested function is placed in the cell below the first formula
answer
False
question
T/F: You can hide a worksheet in a workbook
answer
True
question
T/F: A hyperlink is a blinking cell with a formula
answer
False
question
T/F: An XLS file has all the same features and functions as an XLSX file
answer
False
question
T/F: To convert a fraction of a day to hours, multiply by 365.25
answer
False
question
What is the term used to describe a function inside a function?
answer
Nested Function
question
What would this function display in the cell =INT(3.5643)?
answer
3
question
What button, when clicked, reveals the Top/Bottom Rules command?
answer
Conditional Formatting
question
What does a hyperlink do?
answer
1. opens another file 2. displays an email address 3. Places you in a different location on that document 4. shows a webpage
question
Which function inserts the current date (not the time)?
answer
TODAY
question
How can you convert days into years?
answer
divide by 365.25
question
How would Excel display this value =ROUND(1.567,2) in the cell?
answer
1.57
question
Name two functions that are often used in nested formulas
answer
If; Round
question
Name the three types of data visualizations (conditional formatting)
answer
1. Icons 2. Data Bars 3. Color Scales
question
How can you select more than one worksheet tab?
answer
Ctrl or Shift
question
Name the function that adds cell values only if they meet your criteria
answer
Sumif
question
What function displays the arithmetic mean of a range of cells?
answer
Average
question
What does Excel do if a function is volatile?
answer
Uses the date and time based on the computer the workbook is opened on
question
What term is used to describe the information between parentheses in a function?
answer
arguments
question
What feature helps you complete a function after you key = and its character in the cell?
answer
Formula AutoComplete
question
What function would display the highest sales amount in a column?
answer
MAX
question
What is the keyboard shortcut to display or hide formulas?
answer
ctrl + ~
question
Which page orientation is taller than it is wide?
answer
Portrait
question
How would the cell reference $F$3 be described?
answer
absolute
question
What are the four arithmetic symbols that can be used in a formula?
answer
+,-,/,*
question
What type of operation is being performed in the formula =A4*B4?
answer
multiplication
question
What command option allows you to print a worksheet on a smaller piece of paper?
answer
Adjust to __% of normal size
question
What term describes a model workbook used as the basis for other workbooks?
answer
template
question
How can you start Edit mode to edit a formula?
answer
F2, or double click on cell
question
What dialog box helps you complete built-in functions with entry boxes for each argument?
answer
Function Arguments dialog box
question
Which argument in a financial function refers to the total number of periods (also the total number of payments or deposits)?
answer
Nper
question
Which logical function shows the opposite of the condition?
answer
Not Function
question
Which Excel feature lets you see the results of a cell style before applying it?
answer
Live Preview
question
Which command tab includes choices for page breaks and print titles?
answer
Page Layout
question
How can you distinguish between an automatic page break and one that you placed?
answer
automatic page breaks are dashed; manual page breaks are solid
question
Which financial function would help you determine how much money will be in your account at the end of a year if you make regular deposits?
answer
FV function
question
What is the purpose of the Type argument in financial functions?
answer
It tells if payment will be at beginning or end of period.
question
T/F: Inserted cells do not affect the position of existing cells.
answer
False
question
T/F: A column is hidden when it is frozen
answer
False
question
T/F: Freezing rows and columns locks them in position on the screen
answer
True
question
T/F: AutoComplete fills in formulas and cell addresses
answer
False
question
T/F: Data bars are relative to the cell's value
answer
True
question
T/F: Fill creates a thick dashed border around cell borders
answer
False
question
T/F: The Merge and Center command works for multiple rows and columns.
answer
False
question
T/F: The Windows Clipboard and the Office Clipboard both store 12 items of cut or copied data
answer
False
question
What two commands help you enter labels in columns that already have many labels in them?
answer
AutoComplete, Pick from drop-down list
question
If you want to repeat a lengthy label several times throughout a worksheet, would you cut or copy it?
answer
Copy
question
What does the term "drag and drop" mean?
answer
method of cut, copy, and paste by using the mouse to select and drag to a new location
question
What is the default alignment for values and dates in a cell?
answer
right aligned and bottom
question
What command will lock rows and columns in positions on the screen?
answer
Freeze
question
What command combines several cells into one cell?
answer
Merge and Center
question
What alignment option allows a label to split within a cell?
answer
Wrap text
question
T/F: A chart sheet includes the related worksheet data
answer
False
question
T/F: A selected chart element displays selection handles and a bounding frame
answer
True
question
T/F: The markers for a line chart can be formatted separately from the line.
answer
True
question
T/F: Excel determines the best type of chart for your data after you select the data.
answer
False
question
T/F: Some chart layouts do not include a chart title.
answer
True
question
T/F: If you insert a new item in the range used in a chart, you add a data point.
answer
True
question
T/F: Each slice in a pie chart represents a data series.
answer
False
question
T/F: The chart style includes colors for the plot area as well as other chart elements.
answer
True
question
What name describes a chart that appears on the worksheet with the data?
answer
Embedded chart
question
What command tab includes the chart layout and style choices?
answer
Design tab
question
What is the keyboard shortcut to create a chart sheet?
answer
F11
question
What term describes a blend of colors for filling a bar or column?
answer
gradients
question
What can you use when two data series have drastically different values?
answer
Secondary axis w/ combo
question
What happens if you delete a data series used in a column chart from the worksheet?
answer
Column disappears
question
What is a data table?
answer
It lists the values and names displayed in the chart
question
T/F: If you key THe as part of a label, Auto Correct will automatically fix the error.
answer
True
question
T/F: The Replace command can be used to locate and change the font size.
answer
True
question
T/F: The Spelling command completes columns of month or day names.
answer
False
question
T/F: You can format data as a table if it has a header row followed by data rows
answer
True
question
T/F: The Fill handle displays a small hollow circle
answer
False
question
T/F: A series is a list with a recognizable pattern
answer
True
question
T/F: The option to print a selected range is in the Page Layout dialog box.
answer
False
question
How can you collapse the Ribbon?
answer
Double-click on active tab
question
Name the feature that enables you to automatically complete a list of 12 months after you key one month.
answer
Series and AutoFill
question
What keyboard shortcut opens the Replace dialog box?
answer
ctrl + H
question
How are table styles categorized or grouped in the gallery?
answer
Light, Medium and Dark
question
Name two context-sensitive command tabs
answer
Table-tools design, Drawing tools format
question
T/F: A worksheet contains at least one workbook.
answer
False
question
T/F: The name box shows the address of the active cell.
answer
True
question
T/F: The Zoom size for a particular worksheet is permanent and cannot be adjusted.
answer
False
question
T/F: You can use the scroll bars to move the pointer to a specific cell.
answer
False
question
T/F: You can replace a cell's contents by clicking the cell and keying new data.
answer
True
question
T/F: You must use Windows Explorer to create a new folder.
answer
False
question
T/F: Edit mode starts when you press F2
answer
True
question
T/F: If you click the Print button while viewing a sheet in print preview, all worksheets in a workbook are printed.
answer
False
question
What is the name for the cell with a heavy black border that is ready to accept new data?
answer
active cell
question
What is the screen element that contains command tabs?
answer
The ribbon
question
What command enables you to used a different filename for a workbook?
answer
Save as
question
Which part of the Excel screen shows the contents of the active cell?
answer
formula bar
