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

Answers

Answer: 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

Answers

Answer: a. Data

 

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

Answers

Answer: a. Ctrl+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

Answers

Answer: c. Automatic calculation of formulas

 

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

Answers

Answer: 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

Answers

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

 

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

Answers

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

 

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

Answers

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

 

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

Answers

Answer: 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 answersAnswers

Answer:

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