Excel Basics Quiz

Which of the following best describes a cell address in a spreadsheet?

• The intersection of a row and column, labeled with a letter and a number

• The name given to a worksheet

• The total number of rows in a spreadsheet

• The formula used in a cell

What does the dollar sign ($) in a cell address indicate in Excel?

• The cell contains a monetary value

• The address is absolute and will not change when copied

• The cell is locked for editing

• The cell contains a formula

Which of the following is NOT a type of content that can be entered into a cell in Excel?

• Label

• Value

• Formula

• Worksheet

If you want to specify a range of cells from B2 to D3 in Excel, which of the following is the correct way to write it?

• (B2;D3)

• (B2:D3)

• (B2,D3)

• (B2-D3)

A student wants to copy a formula from one cell to another, but wants the cell address to remain unchanged. What should they do?

• Use a relative address

• Use a label

• Use an absolute address with a dollar sign ($)

• Use a value

Which of the following statements about formulas in Excel is TRUE?

• Formulas can only contain labels

• Formulas must be entered without spaces between characters

• Formulas cannot perform arithmetic operations

• Formulas are preprogrammed functions

Why might a user press the F4 key after writing a cell address in Excel?

• To delete the cell

• To change the address to an absolute one

• To copy the cell contents

• To format the cell as currency

Which of the following best explains the difference between a label and a value in Excel?

• A label is used for calculations, while a value is descriptive

• A label is descriptive information, while a value is a number used in calculations

• Both are used for mathematical operations

• Both are preprogrammed functions

Which command is used to format a cell in Microsoft Excel?

• Format–Cells

• Edit–Cells

• Insert–Cells

• Delete–Cells

What is the default number format in Microsoft Excel if a specific format is not defined?

• Scientific format

• General format

• Text format

• Accounting format