CGS2518 - EXAM 1 - FSU - Armstrong

1.9 To quickly select all the cells in a worksheet:

Group of answer choices

Double-click

Right-click

Press Ctrl+A

Press Enter

Click on the first column heading

Press Ctrl+A

1.2 By default, Excel 2019 files are saved with this extension.

Group of answer choices

xls

xlsx

csv

xbk

ods

xlsx

1.7 A rectangular group of cells in Excel is called a(n):

Group of answer choices

Column

Display

Selection

Object

Range

Range

1.5 When you want to delete characters in a cell to the left of the insertion point press:

Group of answer choices

Delete

Enter

Edit

Backspace

End

Backspace

1.13 Use this button to combine two or more cells into one cell and center the text over a group of columns.

Group of answer choices

Combine Elements

Format Title Cells

Group and Merge

Merge and Center

Increase Indent

Merge and Center

1.11) In an Excel worksheet dates and times are:

Group of answer choices

Labels (chunks of text)

Decimals (e.g. 0.125)

Values (e.g. 43565.125)

Formats (e.g. MM/dd/yyyy mm:ss)

Series (e.g. 1)

Values (e.g. 43565.125)

1.4 When you click on a cell to activate it, the cell address appears in the:

Group of answer choices

formula window

name box

task bar

dropdown menu

comment bubble

name box

1.1 In Microsoft Excel, the file you create and edit is called a:

Group of answer choices

Form

Ledger

Table

Workbook

Record

Workbook

1.12 When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select:

Group of answer choices

A filter

Freeze Panes

Select Window

Zoom to selection

Splitter bar

Freeze Panes

1.10 After you select and cut cells, the cells are temporarily placed:

Group of answer choices

On the Clipboard

In the address window

In the context menu

In the Formula bar

On the Home tab window

On the Clipboard

2.11. Excel comes with many built-in formulas called:

Group of answer choices

Formulas

Factors

Functions

Operations

Calculations

Functions

2.5. The Excel tool button that allows you to step through each part of a formula is called:

Group of answer choices

Trace Precedents

Trace Dependents

Error Checking

Evaluate Formula

Watch Window

Evaluate Formula

2.4. When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns:

Group of answer choices

An error message that begins with an exclamation point (!)

A blank cell

An error message that begins with a number sign (#)

A green alert triangle

A red alert triangle

An error message that begins with a number sign (#)

2.13. This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:

Group of answer choices

STDEV

AMORLINK

PMT

PERCLOAN

PAYPCT

PMT

2.15. To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

Group of answer choices

3D cell reference

Link

LOOKUP

Relative cell reference

FINDIF

3D cell reference

2.6. When you are creating formulas using a cell location, the default cell reference is:

Group of answer choices

Relative

Absolute

Constant

Fixed

Mixed

Relative

2.1 This Excel feature allows users to use common arithmetic operations to perform a calculation:  

Group of answer choices

Formulas

Formatting

Filters

Insertions

Components

Formulas

2.8. A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is:

Group of answer choices

F1

f5

^$

Ctrl+*

F4

F4

2.14 This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false:

Group of answer choices

COUNT

LOOKUP

HLOOKUP

IF

EVAL

IF

2.2 This symbol alerts Excel that you are entering a formula and not text:

Group of answer choices

*

$

=

#

^t

=

2.10. It is important to remember that Excel calculates these operations before any others are performed:

Group of answer choices

Exponents

Items in parentheses

Mathematical expressions

Fixed cell references

Mixed cell references

Items in parentheses

2.7. This type of cell reference does not change when copied and remains in a fixed position during operations:

Group of answer choices

Relative

Absolute

Constant

Fixed

Mixed

Absolute

3.7. To apply changes to your chart’s Shape Fill, Shape Outline, or Shape Effects separately, use the:

Group of answer choices

Format tab

Element pane

WordArt

Chart type

Character tab

Format tab

3.1. When you want to visually represent the numeric data in a worksheet, Excel helps you create an appropriate:

Group of answer choices

Report

Chart

Timeline

Data layout

Slide

Chart

3.9. The type of chart that shows percentages of a whole and has no axes is a:

Group of answer choices

Line graph

Pie chart

Percentage chart

Bar graph

Sheet chart

Pie chart

3.2. The text label that describes each data series in a chart is called the:

Group of answer choices

Chart object

Field name

Category label

Selectable component

Source label

Category label

3.14. A chart that includes two chart types such as a line chart and a column chart is referred to as a:

Group of answer choices

Mixed display

Dual data display

Radar chart

Combination chart

Custom chart

Combination chart

3.13. A variegated blend of colors in a chart element is called a:

Group of answer choices

Shadow

Tint

Gradient

Blended fill

Saturation

Gradient

3.15. A Miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is called a/an:

Group of answer choices

Sparkline

Forecast point

Predictor

MiniChart

Conditional chart

Sparkline

3.5. An Excel chart that is displayed on its own sheet in the workbook is called a:

Group of answer choices

Standalone

Graphic element

Chart sheet

Diagram

Schematic

Chart sheet

3.4. In a histogram chart, the category labels are shown:

Group of answer choices

On the horizontal axis

On the vertical axis

In the chart legend

In the chart title

On both axes

On the horizontal axis

3.10. The Excel chart element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the:

Group of answer choices

Legend

Tick mark

Trendline

Gridline

Chart analyzer

Trendline

6.15) The Standard Deviation functions are found in this category:

Group of answer choices

Financial

Logical

Text

Math & Trig

Statistical

Statistical

6.6) A function within a function is described as:

Group of answer choices

Complex

Dependent

Secondary

Parenthetical

Nested

Nested

6.1) The Statistical function that does computations only after data meets multiple criteria is: 

Group of answer choices

STDEV.S

COUNTIFS

ROUND

STDEV.P

RANK.EQ

COUNTIFS

6.5) In an OR function, if any one of the arguments is true, the result is:

Group of answer choices

Logical

False

Inconclusive

Circular

True

True

6.4) The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is: 

Group of answer choices

AVERAGEIFS

COUNTIFS

ROUNDIF

SUMIFS

RANK.EQ

SUMIFS

11. Which type of function would you use to format a value as a label (like we did in Assignment 2 to turn a date value into a very specifically formatted date)?

Group of answer choices

Logical

Text

Financial

Math & Trig

Lookup and Reference

Text