Spreadsheet Skills Quiz

Yuna has a spreadsheet with a long list of information. She wants to see the column headers as she scrolls down. What should she do?

• Make the columns different colors

• Freeze the column header row

• Increase the font size of the column headers

• Change the font style of the column headers

Muhammed wants to limit the status updates he can enter in his spreadsheet to "Not yet started," "In progress," and "Complete" for each task. What should he do?

• Bold the text in the cells

• Make the cells in the column a different color

• Freeze the header row

• Apply data validation to the cells

Jana has 25 tasks in her spreadsheet and wants to see the tasks in order from the earliest date to the latest date. What should she do to put the tasks in this order?

• Apply data validation to the date column

• Sort the tasks by date

• Wrap the text in the column

• Bold the dates for each task

Alex has entered due dates differently for different tasks. Some have the name of the month and the day (e.g., June 3) and some have numbers (06-03). What should he do to make it easier to read and compare the due dates?

• Break up the goal into smaller tasks

• Create a column header row and freeze the header row

• Change the number format in the due date column

• Adjust the column width

Which of the following is a benefit of using a spreadsheet to manage a schedule?

• It automatically completes tasks for you

• It helps you visualize deadlines and progress

• It makes tasks disappear once completed

• It sends reminders to your phone

What is another advantage of using a spreadsheet for scheduling?

• It allows you to share your schedule with others easily

• It automatically prioritizes tasks for you

• It changes your goals based on your mood

• It deletes old tasks automatically

If you want to ensure that only numbers are entered in a specific column of a spreadsheet, what should you do?

• Change the font style

• Apply data validation

• Freeze the column

• Sort the column

What should you do if you want to highlight overdue tasks in a spreadsheet?

• Change the font style of the tasks

• Apply conditional formatting

• Freeze the header row

• Sort the tasks by date

How can you make sure that a spreadsheet is easy to read and understand?

• Use a variety of font styles and colors

• Keep the layout simple and organized

• Add as much information as possible

• Use only one color for all text

What is a good practice when entering dates in a spreadsheet?

• Use different formats for variety

• Use a consistent date format

• Enter dates as text

• Use abbreviations for months