Quiz on Basics of Spreadsheet

What is the purpose of AutoSum in Excel?

• To add the contents of a cluster of adjacent cells

• To subtract numbers

• To divide numbers

• To multiply numbers

Which feature in Excel allows you to draw geometrical shapes, arrows, and flowchart elements?

• AutoShapes toolbar

• PivotTable

• Charts

• AutoFill

How can you select a range of cells in Excel?

• By typing in the Name Box

• By pressing F2

• By pressing CTRL+Z

• By using the mouse pointer

What does the Freeze Panes feature in Excel do?

• Freeze the worksheet so it cannot be edited

• Freeze the headings so they are always visible while scrolling

• Freeze the formatting of cells

• Freeze the entire workbook

How can you set a password for a workbook in Excel?

• By clicking on the 'File Save' icon

• By selecting 'File Save As' and then 'Tools'

• By clicking on the 'Print' button

• By selecting 'Page Setup' and then 'Breaks'

What does the Page Setup option in Excel allow you to do?

• Set the paper size, orientation, scaling, and print quality

• Insert a page break

• View the worksheet before printing

• Protect the workbook with a password

How can you insert a new worksheet before an existing worksheet in Excel?

• Select the column or columns that you want to change, click Format

• Select Start, highlight All Programs item, select Microsoft Office

• Right-click on the sheet before which you want to insert a new sheet

• Select Home tab, click cells Group, click Insert, click Insert Sheet

What is the purpose of the Drag and Drop feature in Excel?

• To quickly fill cells with repetitive or sequential data

• To present a graphical representation of data

• To add the contents of a cluster of adjacent cells

• To reposition the data and text by simply dragging with the mouse

How can you change the width of columns in Excel?

• By selecting the column or columns and dragging the boundary

• By selecting the row or rows and clicking AutoFit Row Height

• By selecting the row or rows and clicking Insert Sheet Rows

• By selecting the column or columns and clicking Format

What does the Print Preview feature in Excel allow you to do?

• Change the width of columns

• Set the paper size and orientation

• Insert a page break

• View how the worksheet will look when printed