Excel Navigation and Functions Quiz

What are some shortcuts to improve speed in Excel navigation?

• Ctrl + C

• Ctrl + V

• Alt + Tab

• Ctrl + Z

How do you freeze panes in Excel?

• View > Freeze Panes

• Home > Freeze Panes

• Data > Freeze Panes

• Insert > Freeze Panes

What are the view options available in Excel?

• Normal

• Page Layout

• Page Break Preview

• All of the above

How do you create and manage range names in Excel?

• Formulas > Name Manager

• Data > Name Manager

• View > Name Manager

• Insert > Name Manager

What is the purpose of linking multiple worksheets and workbooks?

• To consolidate data

• To create charts

• To format cells

• To print reports

What are custom number formats used for in management reports?

• To change font size

• To format numbers

• To add colors

• To create charts

How can you apply conditional formatting in Excel?

• Home > Conditional Formatting

• Data > Conditional Formatting

• View > Conditional Formatting

• Insert > Conditional Formatting

What is the function of error checking in Excel?

• To find errors in formulas

• To format cells

• To create charts

• To print reports

What does tracing precedents and dependents help with?

• Finding errors

• Creating charts

• Formatting cells

• Printing reports

What is formula auditing in Excel?

• Checking formulas for errors

• Creating charts

• Formatting cells

• Printing reports