10 Questions
Which of the following is true about Excel cells?
Cells are referred to using their column and row coordinates
Which of the following types of data is right-aligned in an Excel cell by default?
Number
What happens when you apply the MONTH() function to a cell containing a wrong date?
The MONTH() function returns an error
Which of the following is true about conditional formatting in Excel?
Conditional formatting allows you to automatically apply formatting based on the cell value
What happens when you apply the MONTH() function to a cell containing a date?
The MONTH() function returns the corresponding month
Which of the following is a benefit of using tables in Excel?
Tables automatically expand when new rows or columns are added
What is a table in Excel?
A group of rows and columns with a name
What is a benefit of using tables when working with pivot tables and pivot charts?
Tables can be used as the source for pivot tables and pivot charts
What happens to column headers when scrolling down in a table?
Column headers are displayed
What is a quick style that can be applied to tables in Excel?
Built-in table formats
Test your knowledge of Excel cell formatting with this quiz! Learn about text alignment, boolean values, and numeric formatting in Excel sheets. Put your skills to the test and see how well you understand the different formatting options for cells in Excel.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free