Advanced Excel - Midterms

It is a system, which organizes data in columns and rows. It is a data visualization and analysis tool.

• MS Powerpoint

• MS Word

• MS Excel

• MS Teams

A ​ ​ ​ (a)   consists of a grid made from columns and rows.

• powerpoint
• portable file
• word file
• spreadsheet

MS Excel files have ​ (a)   extension.

• .xlsx
• .txt
• .pptx
• .docx

MS Excel supports​ ​ (a)   .

• real-time collaboration
• game development
• video editing
• 3D printing

A ​ (a)   consists of a grid made from columns and rows.

• spreadsheet
• powerpoint
• portable file
• word document

Match the description to the correct Microsoft Excel feature or function.

• VLookup

• Allows people to pick an item from a list that you create

• Line Chart

• This chart type displays trend over time.

• Sum

• Used to automate tasks

• Drop-down List

• This function is used for data lookup.

• Macros

• This formula adds all the numeric values in a range of cells.

Match the Microsoft Excel feature or function with its description.

• Average

• This table is used for data analysis by summarizing large amounts of data.

• Freeze Panes

• This formula calculates the average.

• Conditional Formatting

• Changes the cell appearance based on format conditions.

• Format Painter

• Useful for viewing the headers while scrolling

• Pivot Table

• Lets you copy formatting from one cell to another.

Categorize the features to the menu where it can be found in MS Excel.

Groups:

(a) Home

,

(b) Insert

,

(c) Page Layout

,

(d) Data

• SmartArt

• Orientation

• Recommended Charts

• Data validation

• Merge and Center

• Conditional Formatting

• Insert pivot table

• Text to columns

• Set print area

• Margins

Categorize the features to the correct tab/menu where it can be found in MS Excel.

Groups:

(a) View

,

(b) Review

,

(c) Formulas

• Protect Sheet

• Insert Function

• Freeze Panes

• View Side by Side

• Protect Workbook

Label the parts of MS Excel based on the image.

a

b

c

d

e

cell address

Conditional Formatting

Wrap Text

Formula bar

Filename