excel midterm exam - study by definition

home

Conditional Formatting is found in the Styles group under which tab?

circle invalid data

Sometimes an Excel user will create a data validation rule after data has been inputted in the cells. This may cause a problem if some of the data is invalid. To check for invalid data, the user should press this button.

review

Spell check is found in the _____ tab.

FALSE. found in

T/F: =SUMIF and =SUMIFS are found in the Statistical Functions group

false. only 1

T/F: By default, a newly opened workbook contains 3 blank worksheets.

false. only print active

T/F: By default, when you select print Excel will print all the worksheets in the workbook.

true &&&&&&&&&&&&&&&&&&&&&&&&&&

T/F: Conditional Formatting allows you to format cells based upon a rule that you may create.

FALSE idk why tho

T/F: Excel workbooks deleted from a removable drive are easily recovered from the Windows Recycle Bin.

total row check box

Add a Total row to a table by clicking the __________ on the table tools design tab

join parts of the contents of cells.

Flash fill can be used to?

true

Pressing the Shift + Tab key will move the active cell to the cell to its immediate left

ciphertext

What is the name for the scrambled text Excel uses to encrypt passwords?

Workbook Sharing

What method described in Level 2 Chapter 6 allows users to collaborate?

record; field

When data in a worksheet is entered as a table, each row is a _____ and each column is a _____.

weeks

When filtering a PivotTable using Timelines, which of the following time levels is not available?

FALSE. its backwards. original = source. relying wks = dependent

When linking data, the worksheet that contains the original data is called the *dependent worksheet* & the worksheet that relies on the dependent worksheet is called the *source worksheet.*

Quotation marks

When writing an IF function that includes specific text, what must be be placed before & after the text you want inserted?

grand total

When you add groups and subtotals to a range, what does Excel add at the bottom of the range?

special characters

dash, copyright, trademark, registered, paragraph are all what?

symbols

emojis are what?

page layout & page break review

normal view, & what 2 other views?

comments, status, manager. NOT DIRECTOR

show all properties is what?

0.7

the default left and right margin measurements of a page are:

data tools/ data

to delete duplicate records from a table, click the Remove Duplicates button in the ___________group on the _______ tab

break link

to permanently remove a linked external reference and convert the linked cells to their existing values you would click this button

a textbox

upside cross inserts what?

icons

what are the objects from conditional formatting?

PPMT function

what function calculates the principal portion of a particular payment.

to "scale" data

what is to adjust printed output to fit to the number of pages specified>

AVERAGEIFS

you wish to determine the *mean sales* per customer for the stores in the city of Greenville AND in the state of South Carolina, you would use which function?

COUNTIFS

you wish to determine the *number* of employees who make more than $50,000 AND who have been working for the firm more than five years, you would use which function?

slicer

A _____ allows you to filter a PivotTable report.

template

A _____ is a worksheet with specialized formatting that may be used by Excel users.

3-d

A formula that references the cells in two or more worksheets is called a ______ reference.

3

A header provides (this number of) ____ areas in which you may insert information about the workbook.

watermark

A lightened image (such as a photo) that displays behind data in a file is called a: __________

range

A selected group of cells is referred to as a ________

25

By default, how many "Recently opened" workbook names display in the Recent Workbooks list?

protecting

Doing this to a worksheet prevents another user from editing cells.

name manager

Editing or deleting range names may be done in the ______________ dialog box

functions

Excel contains a host of "built-in" formulas such as =SUM. These formulas are referred to as ________________.

portrait

Excel defaults to printing in which orientation?

accurately

Excel's built-in auditing features help you make sure that your wks is functioning _____________

control

Excel's data validation feature allows you to _________ the type of data that can be entered into a cell

scientific

Exponential formatting is used to shorten large numbers in a cell. In Excel, this formatting is called _________ formatting.

small red triangle appears in upper right corner of cell

How can you tell whether a cell contains a comment?

nested

If you place an IF statement within another IF statement, you are said to be using a ______ statement.

Formulas will appear in the cells.

If you press the Ctrl + ~ (grave key) at the same time what will happen?

false. should be absolute reference

If you want to multiply a value by the value in cell D4 as a *relative* reference, you must use $D$4 in the formula.

shift ..

If you wish to enlarge or shrink a chart in a way that will ensure all chart elements maintain a consistent perspective, you must press and hold the _____ key while pulling or pushing on the corner of the chart.

table

In Excel, a range that can be managed separately from other rows and columns in the worksheet is called a _______

true ###########

T/F: If the same few values will be entered over and over again in a field in your data list, you can save the user from having to type in the values by creating a drop-down list containing the values from which the user can choose.

true ************

T/F: If two users change the same cell in a shared workbook, Excel prompts the second user by displaying the "Resolve Conflicts" dialog box.

false lol

T/F: In order to edit or delete conditional formatting for selected cells you must click on "Rule Options" at the bottom of the drop-down list of the Conditional Formatting button.

true ((((((((

T/F: The only real difference between a VLOOKUP function and an HLOOKUP function is that the information being looked up in the VLOOKUP is positioned vertically in the Excel worksheet while the information being looked up in the HLOOKUP is positioned horizontally.

true ...............................................

T/F: To change the source of a linked external reference after moving the source workbook to another folder you would open the "Edit Links" dialogue box

false. there's a way, but idk

T/F: To delete a worksheet, select the worksheet tab and press the delete key on the computer keyboard.

FALSE. you gotta put them idk how

T/F: When you print an Excel worksheet, gridlines print by default unless otherwise turned off.

true ..........

T/F: With Excel, it is possible to find and replace cell formatting.

true ././././.

T/F: changes made in pivotchart are also made in pivottable

true. =VLOOKUP(C4,TABLE,2)

T/F: using a LOOKUP function: you first put function H-V, what youre looking for, from where, idk

current date and time

The =NOW formula displays

clipboard

The Cut, Copy, and Paste buttons are located in WHICH group on the HOME tab?

true ..

The MIN function finds the minimum value in a cell range.

insert !!!!!!!!!!!!!!!!!!!11

The PivotTable button is located on the _____ tab.

formatting

The Table Tools Design tab contains options for _____ the table.

quick access toolbar

The Undo and Redo buttons are located on the: ____________

scenario

The _____ Manager allows you to store multiple sets of assumtions about data and then view the impact of those assumptions on your worksheet

wordart

The _______ feature is used to distort or modify text to conform text to variety of shapes.

data

The blue lines in data illustrate a type of conditional formatting called _____ bars.

normal

The default formatting style for Excel worksheet is the _______ style.

3 (XXX / YYY)

The fractional formatting option in Excel allows users to create fractions which have a maximum of ____ digits in the numerator and in the denominator.

marquee

The moving, dashed line border that displays around a cell when it is cut or copied is called the _________:

marquee .

The moving, dashed line border that displays around a cell when it is cut or copied is called the _________:

absolute

The point-and-click method of creating a link to another workbook creates _____ references to the source cell.

fill

The small dark square circled in the image below image is called the ________ handle

dependent cells

These cells contain a formula that refers to other cells..

transpose

This option from the Paste drop-down menu will convert columns to rows and rows to columns.

format

To access the Hide/Unhide feature you need to click on which button in the Cells Group of the Home Tab?

summary

To compare scenarios side by side, display the Scenario Manager dialog box and click the _____ button.

true .

To copy a formula relatively in a worksheet, one may use the Fill button OR the fill handle.

true....

To count the number of cells that contain numbers within the list of arguments, you should use the =COUNT formula.

insert

To create a header or footer, you go to the text group in the _______ tab.

Changes; Review

To protect the structure of a workbook, use the Protect Workbook button in the _____ group on the _____ tab.

!

When you are computing an answer in (for example) Worksheet 2 of a Workbook, and you reference a cell in Worksheet 1, what symbol will Excel display in the formula bar that separates a Worksheet reference from a regular cell reference within a worksheet?

drawing

When you click on a shape, the _______ Tools tab appears on the ribbon.

in the top left cell of the table

Where do you place the source formula in a two-variable data table?

goal seek

Which Excel feature is useful for a situation where you know the result you want but don't know what value will achieve that result?

design - format

Which are the two tabs found under Chart Tools?

custom

Which formatting would you use if you wish to create a unique combination of numbers (or letters and numbers) to create product numbers for your firm?

F1

Which function key activates the HELP function?

Alt + F1

Which keyboard shortcut creates a recommended chart within the active worksheet?

=FV

Which of the following functions would you use if you wanted to determine *how much money your savings account would be worth* when you are making: specific deposits, at a specific interest rate, over a specific period of time?

PMT. these ARE: MIN, AVERAGE, COUNT

Which of the following is NOT a statistical function in Excel?

*COUNT* / subtract, add, multiply ARE included

Which of the following operations is not included in the Paste Special dialog box?

=PROPER

Which of the following text functions changes the first letter of each word in a cell from lower case to upper case?

one-variable and two-variable

Which types of data tables does Excel offer?

use subtotal feature

Why would you want to convert a table to a normal range?

right-clicking

You can insert a comment by using the New Comment button or by _____ a cell and then choosing Insert Comment from the shortcut menu.

sparklines

are miniature charts that are embedded into the background of a cell so that an entire chart will exist in that single cell ?????/