CGS Exam 1

Question 1

This function calculates loan payment amounts when the borrower makes regular payments and the loan has constant intrst:

Accepted Answer

PMT

Question 2

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

Accepted Answer

backspace

Question 3

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

Accepted Answer

True

Question 4

In an Excel worksheet dates and times are:

Accepted Answer

values

Question 5

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

Accepted Answer

3D Cell Reference

Question 6

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

Accepted Answer

chart sheet

Question 7

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

Accepted Answer

category label

Question 8

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

Accepted Answer

formulas

Question 9

This function displays the contents of the cell at the intersection of an identified column and row:

Accepted Answer

INDEX

Question 10

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

Accepted Answer

relative

Question 11

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

Accepted Answer

gradient

Question 12

This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

Accepted Answer

autoCalculate

Question 13

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

Accepted Answer

.xlsx

Question 14

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

Accepted Answer

sparkline

Question 15

A range of cells that you select in which to apply a function is called a(n):

Accepted Answer

array

Question 16

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

Accepted Answer

combination chart

Question 17

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

Accepted Answer

Workbook

Question 18

To apply changes to your charts Shape Fill, Shape Outline, or Shape Effects separately, use the:

Accepted Answer

format tab

Question 19

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

Accepted Answer

evaluate formula

Question 20

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

Accepted Answer

COUNTIFS

Question 21

What text function that includes a delimiter argument allows you to join or combine strings of text?

Accepted Answer

TEXTJOIN

Question 22

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

Accepted Answer

pie chart

Question 23

The Standard Deviation functions are found in this category:

Accepted Answer

statistical

Question 24

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

Accepted Answer

=

Question 25

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

Accepted Answer

name box

Question 26

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

Accepted Answer

chart

Question 27

Which type of function would you use to format a value as a label?

Accepted Answer

text

Question 28

Excel comes with many built-in formulas called:

Accepted Answer

functions

Question 29

In a histogram chart, the category labels are shown:

Accepted Answer

on the horizontal axis

Question 30

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

Accepted Answer

absolute

Question 31

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

Accepted Answer

range

Question 32

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

Accepted Answer

items in parentheses

Question 33

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

Accepted Answer

on the clipboard

Question 34

A function within a function is described as:

Accepted Answer

nested

Question 35

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

Accepted Answer

freeze panes

Question 36

To quickly select all the cells in a worksheet:

Accepted Answer

press Ctrl+A

Question 37

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

Accepted Answer

merge and center

CGS Exam 1

Questions 37

CGS Exam 1

Questions 37