FREE BUSINESS AND STUDY GAMES ABOUT NP EXCEL 1

PDF Download

FREE BUSINESS AND STUDY GAMES ABOUT NP EXCEL 1

EXAM QUESTIONS

Actual Qs and Ans Expert-Verified Explanation

This Exam contains:

-Guarantee passing score -32 Questions and Answers -format set of multiple-choice -Expert-Verified Explanation

Question 1: border

Answer:

A line you can add along an edge of cell that prints.

Question 2: AutoSum

Answer:

The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range.

Question 3: Page Break Preview

Answer:

The Excel view that shows the location of page breaks in the printed sheet

Question 4: Numbers Row

Answer:

headings along the left side of the workbook window that identify the different rows of the worksheet are represented by there.

Question 5: worksheet

Answer:

A grid of rows and columns in which content is entered.

Question 6: sheet tab

Answer:

The area at the bottom of the worksheet that identifies the sheet by name.

Question 7: AutoFit

Answer:

The feature that changes the column width or row height to display longest or tallest entry within the column or row.

Question 8: landscape

Answer:

The page orientation where the page is wider than it is tall.

Question 9: sheet

Answer:

A page included in a workbook; can be a worksheet or a chart sheet.

Question 10: Page Layout

Answer:

The Excel view that shows how the sheet will appear when printed

Question 11: template

Answer:

A preformatted workbook with many design features and some content already filled in.

Question 12: nonadjacent

Answer:

Separate cells that do not touch.

Question 13: hide

Answer:

To make a row, column, or worksheet not visible.

Question 14: formula

Answer:

A mathematical expression that returns a value.

Question 15: cell reference

Answer:

The column and row location that identifies a cell within a worksheet.

Question 16: formula bar

Answer:

The bar located below the ribbon that displays the value or formula entered in the active cell.

Question 17: ScreenTip

Answer:

A box with descriptive text about a command that appears when you point to a button on the ribbon

Question 18: active cell

Answer:

The cell currently selected in the active worksheet.

Question 19: Backstage view

Answer:

The FILE tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options.

Question 20: cell

Answer:

The intersection of a row and a column.

Question 21: Flash Fill

Answer:

The feature that enters text based on patterns it finds in the data.

Question 22: Portrait

Answer:

The page orientation where the page is taller than it is wide.

Question 23: chart sheet

Answer:

A sheet that contains only a chart that provides a visual representation of worksheet data.

Question 24: arithmetic operator

Answer:

An operator that performs addition, subtraction, multiplication, division, or exponentiation.

Question 25: sum

Answer:

The function that adds values in a specified range.

Question 26: range

Answer:

A group of cells in a rectangular block

Question 27: AutoComplete

Answer:

The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier.

Question 28: scale

Answer:

To change the size of the worksheet on the printed page.