Question 1

Which is the most correct answer to "Where would you add data or text in a workbook in Excel?"

Accepted Answer

On a single spreadsheet

Answer

On the cover page of a spreadsheet

Answer

On the uppermost column of multiple worksheets

Question 2

Where do you rename a Worksheet?

Accepted Answer

On the tabs at the bottom of a worksheet

Answer

In the upper left of the workbook

Answer

In the first row of a spreadsheet and then at the bottom.

Question 3

Cell References

Accepted Answer

A definition of a cell that refers to the contents of another cell

Answer

A definition of a cell that refers to the contents of another row

Answer

A definition of a column that refers to the contents of another column

Question 4

What is a Formula bar?

Accepted Answer

It allows you to create and view formulas in a cell. It's located above your spreadsheet and beneath the tool bar.

Answer

It allows you to view only formulas in a cell. It's located in the cell of your spreadsheet and above the tool bar.

Question 5

What is a Namebox in Excel?

Accepted Answer

This lets you select cells or ranges by entering a reference or range name.

Answer

This is where your emails are stored when you are using Excel.

Question 6

What are Sheet Tabs?

Accepted Answer

Reference labels on the lower portion of a workbook that identify the worksheet.

Answer

Reference labels on the upper portion of a workbook that identify the worksheet.

Question 7

What are the file formats for spreadsheets?

Accepted Answer

a. .xls, csv

Answer

File. Sprd. XYZ

Question 8

What does "Merge & center" do?

Accepted Answer

It combines cells and centers the data within the newly merged cell.

Answer

It divides cells and centers the data within the newly created cell.

Question 9

What does the Wraptext function do?

Accepted Answer

It's a command that formats the text in a cell to wrap a line underneath each other.

Answer

It's a command that merges the text in a cell and creates a wider cell by creating a line next to each other.

Question 10

What does the "Align Text" function do?

Accepted Answer

It moves text either left, center, right, up or down within a cell.

Answer

It moves text in a line so that it all fits in a cell. This can be repeated by using the Fill Handle.

Question 11

Which of the following Word Formats in Excel will change a number to dollars

Accepted Answer

Currency

Answer

Time

Answer

Date

Answer

General

Question 12

Which of the following Word Formats in Excel would you use to describe that the number is not mistaken for money?

Accepted Answer

General

Answer

Other

Answer

All

Answer

Not Money

Question 13

The Freeze Pane function is useful because

Accepted Answer

It allows the user to keep a row or column visible while scrolling through the others.

Answer

It allows the user to stay cool in the summer time or when entered large amounts of data.

Answer

It allows the user to keep a column (only) visible while scrolling through the others

Question 14

What does "Split Windows" do?

Accepted Answer

Split window: you can view two areas of a sheet by splitting it into separate panes where you can scroll in both panes independently.

Answer

Split window: you can view four areas of a sheet by splitting it into separate panes where you can scroll in all panes independently

Question 15

What does the ZOOM function do for you in Excel?

Accepted Answer

Zoom: changes the scale of a worksheet. When you want to see more or less of a worksheet, use Zoom to increase or decrease the magnification.

Answer

Zoom: changes the camera on a worksheet. When you want to see the person who you are working with you can use this function in order to share your worksheet with them.

Question 16

What function would you use to continue a series or pattern in an Excel spreadsheet?

Accepted Answer

The Fill Handle

Answer

The Auto Fit tool

Answer

Thge Copy Function

Question 17

To automatically change the size of a cell to an appropriate height and width based on font size, what function would you use?

Accepted Answer

Auto Fit

Answer

Auto Handle

Answer

Fill Fit

Answer

Fill Handle

Question 18

Pie chart

Accepted Answer

Displays data in a circular graph showing the percentage of the whole.

Answer

Displays data in columns showing a comparison of the data.

Answer

Displays data in a line or series of dots showing the progression of the data.

Question 19

Column Chart

Accepted Answer

Displays data in a vertical display showing a comparison of data.

Answer

Displays data in a line or series of dots showing the progression of the data.

Answer

Displays data in a circular graph showing the percentage of the whole.

Question 20

Which of the following best describes a Line chart?

Accepted Answer

Displays data points connected by straight lines, showing information (trends) that change over time.

Answer

Displays rectangular bars to show a comparison between categories.

Question 21

What is a correct FORMULA?

Accepted Answer

=SUM(A1:A3) which finds the sum of the range of values from cell A1 to cell A3.

Answer

=A1*A5, which would find the total of the range of values from cell A1:A5

Question 22

Which of the following would you use to DIVIDE data between cells?

Accepted Answer

/

Answer

*

Answer

:

Answer

`/.

Question 23

A FUNCTION is a predefined formula in Excel

Accepted Answer

True

Answer

False

Question 24

Which of the following is a range from E1 to E4?

Accepted Answer

E1&#58;E4

Answer

E1*E4

Answer

E1, E2, E3, E4

Answer

E1/E4

Question 25

To quickly alphabetize data, which of the following would you use?

Accepted Answer

Sort

Answer

Your memory of the alphabet and the keyboard to type each data item.

Answer

Filter

Answer

A dictionary

Related quizzes

Related quizzes