Questions and Answers
How many hours are required to manage advanced charts and tables?
What advanced function is used to create modify PivotTables?
How many hours are required to create and modify advanced charts?
What is the purpose of Power Query Function?
Signup and view all the answers
How many hours are required to use Power BI for simple data visualizations?
Signup and view all the answers
What is the purpose of Power BI?
Signup and view all the answers
How many hours are required to organize the workbook queries?
Signup and view all the answers
What is the purpose of creating a Power Query?
Signup and view all the answers
What is the purpose of the Auto Fill feature in Excel?
Signup and view all the answers
Which of the following is a way to analyze data in Excel?
Signup and view all the answers
What is the purpose of the Freeze Panes feature in Excel?
Signup and view all the answers
Which of the following file formats can you import data from in Excel?
Signup and view all the answers
What is the purpose of the Pivot Table feature in Excel?
Signup and view all the answers
Which of the following is a way to customize the display of data in Excel?
Signup and view all the answers
What is the purpose of using the COUNTBLANK() function?
Signup and view all the answers
Which function is used to perform conditional operations in Excel?
Signup and view all the answers
What is the purpose of the Goal Seek feature in Excel?
Signup and view all the answers
Which of the following is a way to validate data in Excel?
Signup and view all the answers
What is the purpose of using the LEN() function?
Signup and view all the answers
What is the purpose of the Sparklines feature in Excel?
Signup and view all the answers
How can you switch between rows and columns in source data when creating a chart?
Signup and view all the answers
What is the purpose of using named ranges in Excel?
Signup and view all the answers
Which of the following is a way to manipulate data in Excel?
Signup and view all the answers
Which function is used to count the number of cells that meet a specified condition?
Signup and view all the answers
What is the purpose of using the RIGHT() function?
Signup and view all the answers
How can you add alternative text to charts for accessibility?
Signup and view all the answers
What is the purpose of using the AVERAGE() function?
Signup and view all the answers
What is the purpose of using the TEXTJOIN() function?
Signup and view all the answers
Study Notes
Professional Knowledge of Spreadsheet Application
- Open MS Excel and create a new Excel file or from a template
- Import data from txt files, csv files, and other sources
Navigating Workbooks
- Search data within workbooks
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
Formatting Worksheets and Workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
Customizing Options and Views
- Display and modify content in different views
- Freeze rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
Configuring Content for Collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
Manipulating Data
- Paste data using special paste options
- Fill cells using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
Formatting Cells and Ranges
- Merge and Unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format cells dialog box
- Apply cell styles
- Clear cell formatting
Defining and Referencing Named Ranges
- Define a named range
- Name a table
- Summarize data visually
- Insert spark lines
- Apply built-in conditional formatting
- Remove conditional formatting
Managing Tables and Table Data
- Create excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
- Add or remove table rows and columns
- Configure table style options
- Insert and configure total rows
- Filter records
- Sort data by multiple columns
Performing Operations using Formulas and Functions
- Insert relative, absolute, and mixed references
- Reference named ranges and named tables in formulas
- Perform calculations using AVERAGE(), MIN(), MAX(), and SUM()
- Count cells by using COUNT(), COUNTIF(), and COUNTBLANK()
- Perform conditional operations using the IF() function
Formatting and Modifying Text
- Format text using RIGHT(), LEFT(), and MID() functions
- Format text using UPPER(), LOWER(), and LEN() functions
- Format text using CONCAT() and TEXTJOIN() functions
Managing Charts
- Create charts
- Create chart sheets
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
- Add trend lines to charts
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility
Managing Pivot Tables
- Create Pivot tables from cell ranges
- Manipulate fields (columns) to get desired analysis
- Use Filters for pivot tables
- Represent data as Count, Sum, Average, and % of row / column
- Group data in Columns & rows for aggregate reports
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn the fundamentals of Microsoft Excel, including creating and opening files, cell referencing, and basic functions. This quiz covers introductory concepts in Excel.
