Excel Exam QUIZ 1

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this

DUPLICATE VALUES

Which of the following takes precedence over multiplication?

EXPONENTIATION

To go to column A of the current row, press ____.

HOME

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

PROTECTION

In Excel, dates are _____-aligned in the cell by default, regardless of date format.

RIGHT

To move the active cell up one row, press ____.

SHIFT+ENTER

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell

A1

The characters +, -, *, and / are examples of ____.

ARITHMETIC OPERATORS

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.

PAINTER

Changing the number of decimal places displayed in a cell does not change the value stored in the cell.

TRUE

PAGE LAYOUT VIEW

shows how the worksheet will appear when printed.

Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

QUICK ANALYSIS TOOL

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

TOUCH MODE

mm/dd/yyyy is known as ____.

A DATE FORMAT

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

NONADJACENT

To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

2,1,3

What is the result of the expression =50+20/10*5?

60

The formula used to multiply cell A1 by cell C1 is ____.

=A1*C1

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

AUTOFIT

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it.

FALSE

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

FIND

To set a page break in Excel, select the _____.

FIRST CELL BELOW THE ROW WHERE YOU WANT TO INSERT A PAGE BREAK

____ enters text based on patterns it finds in the data.

FLASH FILL

One of the benefits of Live Preview is that it _____.

LETS YOU SEE AND EVALUATE DIFFERENT FORMATS AS YOU DEVELOP YOUR WORKBOOK

_____ merges each of the rows in the selected range across the columns in the range.

MERGE ACROSS

A(n) ____ is a group of cells in a rectangular block

RANGE

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

TRUE

By default, Excel displays text in a(n) black font color.

TRUE

Conditional formats are dynamic, so a cell's appearance will change to reflect its current value.

TRUE

If you want to print only part of a worksheet, you can set a(n) print area, which is the region of the worksheet that is sent to the printer.

TRUE