Excel 2016 Basics

True or False: instead of typing cell addresses manually, you can point and click the cells you want to include in your formula.

• True

• False

The quickest and easiest way to reorder or move a worksheet in Excel is to:

• Right-click the worksheet tab

• Drag the worksheet tab

• Use the ribbon at the top of the screen

• Start a new workbook

This function adds all of the values of the cells in the argument.

• SUM

• AVERAGE

• COUNT

• MAX

• MIN

Every worksheet is made up of thousands of rectangles which are called ________________

• Rows

• Cells

• Columns

• Headings

True or False: The formula for a cell is located in the Name Box

• True

• False

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.

• SUM

• AVERAGE

• COUNT

• MAX

Which of the following are part of the PEDMAS, a way to remember arithmetic order of operations?

• Exponential calculations

• Parentheses

• Addition and subtraction

• Multiplication and division

• All of the above

What type of software is Excel?

• Text editor

• Workbook

• Word Processor

• Spreadsheet

True or False: A workbook is an entire Excel file, while a worksheet is one spreadsheet within a file.

• True

• False

This function determines the highest cell value included in the argument.

• SUM

• AVERAGE

• COUNT

• MAX

• MIN