Excel Formulas and Functions Basics Practice Flashcard

Front

What does the dollar sign ($) in an Excel cell reference indicate?

Back

The cell reference is absolute.

Front

What is the difference between a cell reference and an absolute cell reference?

Back

A cell reference changes when copied, while an absolute cell reference remains constant.

Front

Which of the following is an example of a calculation operator? Text, +, Image, Font

Back

+.

Front

What does a cell reference allow you to do in Excel?

Back

Identify a cell's location in the worksheet.

Front

Which of the following best describes a constant? Options: A changing value, A fixed value entered directly into a formula, A reference to another cell, A function

Back

A fixed value entered directly into a formula

Front

What type of reference is used when referring to a cell in another workbook?

Back

External reference

Front

What is the primary purpose of a formula in Excel?

Back

To perform calculations

Front

Which of the following is true about an external reference?
It only refers to cells within the same worksheet,
It can refer to a defined name in another workbook,
It cannot include functions,
It is always absolute

Back

It can refer to a defined name in another workbook

Front

What does a mixed cell reference allow you to do?

Back

Use both absolute and relative references in the same cell

Front

Which of the following is an example of an external reference? Options: =A1+B1, =[Book1.xlsx]Sheet1!A1, =SUM(A1:A10), =A$1

Back

=[Book1.xlsx]Sheet1!A1