Excel Review Day 1

When you reference another workbook in a formula, what symbol is after the source worksheet name within the formula?

What can you use to change text case?

Which of the following commands does not belong to the Windows group on the view tab

which command do you use to change the color of the background of a cell?

Which of the following categories does the AVERAGEIF function belong to?

What is a cell that affects the value of other cells known as?

To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts

Which of the Following would correct the punctuation errors in MAIN STREET

By default when you select enter to complete a cell entry where will the active cell be?

What is the preferred length of alt text

When Excel detects a possible error in a cell, which of the following indicators will the cell display?

To step into a formula, what command would you use?

When a cell has a precedent in another workbook, what is attached to the arrow?

To Cut data from a cell you use?

When referencing a named range in another workbook, what keyboard shortcut can you use to open the Paste Name dialog box

If you use only one section in a number format, Excel applies it to:

Which of the following can you use as a delimiter within a TEXT JOIN function?

Autofill to fill January from cell A1 across to L1, which of the following autofill options will be available to select?

Which area of the Excel application has the following three commands: Save, Undo, and Redo?

Which of the following symbols can you use to override the order of operations?

A range can be named in the name box

A filter based on cell color can be applied to a column

What is the cut data shortcut?

Which of the following conditional formatting rules is best for emphasizing the varience between values in a data range

Which table row calculates numeric data by using functions?

Which of the following emphasizes the largest value in a data series

The keyboard shortcut to access the Paste Special dialog box is:

Which command provides a way to sort with multiple levels

What are different chart types for sparklines

What kind of formattng can be included in cell styles? Select all that apply

What is the name of the dialog box in which you select a rule type for a new rule?

How would you combine text from different columns within a workbook

What do you use to add new words to Office apps?

Ctrl+ H is the correct shortcut to access the Replace feature

What is a delimiter

If you need to find the largest value in a range of numbers what function do you use?

Which of the following operators is used to start a formula

A table can be converted into which of the following

On which tab will you find Watch Window?

What is the keyboard shortcut to reference the current time into a Cell

What is the maximum number of sections a number format can have?

When you reference another workbook in a formula, what type of brackets enclose the source workbook within the formula?

Where will you find the formula bar?

How can you access the backstage view?

The COUNT function will not count negative numbers when evaluating a range of values.

To return an exact match by using the MATCH function, what value would you use for the match type?

What delimiter does a CSV file use

Which workbook view can you use to display the headers or footers while you are editing a worksheet?

Which command do you use to change the color of a cell background?

To paste copied data from horizontal to vertical, which option would you use from Paste Special?

If a cell has a ##### error code, what does it indicate?

You can use the Fill command in the Editing group on the Home tab to:

What is the shortcut key to add a table

Where would you go to review the properties of any workbook

Which of the following options cannot be part of a named range?

Which of the following options are table style catagories? Select all that apply

What's another name for the conditions used in conditional formatting?

On which tab can you find the Check Accessibility command?

To delete a column in a worksheet, you can select the column header and use which of the following keyboard shortcuts:

When you’ve copied data, which of the following is a correct method to paste it somewhere else?Select all that apply.

To insert a row into a worksheet, you can select the row header and use which of the following keyboard shortcuts?

On which group on the Home tab can you find Flash Fill?

The HLOOKUP function belongs to which category of functions?

Which of the following commands does NOT belong to the Formula Auditing group?

What is the keyboard shortcut to the print menu

An IF function can contain additional calculations as arguments.

To position text equally between the top and bottom of a cell, which alignment setting would you use?

If you want to calculate the next 3 working days from a specific date, which of the following functions would you use?

What does the V in VLookup mean