Unit 2: Excel Quiz Review_1

Excel uses __________ to help organize information in a tabular format.

• documents
• slides

• spreadsheets

• boxes

Where is the fill handle located?

• on the right side of the Home tab on the Ribbon

• in the bottom-right corner of the selected cell

• at the beginning of any formula or function

• in Backstage view

You can click the tabs at the bottom of a workbook to switch between _______.

• number formats

• formulas

• permissions

• worksheets

The dark, thick, green border around a cell or range of cells indicates __.

• the number of cells

• an active cell or cell range

• nothing

• the color of the cell

Which of the following best describes the purpose of the View tab in Excel?

• It allows you to customize the appearance and layout of the worksheet.

• It provides tools for collaboration and reviewing changes made to the worksheet.

• It enables you to perform calculations and apply formulas to the data.

• It provides tools for collaboration and reviewing changes made to the worksheet.

A user wants to keep a portion of a worksheet visible while scrolling to another portion of the worksheet. Which feature of Microsoft Excel should they use to perform this task?

• Wrap Text
• Alignment

• Freeze Panes

• Filter

Match the activity with the correct steps to be taken to carry out the activity on an Excel table.

• row

• basic element of an Excel Worksheet

• cell

• horizontal arrangement of cells

• column

• vertical arrangement of cells

• cell range

• group of selected cells

Which answer is NOT a benefit of formatting your data into a table within Excel?

• converting cell range to table of a particular style

• sorting data according to values given in more than one column

• showing only rows that match specific criteria while hiding all other rows

• data is harder to understand and read in an Excel table

Which of the following correctly depicts the cell range for the highlighted cells in the screenshot?

• B2:C7

• B2:B7

• C2:C7

• B2-B7

Which of the following features of Microsoft Excel helps you to arrange the contents in a specified order?

• Category

• Filter

• Sort

• Merge Cells