BCIS 2610 EXAM 2 REVIEW QUESTION
SET WITH ACCURATE ANSWERS
◉ What is the default column width
Answer: 8.38 standard-sized characters— about 8 or 9 characters
◉ True/False: If you increase the font size of characters, you can
fit more text within a given cell.
Answer: False
◉ To select adjacent ranges, hold down the ___________ key and
then select the range
Answer: Shift
◉ True/False: To deselect a range, click in the selected range
again.
Answer: False
◉ A(n) _____ is a mathematical expression that calculates a value
Answer: Formula
◉ True/False: A worksheet can contain the following type of data:
text, numeric values, dates, and calculated values
Answer: True
, ◉ The _____ calculates the total number of values.
Answer: COUNT
◉ True/False: Functions are used to simplify formulas.
Answer: True
◉ New Excel workbooks contain how many worksheets?
Answer: Three
◉ True/False: Worksheets cannot be deleted
Answer: False
◉ To edit a cell's contents, you need to work in _____
Answer: editing mode
◉ True/False: You can reverse more than one action by clicking
on the Undo button's list arrow
Answer: True
◉ When does Flash Fill work best?
Answer: When the pattern is clearly recognized from the values in
the data
SET WITH ACCURATE ANSWERS
◉ What is the default column width
Answer: 8.38 standard-sized characters— about 8 or 9 characters
◉ True/False: If you increase the font size of characters, you can
fit more text within a given cell.
Answer: False
◉ To select adjacent ranges, hold down the ___________ key and
then select the range
Answer: Shift
◉ True/False: To deselect a range, click in the selected range
again.
Answer: False
◉ A(n) _____ is a mathematical expression that calculates a value
Answer: Formula
◉ True/False: A worksheet can contain the following type of data:
text, numeric values, dates, and calculated values
Answer: True
, ◉ The _____ calculates the total number of values.
Answer: COUNT
◉ True/False: Functions are used to simplify formulas.
Answer: True
◉ New Excel workbooks contain how many worksheets?
Answer: Three
◉ True/False: Worksheets cannot be deleted
Answer: False
◉ To edit a cell's contents, you need to work in _____
Answer: editing mode
◉ True/False: You can reverse more than one action by clicking
on the Undo button's list arrow
Answer: True
◉ When does Flash Fill work best?
Answer: When the pattern is clearly recognized from the values in
the data