GAC011 TIC I - Period 1

In Microsoft Excel, a _____ starts with "=" sign and is used to calculate cells

In Microsoft Excel, data displays in the _____ as you type.

In Excel, what is the type of cell reference that does not change when copied or filled?

In the following Excel function, what is E5:F10? =MIN(E5:F10)

In Microsoft Excel, when you click a cell, its contents appear in the _____

In Microsoft Excel, the _____ is located below the Ribbon at the left end of the Formula Bar

In Excel, what is the result of the formula =(5+2)*3?

In Microsoft Excel, one or more continuous cells is a _____

In Microsoft Excel, what two things do you specify the first time you save a file?

In Microsoft Excel, the easiest way to select an entire column is to _____

In Microsoft Excel, each column in a worksheet is identified by a unique _____

In Excel, what type of cell reference is N$29?

In Excel, which is an absolute reference?

Tabs that identify the worksheets in an Excel workbook?

In Microsoft Excel, where is the Fill Handle located?

In a Microsoft Excel cell you can enter text, formulas and _____

Describes the structure or order of the elements in an Excel formula?

If you key the value 7.5 into a worksheet cell, this value is an example of a(n) _____

Two methods for referencing cells in Excel - one is 'relative'. What is the other?

What happens if you key in an empty worksheet a text that is longer than the width of a cell?

In Excel, built-in formulas that performs more complex calculations are called _____

In Microsoft Excel, what is a chart?

Select the Microsoft Excel file in which you work and store your data

If you want to see a list of the functions available in Excel, what command would you click on the Formulas tab?

In Microsoft Excel, what are worksheets composed of?

What Excel formula add up a column of numbers?

To quickly move from cell D20 to cell R42, you can key “R42” into the _____ and press [Enter]

What Excel function calculates the largest value?

In Microsoft Excel, any set of characters containing a letter, hyphen, or space is considered a _____

In Excel, what type of cell reference is N29?

In Microsoft Excel, which of the following would you press to move from G3 to H3?

In Microsoft Excel, B5 is an example of a _____

In a formula, Excel performs _____ after multiplications

In Microsoft Excel, the _____ gives you fast access to the tools most often used in Excel

In Excel, what you get with the COUNT function?

In Microsoft Excel, A1:A20 is an example of a _____

How does Microsoft Excel determine that a cell contains a formula?

A fast way to add up a column of numbers in Excel is to click in the cell below the numbers and then _____

In Excel, what is the purpose of using parentheses in formulas?

In Microsoft Excel, each row in a worksheet is identified by a unique _____

Which of the following Excel functions is invalid?

The letter and number referring to the intersection of a row and column is called _____

What happens if you click the Dialog Box Launcher at the lower-right corner of a group?

What Excel formula counts the cells that are not empty?

In Microsoft Excel, you can select non-contiguous cells using the key _____