Questions

1.What is a table in Excel?

 a. A database management system

b. A tool for sorting and filtering data

c. A tool for visualizing data

d. A way to organize data into rows and columns

2.Which ribbon tab in Excel contains the commands for working with tables?

a. Data

b. Home

c. Insert

d. Format

3.What is the keyboard shortcut for creating a table in Excel?

a. Ctrl+T

b. Ctrl+Shift+T

c. Alt+T

d. Alt+Shift+T

4.Which of the following is NOT a benefit of using tables in Excel?

a. Automatic formatting and styling

b. Easy sorting and filtering of data

c. Automatic calculation of formulas

d. None of the above

5.Which of the following is a table element in Excel?

a. Column header

b. Row header

c. Total row

d. All of the above

6.How can you convert a range of cells into a table in Excel?

a. Select the range and click the Table button on the Insert tab

b. Select the range and press Ctrl+T

c. Select the range and click the Table button on the Data tab

d. None of the above

7.What is the purpose of the Total Row in a table?

a. To display a row of summary data at the bottom of the table

b. To display a row of summary data at the top of the table

c. To display a row of summary data in the middle of the table

d. None of the above

8.How can you add a new column to a table in Excel?

a. Right-click a cell in the table and choose Insert > Column

b. Click the Table button on the Insert tab and choose Insert Column

c. Press Ctrl+C to copy a column and then press Ctrl+V to paste it as a new column

d. None of the above

9.Which of the following is NOT a way to format a table in Excel?

a. Change the font size and style

b. Apply a color scheme to the table

c. Adjust the column widths

d. None of the above

10.How can you remove a table in Excel?

a. Select any cell in the table and press the Delete key

b. Right-click the table and choose Delete

c. Click the Table button on the Data tab and choose Delete Table

d. None of the above

correct answers

1. d. A way to organize data into rows and columns
2. a. Data
3. a. Ctrl+T
4. c. Automatic calculation of formulas
5. d. All of the above
6. a. Select the range and click the Table button on the Insert tab
7. a. To display a row of summary data at the bottom of the table
8. a. Right-click a cell in the table and choose Insert > Column
9. d. None of the above
10. b. Right-click the table and choose Delete