CGS2518 - EXAM 1 - FSU - Armstrong

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

Combine Elements

Format Title Cells

Group and Merge

Correct!

Merge and Center

Increase Indent

Question 2

0 / 1 pts

1.11) In an Excel worksheet dates and times are:

Labels (chunks of text)

Decimals (e.g. 0.125)

Correct Answer

Values (e.g. 43565.125)

You Answered

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

Series (e.g. 1)

Question 3

1 / 1 pts

1.9 To quickly select all the cells in a worksheet:

Double-click

Right-click

Correct!

Press Ctrl+A

Press Enter

Click on the first column heading

Question 4

1 / 1 pts

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

Form

Ledger

Table

Correct!

Workbook

Record

Question 5

1 / 1 pts

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

A filter

Correct!

Freeze Panes

Select Window

Zoom to selection

Splitter bar

Question 6

1 / 1 pts

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

formula window

Correct!

name box

task bar

dropdown menu

comment bubble

Question 7

1 / 1 pts

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

Correct!

On the Clipboard

In the address window

In the context menu

In the Formula bar

On the Home tab window

Question 8

1 / 1 pts

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

xls

Correct!

xlsx

csv

xbk

ods

Question 9

0 / 1 pts

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

You Answered

Delete

Enter

Edit

Correct Answer

Backspace

End

Question 10

0 / 1 pts

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

You Answered

Column

Display

Selection

Object

Correct Answer

Range

Question 11

1 / 1 pts

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:

COUNT

LOOKUP

HLOOKUP

Correct!

EVAL

Question 12

0 / 1 pts

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

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

A blank cell

Correct Answer

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

You Answered

A green alert triangle

A red alert triangle

Question 13

1 / 1 pts

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

Trace Precedents

Trace Dependents

Error Checking

Correct!

Evaluate Formula

Watch Window

Question 14

1 / 1 pts

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

STDEV

AMORLINK

Correct!

PMT

PERCLOAN

PAYPCT

Question 15

1 / 1 pts

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

Formulas

Factors

Correct!

Functions

Operations

Calculations

Question 16

1 / 1 pts

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

Correct!

Question 17

1 / 1 pts

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

Exponents

Correct!

Items in parentheses

Mathematical expressions

Fixed cell references

Mixed cell references

Question 18

0 / 1 pts

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

Correct Answer

3D cell reference

Link

LOOKUP

You Answered

Relative cell reference

FINDIF

Question 19

1 / 1 pts

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

Correct!

Relative

Absolute

Constant

Fixed

Mixed

Question 20

1 / 1 pts

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

Correct!

Formulas

Formatting

Filters

Insertions

Components

Question 21

1 / 1 pts

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

Relative

Correct!

Absolute

Constant

Fixed

Mixed

Question 22

1 / 1 pts

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:

Ctrl+*

Correct!

Question 23

1 / 1 pts

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:

Legend

Tick mark

Correct!

Trendline

Gridline

Chart analyzer

Question 24

0 / 1 pts

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

Correct Answer

On the horizontal axis

On the vertical axis

In the chart legend

In the chart title

You Answered

On both axes

Question 25

0 / 1 pts

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

Mixed display

Dual data display

Radar chart

Correct Answer

Combination chart

You Answered

Custom chart

Question 26

1 / 1 pts

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

Correct!

Format tab

Element pane

WordArt

Chart type

Character tab

Question 27

1 / 1 pts

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

Shadow

Tint

Correct!

Gradient

Blended fill

Saturation

Question 28

0 / 1 pts

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

You Answered

Chart object

Field name

Correct Answer

Category label

Selectable component

Source label

Question 29

1 / 1 pts

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:

Correct!

Sparkline

Forecast point

Predictor

MiniChart

Conditional chart

Question 30

1 / 1 pts

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

Standalone

Graphic element

Correct!

Chart sheet

Diagram

Schematic

Question 31

1 / 1 pts

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

Report

Correct!

Chart

Timeline

Data layout

Slide

Question 32

1 / 1 pts

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

Line graph

Correct!

Pie chart

Percentage chart

Bar graph

Sheet chart

Question 33

0 / 1 pts

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)?

Logical

Correct Answer

Text

Financial

Math & Trig

You Answered

Lookup and Reference

Question 34

1 / 1 pts

6.6) A function within a function is described as:

Complex

Dependent

Secondary

Parenthetical

Correct!

Nested

Question 35

1 / 1 pts

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

STDEV.S

Correct!

COUNTIFS

ROUND

STDEV.P

RANK.EQ

Question 36

1 / 1 pts

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

Logical

False

Inconclusive

Circular

Correct!

True

Question 37

0 / 1 pts

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

Financial

Logical

You Answered

Text

Math & Trig

Correct Answer

Statistical

Question 38

1 / 1 pts

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

AVERAGEIFS

COUNTIFS

ROUNDIF

Correct!

SUMIFS

RANK.EQ