FUN FRIDAY_EXCEL

How do you create a chart in Excel?

• Insert > Chart

• Format > Chart

• Data > Chart

• Draw > Chart

The function of the Freeze Pane is -

• To keep the row visible

• To keep the row and column visible while scrolling

• To hide some rows and columns while scrolling

• To hide some rows

Which one is the latest version of Excel version?

• Excel 2024

• Excel for Microsoft 365

• Excel 2021

• Excel 2023

Google's alternative for Microsoft Excel is called

• Slides

• Calc

• Docs

• Sheets

Maximum Zoom Level in Excel -

• 300%

• 500%

• 400%

• 200%

Which function can be used to find the highest value of a range?

• LARGEST

• HIGHEST

• MAX

• BIG

The first version of MS Excel was released on

• Macintosh

• MS DOS

• Linux

• Windows

Which feature allows you to create visual representation of the data?

• Charts

• Graphs

• Data Validation

• Conditional Formatting

Shortcut for AutoSum -

• Shift+=

• Alt+=

• Ctrl+Shift+=

• Ctrl+=

You can remove Gridlines from

• View tab

• Page Layout tab

• Insert tab

• Home tab