IT- Identification for 20 items
shortcut for inserting images in excel
Alt+N+P
shortcut for inserting excel shapes
Alt+N+S+H
what formatting options adjusts thickness and color
Outline & Borders
what would you use for a professional look such a (shadow, glow, 3d)
Shape Effects
it helps visualize processes, hierarchies, and relationships effectively
SmartArt
shortcut to insert excel SmartArt
Alt+N+M
to apply different styles quickly in excel smartart
change colors
are used to compare values across categories
column charts
allow users to visualize trends, compare values, and summarize data effectively.
charts
shortcut for creating an excel column chart
Alt+N+C
change color and design in chart ribbon
chart styles
add or remove elements such as titles, legends, etc. in chart ribbon
chart layouts
toggle gridlines, labels, and legends in chart ribbon
chart elements(+buttons)
what would you choose after right clicking a chart to update values easily
edit data
shortcut to format axis labels in excel chart
Alt+JC+A
shortcut in moving a chart to another object
Alt+JC+M
are used to show proportions and percentages
pie charts
shortcut to create a pie chart
Alt+N+Q
best for comparing values across categories
column chart
best for displaying long category names
bar chart
best for showing proportions and percentages
pie chart
best for visualizing trends over time
line chart
best for analyzing relationships between variables
scatter plot
to combine multiple chart types in one
combo charts
display how the sheet will print
print review
change from normal or white or narrow in page layout
margins
it fit all columns or rows on one page using fit to one page under page setup
scaling
chooses between portrait and landscape
orientation
shortcut for margins
Alt+P+M
shortcut for orientation
Alt+P+O
controls the spacing between the content and the page edges
margins
visualize how a sheet will print
page layout view
shortcut to toggle page layout view
Alt+W+P
provide predesigned worksheets for specific tasks such as budgets, invoices, and reports
templates
it add page numbers, titles, and timestamps to printed sheets
Headers and footers
if no existing template meets your needs you can create a
custom template