CSCI FINAL

what error will you get if you type a function name incorrectly

#NAME?

which will not return the systems clocks date?

DATE () - DATE ()

which is not a valid test in an IF statement

A4 - B4

which axis displays descriptive labels for data points

category axis

Which chart element CANNOT be chosen from the Chart Elements dialog box?

format black wall

What can you NOT do from the Select Data Source dialog box?

Change chart type

Which is NOT a characteristic of a table?

Can contain multiple ranges — a table is a single contiguous range.

What is NOT true about creating a data table?

Leave one blank row below labels

Which filter option is NOT on the date filter submenu?

tomorrow

which filter option is not on the text filter submenu

Includes

Which is NOT a conditional formatting option?

Table Format

Which conditional formatting option applies formatting to values between two numbers?

Highlight Cells Rules

If a cell fails a conditional formatting test, what happens?

not formatted

What CANNOT be found on the Manage Rules dialog box?

copy rule

What does a + button indicate in an outline?

Expand details

Which function is NOT a Subtotal function?

AGGREGATE

A(n) ________ is an interactive table used to consolidate and summarize information.

PivotTable

In a Recommended PivotTable, which column is most likely used as values?

Units Sold

Which is true about creating a blank PivotTable?

Can be on same sheet as source

Moving a field from ROWS to COLUMNS would ________.

Consolidate data

How do you change SUM to AVERAGE in VALUES?

Value Field Settings

How do you add a date filter to a PivotTable?

Drag Date to FILTERS

Which is NOT true about the PivotTable Fields pane?

Table named Table1

A PivotTable timeline can filter by all EXCEPT ________

Decade

% of Grand Total displays values as ________.

% of grand total

Which is NOT controlled by a PivotTable style?

Subtotal calculations

PivotTable styles are selected from ________.

Style gallery

Banded rows

shade odd/even

The slicer ________ is text in the slicer header.

caption

Which character is NOT allowed in a range name?

!

Benefit of range names?

Easier to remember

If Quantity=6 and Unit_Price=3, =Quantity*Unit_Price returns:

18

To add a column header in a one-variable data table:

Custom format with quotes

A one-variable data table can be built ________.

Either A or B (vertically or horizontally)

________ enables experimenting with variables.

What-if analysis

Where do you set up substitution values in a two-variable data table

First row & column

Which is NOT part of Goal Seek?

Function

what is a scenario

Set of possible situations

what is an excel add in

program that enhances excel

A(n) ________ specifies the formula cell optimized by Solver.

objective cell

A $50,000 down payment limit is a ________.

constraint

best tool to maximize profit

Solver

solver does NOT support which calculation

range

which formula returns the day of the month

DAY

If B3 = 9/3/2021, =MONTH(B3) returns:

9

Function that averages with multiple criteria:

AVERGEIFS

what is a nested function

function inside another

which is NOT true about COUNTIF

As many arguments as conditions

function that returns TRUE only if ALL conditions are true

AND

function that sums with multiple criteria

SUMIFS

function that returns present value

PV

A ________ chart compares values across regions.

Map

COUNTIF takes how many arguments

2

If no logical tests in IFS are TRUE, Excel displays:

#N/A

Function returning total present value of future payments:

PV

Function calculating number of payment periods:

NPER

function calculating periodic rate

RATE

Paying extra principal on a mortgage

saves interest & shortens loan

Relative Standing measures ________.

rank among values

function for sample standard deviation

STDEV.S

strongest positive correlation

1

function returning population stdev including text

STDEVPA

Square root of variance is ________.

Standard deviation

function measuring simultaneous variation

COVARIANCE.S

simplest way to create a histogram

histogram

A ________ extrapolates future values.

forecast worksheet

________ returns forecasted values using exponential smoothing

FORECAST.ETS

In y = mx + b, slope is ________.

m

If worksheets are grouped, how do you ungroup?

Right-click → Ungroup Sheets

If Sheet1 & Sheet2 are grouped and you enter a formula in B3 of Sheet1:

Sheet2 B3 gets same formula

A hyperlink can do all EXCEPT ________.

Switch worksheets

A visited hyperlink is ________.

Purple & underlined

Which is NOT an Arrange All option?

Side by Side

Worksheet name in a 3D reference is enclosed in ________.

''' (single quotes)

If you move an endpoint sheet in a 3D reference

excel adjusts reference

which contains a correct 3D reference

=B4+'1st Quarter'!B3

If source file is edited while destination is open

Destination updates

Character separating sheet name from cell reference:

!

Tool that walks through nested formula steps:

Evaluate Formula

Green triangle means ________

Logic error

Which function has no syntax error?

=AVERAGE(A1:A9)

In =B2*B7 in C7, the dependent cell is ________.

C7

Blue arrows in tracing precedents indicate ________.

No errors

Feature that warns users from entering invalid data:

Data Validation

Which is NOT an Error Style?

critical

method to validate pasted data:

circle invalid data

function returning value at row/column intersection

INDEX

function returning relative position

MATCH

Using =MATCH(66,A1:A4,0), result is:

3

Why nest MATCH inside INDEX?

Use position from MATCH

Criteria range is ________.

Adjacent cells defining conditions

<> means ________.

Not equal

For exact match in VLOOKUP, range_lookup should be ________.

FALSE

=RIGHT("Frog Legs",6) returns ________.

Legs

A partially completed workbook used as a model is a ________.

Template

Which is NOT checked by Accessibility Checker?

print area

File extension for macro-enabled workbook:

.xlsm

Which is FALSE about recording a macro?

Pause button exists

Where should you store macros for use in any workbook?

Personal Macro Workbook

Where do you edit a macro?

VBA editor