Ms. Brown
Quiz by , created more than 1 year ago

Quiz 3

77
0
0
Ms. Brown
Created by Ms. Brown over 8 years ago
Close

Intro to MS Excel Quiz 3

Question 1 of 10

1

Select from the dropdown list to complete the text.

The cell you are ( fill with color, currently working on, apply grid lines to ) is known as the active cell.

Explanation

Question 2 of 10

1

Select from the dropdown list to complete the text.

A ( Label, Sheet Tab, Cell Reference ) identified the column and row using a number and a letter.

Explanation

Question 3 of 10

1

Select from the dropdown list to complete the text.

( Cell References, Text Boxes, Grid Lines ) are referred to as the horizontal and vertical lines on the spreadsheet.

Explanation

Question 4 of 10

1

Select from the dropdown list to complete the text.

The procedure to select and sort certain information in a spreadsheet is to ( select, highlight, filter, auto fill )

Explanation

Question 5 of 10

1

is the feature that automatically inserts dates, formulas and other regularly used items for you.

Drag and drop to complete the text.

    Auto Sum
    Auto Complete
    Filter
    Sort

Explanation

Question 6 of 10

1

Select from the dropdown list to complete the text.

A spreadsheet ( is a workbook, organizes data ) and can be used in accounting.

Explanation

Question 7 of 10

1

Auto Sum is the function that will up a column or row of numbers.

Drag and drop to complete the text.

    subtract
    add
    divide
    multiply

Explanation

Question 8 of 10

1

Select from the dropdown list to complete the text.

A number that can be entered into a cell can also be called a ( auto sum, value, dividend ).

Explanation

Question 9 of 10

1

The tool that resembles a paint bucket is called the

Drag and drop to complete the text.

    Fill Handle
    Select Button
    Fill Tool

Explanation

Question 10 of 10

1

These are labels located at the bottom of workbook window indicating the name of each worksheet.

Select one of the following:

  • Formula

  • Series

  • Sheet Tabs

Explanation