Excel Midterm
COUNT
Counts cells only including numbers
NOW
Current Date & Time of the worksheet
Which command group on the format tab allows you to select a specific chart element and apply formatting?: -current selection -shape styles -arrange -size
Current Selection
TODAY
Current date displayed on a worksheet
Which of these options CANNOT be found on the Ribbon? -Paste -Drag & Drop -Cut -Copy
Drag & Drop
All of the following can be done within the customize ribbon category in excel options except: -enter worksheet data -rearrange the tab order -create a new tab -remove commands
Enter worksheet data
A chart must be located within the same worksheet as its associated data
F
A worksheet can be edited in backstage view
F
A worksheet is a file containing one or more workbooks.
F
An item is placed of the office clipboard when it is pasted.
F
Borders display within a worksheet, but do not print.
F
Built-in tabs on the Ribbon can be removed.
F
By default, text entires are right aligned and number entries are left aligned.
F
Column A cannot be hidden, as there are no columns located to its right.
F
Conditional formatting rules manager dialog box displays only one conditional formatting rule at a time.
F
Defined names can make formulas difficult to understand, and therefore, should be avoided when others will view a worksheet.
F
Entries can be edited only by clicking the formula bar.
F
Every action taken within Excel can be reversed by clicking the undo button.
F
Excel does not allow you to work with reports created in other programs.
F
Hidden rows reman part of the worksheet and will print.
F
If a number entry is formatted such that it cannot display fully within a cell, asterisks appear.
F
Number entries are automatically right-aligned and must remain right-aligned.
F
Number formats can only be customized for dates.
F
The IF function can display text, but it cannot display values.
F
The accounting format is automatically applied if you begin an entry with a dollar sign.
F
The active cell can only be changed by entering a new cell reference in the Name Box.
F
The default column width is 15 characters.
F
The logical test within an IF function must indicate that a cell is equal to a specific amount or text entry.
F
The merge & center command can be used to merge multiple rows simultaneously.
F
The properties menu can be accessed from the Ribbon.
F
The redo button is always visible on the quick access toolbar.
F
The undo command cannot be used to reverse autocorrect entries.
F
Trendiness can be applied to all chart types.
F
Trendiness can be used to display data trends, but they cannot predict future values.
F
When the AutoSum button is chosen, excel looks left then looks up for a range to sum.
F
The auto fill options button displays each of the following options except: -Flash Fill -Fill without formatting -Fill series -Fill alignment
Fill Alignment
How to shift to:
Highlight right-click-insert or remove a row the box comes up
Range Reference
How the range is identified; made up of the cell in its upper-left corner and the celling its lower-left corner, separated by a colon.
The accounting number format -places a dollar sign directly in front of numbers -displays zero decimal places -excludes commas -indents the cell entry
Indents the cell entry
What is the named of the alignment option that evenly distributes unused space so that text fills a cell from the top edge to the bottom edge? -warrant -spread -justify -smooth
Justify
Texts are normally aligned?
Left
Each of the following is true about defined names except they: -may contain an underscore -cannot contain hyphens -must begin with a letter -may contain a hyphen
May contain a hyphen
Which of the following are located below the worksheet area: -quick access toolbar -new sheet button -name box -title bar
New Sheet Button
Do you typically put data with the total?
No
All charts besides what is good for Data Series?
Pie Chart
Auto-Correct
Replaces a word for a different word
Numbers are normally aligned?
Right
Which of the following, when tapped, will not complete a cell entry: -shift key -arrow keys -enter key -tab key
Shift Key
When inserting cells, each of the following options appears except: -entire column -shit cells right -shift cells up -entire row
Shift cells up
When managing worksheets, which of the following can you not do?: -move a worksheet -delete a worksheet -insert a worksheet -split a worksheet
Split a worksheet
Highlight parts of your spreadsheet shows: sum, count,& average... what is this called?
Status Bar
A cell reference contains both a column letter and row number.
T
A circular reference occurs when a formula refers to its own cell or to another formula that refers to that cell.
T
A legend can be moved by dragging with the mouse and resized by dragging a sizing handle.
T
AutoComplete completes entires in a case sensitive manner.
T
AutotFill can be used with text entries, number entries, and date entries.
T
Defined names can be used to navigate within a worksheet.
T
Formatting commands can be used to ad numbers formats
T
Formula AutoComplete allows for easier formula creation by displaying a list of functions.
T
Holding-Shift- while resizing a chart ensures that the width and height change proportionately.
T
Many common misspellings are built into AutoCorrect, therefore you need not to add them.
T
No arguments are entered when using the NOW function.
T
Row height may automatically increase when text is rotated.
T
The delete key removes the character to the right of the intersection point.
T
The merge styles command allows you to import styles created in a different workbooks into a currently open workbook.
T
The result of an IF function is dependent in the outcome of a logical test.
T
The right-dragging method provides more control than the drag and drop method.
T
The zoom to selection button customizes the zoom to display the elected range.
T
When the show formulas option is used, contents fro cells in which no formulas are used remain visible.
T
When the wrap text option is used, the row height increases to accommodate the additional lines of wrapped text.
T
Each of the following excel functions involve the date except: -DATE -TODAY -TOMORROW -NOW
TOMORROW
An absolute cell reference is one: -where the location is relative to the cell that contains the formula -that completes a formula -that can only be written by using F4 -that will not update when its formula is moved or copied
That will not update when its formula is moved or copied
Cells and range names may be assigned through each of the following methods except: -the view tab -using the define name command -typing within the name box -using the create from selection command
The View Tab
Where is the insert function button located? -the formula bar -the home tab -the status bar -the data tab
The formula bar
Which of the following characters cannot be used within a number entry? -the number five (5) -a dollar sign ($) -the letter W -an asterisk *
The letter W
All of the following display on the status bar by default except: -the maximum value within the selected range -the average of the selected range -the count of values within the selected range -the sum of the selected range
The maximum value within the selected range
You will almost never choose data that has month by month or week by week with the total data in a chart.
True
Auto-Complete
When you type the = signs and beginning letter or a display trigger start formula
A sparkline: -can be applied to pie charts only -is automatically inserted by excel when a chart is created -will display directly on top of chart data -will appear as a miniature chart in a worksheet cell
Will appear as a miniature chart in a worksheet cell
Mixed
can choose to anchor either the row or the column when you copy or move the cell, so that one changes and the other does not.
Relative
cell address changes as you copy or move the cell reference is relative to its location
Each of the following are chart formatting buttons that appear beside a chart except: -chart elements -chart type -chart styles -chart filters
chart type
COUNTA
counts cell containing any type of information
Absolute
stays the same if you copper move the cell to any other cell.
How to make a piece of the pie chart explode out?
1. Click the pie chart 2. Double-click the slice you want to pull out, and then drag that slice away from the center of the chart
3 different ways to use find command
1. numbers 2. formulas 3. texts
3 types of cell references:
1. relative 2. absolute 3. mixed
How to use Autofill:
1. select the cell that contains the formula that you want to fill in 2. drag the fill handle across the cells that you want to fill 3. choose how you want to full the selection, clock auto fill options and click what you want
The IF function contains how many arguments? 2 3 4 5
3
You can conditionally format cells with each of the following except: -data bars -a color scale -a column chart -an icon set
A column chart
When inserting a row where will it go?
Above
Excels Live Preview: -displays all worksheets within a workbook -allows you to review a formatting changes -displays a preview of how a worksheet will print -allows you to preview recommend charts within a worksheet
Allows you to preview recommend charts within a worksheet
What are each chart good for? -Bar -Pie -Column -Line -Scatter
Bar= Data Series Pie= One Series of Data, Not Trends, Not Overtime Column= Data Series Line= Data Series, Display Trends
Sparkling may be formatted as each of the following except: -lines -columns -bars -win-loss columns
Bars
The clear button displays a menu with all of the following options except. -Clear contents -Clear numbers -Clear comments -Clear hyperlinks
Clear Numbers
Which of the following is a way to apply cell formatting to multiple cells simultaneously?: -click a row heading before applying the formatting -choose multiple cells from the ribbon -click the first cell in a row -right click the first cell in a column
Click a row heading before applying the formatting