EXCEL 2016 BASICS - FINAL EXAM | Take the Quiz

Excel will accept the data entered in a cell after you:

Press the Tab key

Press the Enter key

Click on another cell

All of the above

The quickest way to total a row or column of numbers is by:

Adding up the individual cells

Selecting the cells and using the Auto Sum button

Using the Sum() function

The using "=" followed by a "+" sign for each cell

When copying and pasting cells, Excel will:

Paste the exact same thing copied

Give you an error

Paste the cells and transpose any references

Create a new workbook

Excel 2016 can save workbooks:

Only in Excel 2016 format

In a variety of formats

Only as a PDF

Only as a text file

The most efficient way to operate on cells, rows and columns is to:

Select them, and find the function in the ribbon bar

Select them, and right-click for the context menu

Use the "Tell Me What To Do" function

Drag them on top of each other

To see data in a chart change when you change data in a cell, you must:

Recreate the chart

Nothing. It will update automatically.

Reformat the cell data

Reformat the worksheet

The quickest way to format the entire look of your worksheet is to:

Use the Themes button under the Insert tab

Select each area individually and modify it

You cannot change the look of an entire worksheet

Save the worksheet as a PDF

The best way to share a worksheet with someone viewing it on a smart phone or tablet would be:

You cannot do this

Save the file to the cloud

Email the file as a PDF

Print the worksheet

Unlock and Upgrade