Microsoft Excel Fundamentals and Skills Project (BIM)

True

=$A10/B5 uses absolute cell references. (T/F)

False

=SUM(A1:A9)/2 is a formula that DOESN'T use cell reference. (T/F)

True

In an Excel table, to fill a formula down a column, you need to enter the formula in the first cell. Excel will then automatically copy the formula down the other cells in the column.

25-13

In this formula, which calculation is performed first? =12*A3*(25-13)

15/3

In this formula, which calculation is performed first? =A2+15/3+100/E4

B4*100

In this formula, which calculation is performed first? =B4*100+15/3

Yes

Is (=F18+F19/2) a formula that uses cell reference?

True

Merging cells means to combine 2 or more cells into a single cell. (T/F)

True

Microsoft Excel can use Headers & Footers, just like Microsoft Word.

False

Monthly Payment!A10 is a cell reference that would not result in an error. (T/F)

False

Source Data!B12 is a cell reference that will not result in an error. (T/F)

True

The Autofill automatically fill cells with information based on other selected cells. (T/F)

True

The Margin controls adjust the amount of white space around the outside of the printed page. (T/F)

True

The What-if Analysis Scenario tool allows you to define input variables in various situations. The output result for each situation is show in a summary table. (T/F)

True

The quickest way to enter a function in a cell if you already know the name of the function is to directly enter the function in the cell. (T/F)

F3:F26

What is the argument in this function? =AVERAGE(F3:F26)

F3:F26

What is the argument in this function? =MAX(F3:F26)

Page Break Preview

What is the best View for planning how your Excel worksheet data fits on a printed page?

Comma

What is the most common type of delimiter?

$

What symbol is used to designate an absolute cell reference?

Formulas

What term refers to mathematical equations used in Excel to perform calculations?

Line

What type of chart best shows how data changes over time?

The worksheet will be MOVED

What will happen when you drag and drop a worksheet tab into another workbook WITHOUT holding the Ctrl key down?

False

When using conditional formatting on a cell, highlighting negative numbers by using red text does not occur. (T/F)

True

When you hide a column in Microsoft Excel, the column doesn't appear, but the data is still there. (T/F)

Page Layout

Which Page View shows how a worksheet will appear on a printout?

Page Break Preview

Which Page View shows where the worksheet is split into separate pages for printing?

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to determine how your company can stay profitable by varying the commission rates for your 12 sales people.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to keep a car loan under $400 a month.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to payback a student loan in 10 years.

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to find out what interest rate you have to get in order to keep your house payment under $1200 a month.

Ctrl-C

Which keys would you press to copy worksheet data into the clipboard?

Ctrl-V

Which keys would you press to paste worksheet data into the clipboard?

Ctrl-A

Which keys would you press to select all the data on a worksheet?

Currency

Which number format would you want to apply to a cell showing the total sales for the month?

Formulas

Which of the following DOES NOT have to be considered when looking at the page layout before printing a worksheet?

Text file

Which of the following files can be used to import data into Excel?

In the header

Which of the following would be the best location to place your name on a spreadsheet?

Landscape

Which page orientation displays more worksheet columns?

Portrait

Which page orientation displays more worksheet rows?

False

You access the hide/unhide command for a group of selected cells by left clicking on the selected cells. (T/F)

True

You can change the chart type even after it has been created. (T/F)

True

You can rename a worksheet by double-clicking the worksheet tab. (T/F)

True

You can use borders to create a group of cells or make specific cells stand out. (T/F)

False

You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.

True

You double-check formulas in a worksheet by showing formulas in a print-out. (T/F)

Pie

You have been tracking your home expenses in different categories. You want to see what percentage of the total each category represents. Which type of chart would be best for this purpose?

Changed alignment

You have decided to center the text within a cell. What have you done?

Bar

You want to chart the average summer time temperatures of the 20 hottest cities in the United States. Which type of chart would be best for this purpose?

Bar

You want to compare the batting average of every baseball player in the league. Which type of chart would be best for this purpose?

Column

You want to compare the shooting percentage of the five starters on the basketball team. Which type of chart would be best for this purpose?

Autofill

You want to enter a series of dates down a column. What would be the best tool for the job?

Line

You want to show the stock price of a company over the last 6 months. What type of chart would be best for this purpose?

True

you would want to change the column width to make sure all of the information in the column is visible. (T/F)

False

Adding borders on the cells is just for decoration, not to group the cells. (T/F)

Goal Seeking

Allows you to define output results and then shows what input values are needed to generate that result.

Data Table

Allows you to investigate how changes to one or two input variables in a formula changes output results.

True

AutoFill automatically adjusts formulas with relative cell references. (T/F)

False

Find the five top sales people in a company is an example of what a what-if analysis is. (T/F)

Roman numerals

Give one example of something that is NOT a number format in Excel.

Wrap the text

How can you make a large amount of text visible in a cell without changing the width of the cell?

0

How many arguments are used in the following Excel function which returns the current date and time? NOW()

1

How many errors are in the following formula? =(A3+A5+A6)/A5*B1)

2

How many errors are in the following formula? SUM(A2:B10)+(C3/)(E3-E10))

4

How many operands are in the following formula? =D4+D13-D15*D13

3

How many operators are in the following formula? =B14+AVERAGE(E1:E50)-D3/D6

True

If a cell has a DARK fill color, then the text color should be: A LIGHT color to create contrast. (T/F)

True

If you don't want to print out some data on your worksheet, you can hide the rows or columns containing the data. (T/F)

Portrait

If you had a worksheet with 46 rows and 3 columns of data, what would probably be the best page orientation for the worksheet?

Scenario

If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?

=

In Excel, all formulas must begin with what symbol?

False

In an Excel table, if you enter a formula in the top cell of a column, the formula would NOT be automatically copied down the column. (T/F)