Home
Subjects
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
Microsoft Excel Fundamentals and Skills Project (BIM)
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (73)
Autofill
You want to enter a series of dates down a column. What would be the best tool for the job?
=
In Excel, all formulas must begin with what symbol?
Formulas
What term refers to mathematical equations used in Excel to perform calculations?
F3:F26
What is the argument in this function?
=AVERAGE(F3:F26)
$
What symbol is used to designate an absolute cell reference?
Yes
Is (=F18+F19/2) a formula that uses cell reference?
True
You can use borders to create a group of cells or make specific cells stand out. (T/F)
Currency
Which number format would you want to apply to a cell showing the total sales for the month?
True
Merging cells means to combine 2 or more cells into a single cell. (T/F)
False
You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.
Changed alignment
You have decided to center the text within a cell. What have you done?
True
you would want to change the column width to make sure all of the information in the column is visible. (T/F)
True
Microsoft Excel can use Headers & Footers, just like Microsoft Word.
Roman numerals
Give one example of something that is NOT a number format in Excel.
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)
True
You can rename a worksheet by double-clicking the worksheet tab. (T/F)
True
If a cell has a DARK fill color, then the text color should be: A LIGHT color to create contrast. (T/F)
Page Break Preview
Which Page View shows where the worksheet is split into separate pages for printing?
Portrait
Which page orientation displays more worksheet rows?
Page Layout
Which Page View shows how a worksheet will appear on a printout?
Wrap the text
How can you make a large amount of text visible in a cell without changing the width of the cell?
False
Adding borders on the cells is just for decoration, not to group the cells. (T/F)
Text file
Which of the following files can be used to import data into Excel?
Comma
What is the most common type of delimiter?
3
How many operators are in the following formula?
=B14+AVERAGE(E1:E50)-D3/D6
25-13
In this formula, which calculation is performed first?
=12
A3
(25-13)
1
How many errors are in the following formula?
=(A3+A5+A6)/A5*B1)
4
How many operands are in the following formula?
=D4+D13-D15*D13
B4*100
In this formula, which calculation is performed first?
=B4*100+15/3
F3:F26
What is the argument in this function?
=MAX(F3:F26)
0
How many arguments are used in the following Excel function which returns the current date and time?
NOW()
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.
True
The Autofill automatically fill cells with information based on other selected cells. (T/F)
True
AutoFill automatically adjusts formulas with relative cell references. (T/F)
False
=SUM(A1:A9)/2 is a formula that DOESN'T use cell reference. (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)
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?
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?
Ctrl-A
Which keys would you press to select all the data on a worksheet?
Ctrl-C
Which keys would you press to copy worksheet data into the clipboard?
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?
True
You can change the chart type even after it has been created. (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?
Line
What type of chart best shows how data changes over time?
False
Source Data!B12 is a cell reference that will not result in an error. (T/F)
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.
Scenario
If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?
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
Allows you to define output results and then shows what input values are needed to generate that result.
Formulas
Which of the following DOES NOT have to be considered when looking at the page layout before printing a worksheet?
Data Table
Allows you to investigate how changes to one or two input variables in a formula changes output results.
Page Break Preview
What is the best View for planning how your Excel worksheet data fits on a printed page?
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?
In the header
Which of the following would be the best location to place your name on a spreadsheet?
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)
False
Find the five top sales people in a company is an example of what a what-if analysis is. (T/F)
False
You access the hide/unhide command for a group of selected cells by left clicking on the selected cells. (T/F)
2
How many errors are in the following formula?
SUM(A2:B10)+(C3/)(E3-E10))
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?
True
=$A10/B5 uses absolute cell references. (T/F)
Page Break Preview
What is the best View for planning how your Excel worksheet data fits on a printed page?
True
The Margin controls adjust the amount of white space around the outside of the printed page. (T/F)
True
You double-check formulas in a worksheet by showing formulas in a print-out. (T/F)
15/3
In this formula, which calculation is performed first?
=A2+15/3+100/E4
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.
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?
Landscape
Which page orientation displays more worksheet columns?
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)
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)
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.
False
Monthly Payment!A10 is a cell reference that would not result in an error. (T/F)
Ctrl-V
Which keys would you press to paste worksheet data into the clipboard?
This set is often in folders with...
Excel Essentials
29 terms
EXCEL SKILLS
33 terms
Excel Fundamentals
27 terms
Excel
39 terms
You might also like...
Microsoft Excel Skills Project
34 terms
Computer module test 11/12
27 terms
Excel 2013/2016
66 terms
Computer Test: Excel 2: Fundamentals
21 terms
Other sets by this creator
Theatre history vocab
25 terms
Theatre 3/ 27/19
20 terms
Theatre style terms
35 terms
Theatre assignment
15 terms
Other Quizlet sets
test 2
32 terms
Server Side Test 1
103 terms
1. General Equilibrium
25 terms
econ
23 terms