Microsoft Excel Quiz

How can you get started with Excel on the web?

• Install Excel on your desktop

• Navigate to word.new

• Purchase Microsoft 365

• Navigate to excel.new

What are the rectangles on the Excel screen referred to as?

• Cells

• Rows

• Spreadsheets

• Columns

What is the intersection of a column and a row referred to as?

• Cell E7

• Row E

• Column 7

• Cell A1

How can you zoom in and out in Excel?

• Press shift and scroll the mouse wheel

• Double click on the screen

• Press control and move the mouse wheel

• Click on the zoom icon

What is the shortcut key to open the format cells dialogue?

• Ctrl + F

• Ctrl + 1

• Ctrl + A

• Ctrl + S

How can you hide a column in Excel?

• Right click and select delete

• Right click and select hide

• Right click and select format

• Right click and select move

What is the function used to calculate the sum of a range of cells in Excel?

• average

• max

• min

• sum

What is the recommended chart type for visualizing sales data throughout the year?

• Line chart

• Pie chart

• Scatter plot

• Bar chart

What is the tool available in Excel for analyzing data by dragging and dropping?

• Pivot table

• Chart tool

• Filter tool

• Sort tool

What is the default function used to summarize values in a pivot table?

• Sum

• Min

• Max

• Average