Unit 4:Introduction to FP&A: Introduction to Excel Quiz

What is the primary purpose of Excel?

• Designing graphics and animations

• Performing calculations, data analysis, and visualization

• Creating web pages and programming applications

• Editing and formatting text documents

How can users customize the Quick Access Toolbar in Excel?

• Adjust settings in the View tab

• Use the "Insert" tab options

• Right-click the toolbar and select "Customize Quick Access Toolbar"

• Press Ctrl + Q

What is the primary function of the formula bar in Excel?

• To display and edit the contents of a selected cell

• To insert images and charts

• To adjust page layout and printing settings

• To change the font size and color of text

What is the purpose of the "Formula" tab in Excel?

• To apply styles and formatting to text

• To perform calculations and use functions like SUM and AVERAGE

• To insert images and shapes

• To filter and sort data

Which tab in the Excel ribbon contains the options for inserting charts, tables, and images?

• Home

• Insert

• Data

• View

Which group in the Home tab allows users to change font style, size, and color?

• Clipboard

• Alignment

• Font

• Editing

How can you expand the formula bar to display long formulas?

• Click and drag the bottom edge of the formula bar

• Double-click on the Home tab

• Press Ctrl + F

• Change the zoom level in the View tab

What is the purpose of the Quick Access Toolbar in Excel?

• To provide quick access to frequently used commands

• To insert and format tables and charts

• To display the contents of a selected cell

• To switch between different worksheet tabs

Which of the following can be entered into the formula bar?

• Only numbers

• Only text

• Formulas, text, and numbers

• Only functions

What does the dollar sign ($) signify in Excel formulas?

• a) It indicates currency formatting.

• b) It creates absolute references.

• c) It denotes percentage values.

• d) It marks the beginning of a formula.