Excel 2019 Certification

An excel __ allows data to be summarized and charted easily

• workflow

• worksheet

• document

• certified

The first step in creating an effective worksheet is to make sure you __

• enter the data

• insert a chart

• understand what is required

• apply font formatting

__ is/are used to place worksheet, column, and row titles on a worksheet

• color

• text

• links

• tabs

Pressing the __ key to complete an entry activates the adjacent cell to the right

• LEFT ARROW

• DOWN ARROW

• RIGHT ARROW

• UP ARROW

You can enter the correct range in a function by typing the beginning and ending cell references separated by a __

• colon (:)

• semi colon (;)

• period (.)

• none of the above

A __ reference is an adjusted cell reference in a copied and pasted formula

• revised

• recycled

• retained

• relative

You __ a worksheet to emphasize certain entries and make the worksheet easier to read and understand

• save

• clear

• format

• print

Combining two or more selected cells into one cell is called __ cells

• mixing

• merging

• spanning

• combining

Which of the following is the Ribbon path to the Cell Styles button?

• (STYLES tab / HOME group)

• HOME tab/ FORMAT group)

• (HOME tab/ STYLES group)

• (STYLES tab/ HOME group)

What effect does the Comma Style format have on the selected cells?

• Converts decimals to commas with merged cells

• Displays cell content with two decimal places and commas as thousands separators

• Allows for substitution of selected characters

• Converts decimals to commas within a cell