IS 101 Final UNR Reed
What is an example of a logical operator?
=, >, <, >=, <=, <>
What will occur after dragging =B6+B7 three cells down?
=B9+B10
What will occur after dragging =B6+B7 two cells to the right?
=D6+D7
What is a function?
A Predefined formula
When you select a range of cells and insert a table what was created?
A formatted table
When selecting an aggregation in a total row of a formatted table what kind of reference does Excel use?
A structured reference
What kind of reference is $A$5 and what does it do?
Absolute reference, Keeps the column or row from changing
The cell that is outlined in green is referred to as?
Active Cell
What are some chart elements that you can turn on or off?
Axes, axis titles, chart title, data labels, data table, error bars, gridlines, legend
A pre-built style that changes the look and feel of the chart are referred to as?
Chart styles
What are the 4 most common chart types in excel?
Column, Bar, Line, Pie
How can you see or edit existing conditional formats?
Conditional format rules manager
When selecting a range of data to create a chart for, what is that data referred to?
Data Source
If a cell containing =B$14 is copied 3 columns over and 2 rows down, what would be the result?
E$14
How do you signify to Excel that youre beginning a formula?
Equal Sign
What is syntax?
Equal sign, name of function, open parentheses, arguments, close parentheses
What does it mean for a column or row to be banded?
Every other column or row is shaded differently
What is a conditional format?
Excel will apply formatting to any cells that meet a condition
Which keyboard shortcut toggles through the types of reference options?
F4
Where can you look to determine if a cell value or a calculation?
Formula Bar
Where is the show formulas command found?
Formula auditing group on the formulas tab
How do you keep the top row of your worksheet from moving?
Freeze top row, same for column
What What-If analysis tool allows you to figure out what a value should be changed to in order to reach a specific output?
Goal Seek Manager
What are some elements of a formatted table that can be turned on or off?
Header row, first column, last column, banded row, banded columns, total row
What are some commonly used conditional formats?
Highlight cells, top/bottom rules, data bars, color scales, icon sets
What are 4 ways to insert a function?
Insert function button, formula tab > choose function category > choose function, home tab > editing > choose function, type =, name of func, arguments
If I set my margins to 0.02" will my doc print with a 0.02" area of white space around the outside?
Most likely not if using a standard printer
What is the easiest way to determine the address of a cell?
Name Box
Can you delete a sparkline by pressing delete?
No you must choose to clear sparklines
Does a number format change the value of a cell in any way?
No. Only changes the format of that cell
If one conditional format is trumping another so it cant be seen, how do you set the precedence of these formats?
Open the rule manager and select the arrows to set the order
What dictates the way in which formulas will be solved?
Order of operations
Which function helps determine the payment on a loan?
PMT
Which view allows me to see all of my pages and adjust how much of a spreadsheet will be printed on a page?
Page Break Preview
Which view allows me to see my headers and footers and insert elements into them?
Page Layout
What are some elements that I can add in a header or footer?
Page number, number of pages, current date, current time, file path, file name, sheet name, picture
What is the name of the box that appears after selecting a data source?
Quick Analysis Button
Whats a quick way to turn multiple elements on or off at the same time?
Quick layout
What is A4:B15 referred to as?
Range
When I assign the name "wolf pack" to the range A4:B15 what did I create?
Range name
What is the default method of referencing cells in formulas?
Relative
Why does the formula change when dragged in any direction?
Relative referencing
What What-If analysis tools allows you to test different scenarios and their outputs?
Scenario Manager
How do you keep everything to the left of a cell and everything above it from moving as you scroll down or right?
Select the cell and freeze panes
What is the name of a chart that exists inside a cell?
Sparkline
What does Excel use to indicate optional arguments in a function?
Square brackets
How do you change the look and feel of a table very simply?
Table styles
In PMT what is the most important thing to remember about your rate?
When using APR that value needs to be divided by 12 if making monthly payments or 4 for quarterly
What does ####### mean?
Your column is not wide enough