Questions

1.What is a multiple sheet file in Excel?

a. A file with multiple worksheets

b. A file with multiple workbooks

c. A file with multiple charts

d. A file with multiple macros

Answer

Answer: a. A file with multiple worksheets

 

2.What is the maximum number of worksheets you can have in an Excel file?

a. 50

b. 100

c. 250

d. There is no maximum number

Answer

Answer: d. There is no maximum number

 

3.How can you add a new worksheet to an existing Excel file?

a. Click the New Sheet button on the Home tab

b. Right-click a worksheet tab and choose Insert > Worksheet

c. Press Ctrl+W

d. None of the above

Answers

Answer: b. Right-click a worksheet tab and choose Insert > Worksheet

 

4.How can you rename a worksheet in Excel?

a. Double-click the worksheet tab and type a new name

b. Right-click the worksheet tab and choose Rename

c. Click the Rename button on the Home tab

d. All of the above

Answers

Answer: d. All of the above

 

5.How can you move a worksheet to a different position in the workbook?

a. Drag and drop the worksheet tab to the desired position

b. Right-click the worksheet tab and choose Move or Copy

c. Click the Move or Copy button on the Home tab

d. None of the above

Answers

Answer: a. Drag and drop the worksheet tab to the desired position

 

6.How can you copy a worksheet to a new workbook?

a. Right-click the worksheet tab and choose Move or Copy

b. Click the Move or Copy button on the Home tab

c. Press Ctrl+C to copy the worksheet and then press Ctrl+V to paste it into a new workbook

d. None of the above

Answers

Answer: a. Right-click the worksheet tab and choose Move or Copy

 

7.How can you group worksheets together in Excel?

a. Hold down the Ctrl key and click on the worksheet tabs you want to group

b. Right-click a worksheet tab and choose Group

c. Click the Group button on the Home tab

d. All of the above

Answers

Answer: d. All of the above

 

8.What is the purpose of the Page Layout view in Excel?

a. To preview how the worksheets will look when printed

b. To view and edit the page margins and orientation

c. To view and edit the page headers and footers

d. All of the above

Answers

Answer: d. All of the above

 

9.How can you protect the worksheets in an Excel file?

a. Click the Protect Workbook button on the Review tab

b. Right-click a worksheet tab and choose Protect Sheet

c. Click the Protect Sheet button on the Review tab

d. None of the above

Answers

Answer: c. Click the Protect Sheet button on the Review tab

 

10.How can you unhide a hidden worksheet in Excel?

a. Right-click a visible worksheet tab and choose Unhide

b. Click the Unhide button on the Home tab

c. Press Ctrl+Shift+H

d. All of the above

Answers

Answer: d. All of the above