DIT Semester Exam 2 Questions and Answers-2024
Update.
When you resolve a comment, what happens to the comment? - ANS The comment is
dimmed
You should use an electronic spreadsheet if you want to: - ANS perform a large number
of mathematical calculations and display charts and graphs
Text, numeric and formula are examples of: - ANS Types of data
Amanda has just updated her Budget 2019 workbook with new values for 2020. She
wants to save her revised file as
Budget 2020. Which command should she use? - ANS Save As
Which key/combination activates edit mode in excel? - ANS F2
Ruby wants all the entries in Column D in her worksheet to display fully. What is the
best method for ensuring Column?
D is wide enough? - ANS Using the AutoFit command
What is the maximum length of a worksheet tab name? - ANS 31 characters
Which of the following is the keyboard shortcut key combination for pasting data? - ANS
CTRL + V
How many worksheets can you hide in a workbook? - ANS All except one
What should you enter in a cell to find the difference between 9 and 5? - ANS =9-5
Which of the following is the correct order of precedence for standard math operators? -
ANS Multiplication, division, addition, subtraction
Monty needs to count the number of empty cells in a 35,000-cell range. Which function
should he use? - ANS COUNTBLANK
Cell H7 contains the text John Jacob Jingleheimer Schmidt. Which of the following
functions will extract the word "Jingle"? - ANS =MID (H7, 12, 6)
Update.
When you resolve a comment, what happens to the comment? - ANS The comment is
dimmed
You should use an electronic spreadsheet if you want to: - ANS perform a large number
of mathematical calculations and display charts and graphs
Text, numeric and formula are examples of: - ANS Types of data
Amanda has just updated her Budget 2019 workbook with new values for 2020. She
wants to save her revised file as
Budget 2020. Which command should she use? - ANS Save As
Which key/combination activates edit mode in excel? - ANS F2
Ruby wants all the entries in Column D in her worksheet to display fully. What is the
best method for ensuring Column?
D is wide enough? - ANS Using the AutoFit command
What is the maximum length of a worksheet tab name? - ANS 31 characters
Which of the following is the keyboard shortcut key combination for pasting data? - ANS
CTRL + V
How many worksheets can you hide in a workbook? - ANS All except one
What should you enter in a cell to find the difference between 9 and 5? - ANS =9-5
Which of the following is the correct order of precedence for standard math operators? -
ANS Multiplication, division, addition, subtraction
Monty needs to count the number of empty cells in a 35,000-cell range. Which function
should he use? - ANS COUNTBLANK
Cell H7 contains the text John Jacob Jingleheimer Schmidt. Which of the following
functions will extract the word "Jingle"? - ANS =MID (H7, 12, 6)
