WorksheetsExcel Lesson 11 Knowledge Assessment
Total questions: 10
Worksheet time: 5mins
Adding, deleting, and viewing comments are performed from the commands on which ribbon tab?
Comments
Review
File
View
The Protect Workbook button is on which ribbon tab?
Comments
Review
File
View
Which of the following is not an option in the Comments group?
New Comment
Delete
Track Changes
Edit Comment
Which of the following can not be used to turn on track changes?
The Track Changes button
The Share Workbook button
The Protect Sheet button
The Protect and Share Workbook button
Which of the following is not on the Review tab?
Track changes button
Share Worksheet button
Protect Cells button
Protect and Share Workbook button
Which of the following would is considered the strongest password?
02Feb2016 (your dog’s birthdate)
DenVer (the city in which you were born, with odd capitalization)
679KrDj! (the last three digits of your social security or social insurance number and first names of each of your siblings with an exclamation point)
BruinsO6 (your high school mascot and year you graduated using the letter O for a zero)
In Excel, a password can not be required for which of the following?
Opening a File
Formatting cells, columns, and rows on a worksheet
Adding a new worksheet, deleting a worksheet
Deleting a file
Which of the following functions allows you to have Excel place a random number between 10000 and 99999 in a cell?
RAND()
RANDBETWEEN(10000,99999)
BYCHANCE(10000,99999)
RANDOM(10000,99999)
Which of the following actions can not be performed with comments?
You can format the text using a different color.
You can change the background comment box color.
You can prevent the disclosure of the name of the user who made the comment.
You can hide the comment.
Which of the following keyboard shortcuts can be used to add a note to a cell?
Shift+F2
Ctrl+N
Alt+Shift+C
Ctrl+F9
