BT (SPR 2022) 9- Week Exam Review

The ________ function finds the maximum value in a cell range.

The ____________________________function counts all the nonblank entries in a range.

When you create a new workbook, what is the default name for its first worksheet?

_______________ provide navigation throughout a workbook or to external resources.

Using the Ctrl + O shortcut will allow you to open an existing workbook.

You can apply formatting to multiple cells with the ______________.

A ____________ is a mathematical equation that performs calculations on values in a worksheet.

A worksheet in Excel is a computerized workbook.

The COUNT functions are in which of the Function Library categories?

The Format Painter can copy and paste functions and formatting.

To combine text from one cell with another cell, use the ______ function.

A constant is a number or text value that is entered directly into a cell.

The COUNTBLANK function counts the number of filled cells in a range.

You can use a hyperlink to connect to which of the following?

Operator is an indicator used to specify the type of calculation to take place, such as addition, subtraction, etc...

You can clear contents of a cell by using the Delete or Backspace keys on the keyboard.

The / operator is used to divide in Excel.

Using a hyperlink within a workbook makes navigating to a place within the workbook or outside the workbook easier.

The + sign is used to start a formula in Excel.

PEMDAS is the acronym for ____________________.

A .csv file is a comma-separated value.

Which of the following operators can you use to override the order of operations?

When you enter data into an active cell, what you entered will also display where?

By using the Paste Special option the reference cells can be deleted because the formulas have converted to values.

What is a delimiter?

A _____________ chart is useful for showing trends or changes overtime.

This option allows users in Excel to bring in data from sources such as TXT and CSV files.

Hovering over a command on the Ribbon with your mouse pointer will display the _________________.

Which function is used to add specified values?

A group of letters, numbers and symbols that a computer can perform an operation on is ____.

You are constructing an IF statement that evaluates whether cell C9 is less than 150. Which operator would you use?

What delimiter does a CSV file use?

This operator is used to multiply in Excel_______________.

A chart wizard can be used to create a chart.

The SUM function adds a range of cells and then divides by the number of entries.

A built-in or predefined formula is known as a function.

A ____ is a representation in Excel that can be a number, cell address, date, text or range of cells.

What is the file extension for a Microsoft Excel 2019 file?

This type of chart is useful for comparing parts of a whole.

A range of cells is simply a group of more than one cell. They can be adjacent or non-adjacent.

Bold, italics, and underlining are examples of formatting attributes.

Which of the following specifies an absolute reference?

In Excel, Rows are labeled as ascending letters.

The intersection of a column and row is the ___________.

The AutoFill feature automatically inserts words, numbers or formulas that are a part of a series.