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
correct answersAnswers
a. A file with multiple worksheetsd. There is no maximum numberb. Right-click a worksheet tab and choose Insert > Worksheet- d. All of the above
a. Drag and drop the worksheet tab to the desired positiona. Right-click the worksheet tab and choose Move or Copyd. All of the aboved. All of the abovec. Click the Protect Sheet button on the Review tabd. All of the above
Answer: