IS 101 Final UNR Reed

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Chemistry Unit 4- Electrons in atoms

View Set

Urbanization (unit 8) reading guide

View Set

Cardiovascular Flashcards, Exam two

View Set

Cell and Molecular Biology Final Exam

View Set

Module 2 Chapter 6 Network Essentials

View Set

English: The Iroquois Creation Myth: "The World on Turtle's Back"

View Set