WorksheetsUnit 4:Introduction to FP&A: Introduction to Excel Quiz
Total questions: 10
Worksheet time: 50mins
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.
