MS EXCEL

Which type of chart is most effective for displaying parts of a whole?

• 1. Bar chart

• 1. Area chart

• 1. Line chart

• 1. Pie chart 

What do Excel formulas start with? 

• /

• +

• =

• -

____ is not a function in Excel. 

• SUM

• MIN

• MAX

• SUBTRACT

In MS Excel, the keyboard shortcut “Ctrl+S” can be used to_______ 

• 1. Save As

• 1. Save

• 1. Start new workbook

• 1. Switch between opened tab 

In Microsoft Excel spreadsheets, rows are designated as _______.

• 1, 2, 3, ....

• A, B, C, ....

• A1, B1, C1, ....

• I, II, III, ....

The intersection of a column and a row in a worksheet is called____ 

• 1. Column

• 1. Address 

• 1. Value

• 1. Cell 

What is the primary benefit of using a scatter plot in data analysis?

• To show relationships between two variables

• To compare multiple data points at once

• To display time-series data

• To show frequency distributions

What is the primary function of a PivotTable in Excel?

• To create complex formulas

• To summarize data

• To enhance graphics

• To connect to external databases

How can you sum the values in cells A1 through A10 in Excel?

• =SUM(A1:A10)

• =TOTAL(A1:A10)

• =ADD(A1:A10)

• =ADDITION(A1:A10)

How can you hide a column in Excel?

• By deleting the column

• By changing the font color to white

• By right-clicking the column header and selecting 'Hide'

• By setting the column width to zero