What is an Excel table? a. A series of rows and columns that contain related data located on a minimum of two worksheets b. A series of rows and columns that contains related data that can be managed independently from other data in a worksheet c. A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet d. A series of rows and columns that has been assigned a name and can be used in a formula or function

Question

Computers & Technology

Zoie Bryan

23 March, 14:58

What is an Excel table? a. A series of rows and columns that contain related data located on a minimum of two worksheets b. A series of rows and columns that contains related data that can be managed independently from other data in a worksheet c. A series of rows or columns on a separate worksheet that can be managed independently from other data in a worksheet d. A series of rows and columns that has been assigned a name and can be used in a formula or function

+2

Answers (1)

Know the Answer?

Sparky · Answer 1

What is an Excel table? b. A series of rows and columns that contains related data that can be managed independently from other data in a worksheet

Explanation:

Excel tables enable users to identify information in between rows and columns which is related. Being this information formatted as a table makes it easier to carry out a wide range of tasks on the table data without affecting other data in the worksheet, that's why it can be managed "independently" as it is mentioned in the right answer. The different tasks available include: many functions, sorting data, filtering data, quick calculations, adding column totals and visually formatting the table.