Unit 1
How can you make a large amount of text visible in a cell WITHOUT changing the width of the cell?
Wrap the text
Why would you add borders to cells?
To group the cells
Which tab would you select to create a table?
Insert
Which tab do you use to access the Print controls?
File
Which page orientation displays more worksheet columns?
Landscape
Which tab would you go to in Word to change the page orientation?
Page Layout
What type of file can be used to import data into Excel?
text files
Which action lets you rename a worksheet?
double-clicking the worksheet tab
What keyboard shortcut allows you to paste clipboard data into a worksheet?
Control-V
Which page orientation displays more worksheet ROWS?
Portrait
When selecting color, you want your cell fill color and text color to ________
(starts with a C)
contrast
What does a formula include to have an ABSOLUTE cell reference?
$
Page Break Preview
In Excel, which statement best describes the What-if Analysis Scenario tool?
A.) Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.
B.) Allows you to define output results and then shows what input values are needed to generate that result.
C.) Allows you to investigate how changes to one or two input variables in a formula changes output results.
A
How can you double-check formulas in a worksheet?
Show formulas in a printout
How many errors are in this formula?:
=SUM(A2:B10)+(C3/)(E3-E10))
2
Which chart would be the best option if you want to show the daily stock price of a company over the last 6 months?
Line
Which calculation would be performed first in the formula?
=B2+20/2+75/E4
20/2
If you want to figure out how to pay back a student loan in 10 years, which What-If Analysis tool would you use?
Goal Seeking
Draw an example of a bar chart
*****
***********
******************
******
**************
Which tab would you use to import data from a text file?
Data
How many errors are in the formula below:
=(A3+A5+A6)/A5*B1)
1
If you want to compare the batting average of every baseball player on the team, which type of chart should you use?
Bar
If you want to determine how your company can stay profitable by varying the commission rates for your 12 sales people, which What-If Analysis tool would you use?
Data Table
What will happen with the selected worksheet when "OK" is clicked in the "Move or Copy" dialog window?
A.) It will be moved before "Sheet3" in the Sample workbook. It will be moved before "Sheet3" in the Sample workbook.
B.) It will be moved after "Sheet3" in the Sample workbook. It will be moved after "Sheet3" in the Sample workbook.
C.) It will be copied before "Sheet3" in the Sample workbook. It will be copied before "Sheet3" in the Sample workbook.
D.) It will be copied after "Sheet3" in the Sample workbook
D