5.2 Excel Quizizz

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

• Backstage

• Print

• Edit

• Windows

Which predesigned file already has a significant amount of formatting, text, and other features?

• Blank workbook

• Preset file

• Text file

• Template

To access an Excel template, you can click the File tab and then click New.

• TRUE

• FALSE

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

• It's the easiest way to make a backup before making changes.

• It lets you reuse formats and formulas in a new sheet.

• It helps Excel learn where your data ranges are located.

• You should keep one worksheet hidden in case of an error.

Which of the following statements describes how to change the color of a worksheet tab?

• On the Page Layout tab, in the Themes group, select Colors.

• Right-click the tab and select Tab Color.

• Use the Fill Color tool on the Home tab.

• You cannot change the color of a worksheet tab.

When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?

• September

• August (2)

• Sheet2

• July

When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted?

• At the beginning of the tabs sequence

• Before the active worksheet

• After the active worksheet

• At the end of the tabs sequence

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

• Print Layout

• Page Layout

• ScreenTips

• Split Windows

Which of the following indicates a proper cell address?

• 3A

• :A3

• A3

• @A3

Which of the following describes a column?

• Identified by letters; runs vertically

• Identified by letters; runs horizontally

• Identified by numbers; runs vertically

• Identified by numbers; runs horizontally