Excel - Ch. 15: Formula errors and data validation errors
Text-only quiz: Ch. 15: Formula errors and data validation errors
Want to study this quiz?
Copy it to your free Gradiuz library and make it your own.
Question 1
What can cause Excel to become sluggish?
- an excessive amount of or a sophisticated amount of conditional formatting
- too many open workbooks
- insufficient RAM
- a corrupted file
Question 2
Which path allows you to eliminate unnecessary conditional formatting in Excel?
- Home > Conditional Formatting > Clear Rules
- Data > Data Validation > Clear All
- Formulas > Error Checking > Clear Errors
- View > Page Layout > Remove Formatting
Question 3
What is a potential cause for Excel becoming unresponsive?
- problems with the printer
- an outdated operating system
- a full hard drive
- incorrect regional settings
Question 4
To troubleshoot Excel unresponsiveness related to printer issues, what type of default printer is recommended?
Fill in the blank
Question 5
Which key combination allows you to start Excel in Safe Mode?
- Ctrl, Alt, and Shift keys simultaneously
- Ctrl and Shift keys
- Alt and Tab keys
- Ctrl, Alt, and Delete keys
Question 6
Starting Excel in Safe Mode can help determine if a certain add-in or extension is the source of a problem.
- True
- False
Question 7
What is a troubleshooting step that can be taken to address Excel performance issues?
- temporarily removing antivirus software or shutting other apps completely
- reinstalling Excel
- upgrading the operating system
- clearing the Excel cache
Question 8
Which of the following is listed as a type of formula error in Excel?
- #DIV/0!
- #VALUE!
- #REF!
- #NAME?
Question 9
#DIV/0! is listed as a type of formula error in Excel.
- True
- False
Question 10
One type of formula error listed in Excel is __________.
Fill in the blank
Question 11
According to the provided information, what is a characteristic of an error that occurs when a formula attempts to divide by zero?
- The result being zero
- An incorrect function name
- Text included inside a calculation
- An incorrect type of argument
Question 12
Which function can be used to manage errors such as division by zero?
- IFERROR
- VALUE
- SUMIF
- VLOOKUP
Question 13
To manage a division by zero error, one solution is to ensure the denominator is not zero.
- True
- False
Question 14
The function demonstrated in the example =IFERROR(A1/B1, "Error: Division by Zero") used to manage division by zero errors is __________.
Fill in the blank
Question 15
An error displays itself when Excel is unable to detect what inside a calculation?
- text
- numbers
- dates
- formulas
Question 16
To resolve an error, one should verify that the names of functions or range references do not include any __________.
Fill in the blank
Question 17
An error occurs when an incorrect type of argument or operand is utilized during program execution.
- True
- False
Question 18
What is the cause of an error when an incorrect type of argument or operand is used during program execution?
- Incorrect type of argument or operand
- Division by zero
- Undetected text in a calculation
- Missing range reference
Question 19
The VALUE function can be used to convert text to numbers to resolve data type errors.
- True
- False
Question 20
To resolve errors related to incorrect data types, you may convert text to numbers by using methods such as the __________ function.
Fill in the blank
Made with Gradiuz
Turn any PDF into quizzes, flashcards and summaries - free.