DIT Microsoft Excel Test Review: Projects 1-10 GMetrix

Concerning general payroll templates, which of the following is considered a normal work week in America that does not call for overtime pay? a. 35 hours b. 40 hours c. 37.5 hours d. 45 hours

b. 40 hours

Which of the following is the basic outline for all IF logic functions? a. IF(criteria here,true statement here,false statement here) b. =IF(criteria here,true statement here,false statement here) c. =IF(criteria here;true statement here;false statement here) d. =IF(criteria here,false statement here,true statement here)

b. =IF(criteria here,true statement here,false statement here)

Assuming cell D19 contains the words "kentucky derby", which function below would bring about "Kentucky Derby"? a. =CAP(D19) b. =PROPER(D19) c. =UPPER(D18) d. =UPPER(D19,2)

b. =PROPER(D19)

Importing data from the _____________ option allows you to bring in text from a file that has been typed and separated with spaces or commas (*C*ommas *S*eparated *T*ext). a. Query Editor b. From Text/CVS c. Facebook d. Sharepoint folder

b. From Text/CVS

Which of the following is NOT a cell style listed in the Cell Styles options? a. Neutral b. Mood c. Explanatory d. Warning Text

b. Mood

Which of the following is a function? a. =LOGIC(B2:B7) b. =B3+B9 c. =MAX(B2:B7) d. =N8

c. =MAX(B2:B7)

Which of the following inspections should be ran on a file to see whether the file will open properly on another computer without any technical issues? a. Transparency Checker b. Check Accessibility c. Check Compatibility d. Inspect Document

c. Check Compatibility

Which of the following is NOT an option in the sheet protection dialog box? a. Edit objects b. Sort c. Create chart d. Insert hyperlinks

c. Create chart

What would be the step value used to fill a series of numbers in this format: 10, 15, 20, 25, 30? a. Fill by 5 b. 10 c. 1 d. 5

d. 5

Which of the following functions has an error in it? a. =SUMIF(G5:G20,"chocolate",H5:H20) b. =COUNTIF(G5:G20,"premium") c. =SUM(Credits) d. =AVGIF(G5:G20,"vanilla",H5:H20)

d. =AVGIF(G5:G20,"vanilla",H5:H20)

To join the contents of cell R2 and cell D2, which function is correct? a. =JOIN(R2,D2) b. =CONTATENTE(R2,D2) c. =STRING(R2,D2) d. =CONCATENATE(R2,D2)

d. =CONCATENATE(R2,D2)

Assuming that cell C7 contains the word "New Orleans", which function below will bring about the following result: lea? a. =MID(C7,6,3) b. =PROPER(C7,3) c. =LEFT(C7,3) d. =MID(C7,7,3)

d. =MID(C7,7,3)

Which of the following functions will NOT work due to structure errors? a. =PROPER(F4) b. =CONCATENATE(D4," ",D9) c. =IF(D3<90,"Great Job","Keep Trying") d. =MID(D3 , 6, 2)

d. =MID(D3 , 6, 2)

Which of the following is NOT a Tick Mark option for axis formatting? a. Inside b. Outside c. Cross d. Hash

d. Hash

Which of the following is NOT a type of Sparkline used in Excel? a. Column b. Win/Loss c. Line d. Negative/Positive

d. Negative/Positive

Which of the following is NOT a conditional formatting option? a. Bottom 10% Rule b. Solid Fill Purple Data Bar c. Red to Black Shapes d. Rating 3 Moons

d. Rating 3 Moons

Functions that contain the word "if" are known as ____________ functions.

logic

Which punctuation mark is used in formulas to show that you have to GO to another sheet to get something?

!

If you want nothing to appear in a cell as part of a logic function, what do you enter in the function as part of the true/false statements?

""

Which punctuation mark is used in Absolute Reference formulas?

$

Which of the following currency formatting is preferred by most accounting professionals? $4,000.00 $ 4,000.00

$ 4,000.00

What are the default left and right margins for Excel?

0.7 inches

Concerning general payroll templates, how is overtime often calculated?

1.5 times their normal hourly salary

When using Flash Fill, you must enter in ____________ of the correctly formatted cells, and then Flash Fill will complete the rest of the selected area for you.

2

Headers and footers in Excel are divided into how many sections?

3

In the world of desktop publishing, how many points equal an inch?

72

Which formula/function does NOT produce the exact same result? =SUM(B3:B5) =B3+B4+B5 =ADD(B3:B5 =SUM(B3,B4,B5)

=ADD(B3:B5

Which of the following functions would count the number of non-empty cells in a numerical range of data? =COUNT(A4:A29) =COUNTA(A4:A29) =SUM(A4:A29) =COUNTIF(A4:A29)

=COUNT(A4:A29)

Which formula below doesn't contain an error? G4+7 =4G+7 =G4+7

=G4+7

In what group on the Format Picture Tools tab do we find Artistic Effects?

Adjust

What is the name for this formula? =F8

Cell Reference Formula

Printing sets of paper that are ready to put into packets/be stapled is done by selecting the ____________ option when printing multiple pages.

Collate

In the "Change Color" menu on chart tools, what are the two major types of colors?

Colorful and Monochromatic

Data Validation can be found on the ____________ tab.

Data

The values associated with the specific parts of a chart can be inserted onto the chart by adding ______________.

Data Labels

_________________ limits the type of data that can be entered into cells based on criteria and rules that you establish for that range.

Data Validation

To name a range of data, simply right click on the name and choose ____________.

Define Name

What is the keyboard shortcut for Spell Check?

F7

True or False: By default, comments will print in Excel.

False

True or False: Filtering permanently removes data from a worksheet.

False

True or False: Freezing the Panes and Splitting the Screen create the exact same effect.

False

True or False: In Excel, hitting the "Tab" key once and hitting the "Increase Indent" option once produce the exact same result.

False

True or False: In Quick Layout #1, the title is not shown.

False

True or False: Left clicking in the Status Bar allows you to update it.

False

True or False: Moving a chart is the same as copying a chart.

False

True or False: Spaces are generally allowed in formulas without resulting in errors.

False

True or False: The default calculation setting in Excel is "manual."

False

True or False: Worksheets are the same as Workbooks.

False

True or False: You can display the formulas on screen instead of their values, but you can't print in formula mode.

False

True or False: When spell checking a document, you can add words to the software's dictionary by selecting the "Dictionary Addition" button.

False (Add to Dictionary)

True or False: Named ranges in Excel can only be one or two words long.

False (Only one word)

Which tab on the ribbon do you go to in order to protect a workbook?

File

Double underlining is found in what group?

Font

In what group on the Home tab do we find the Border options?

Font

The AutoSum option is found on which tab?

Home

Which of the following combines the contents of the selected cells by putting them into a large single cell?

Merge

Grouping rows or columns together can be done by going to the _____________ group on the Data tab.

Outline

Which Paste option do you need to select if you want the data to be connected so that changes to one set of data are automatically made to the pasted set of data?

Paste Link

There are two areas of a chart: the plot area and the chart area. Which one contains the slices of a pie chart or the bars of a bar chart?

Plot Area

Excel files may be saved as PDF files. PDF stand for __________.

Portable Document Format

To make a mirror image of a SmartArt, select the ___________ option on the SmartArt Design Tools.

Right to Left

What is the difference between Serif and Sans Serif?

Sans Serif does not have ornamentation.

The first time you save a document, should you choose "Save" or "Save As"?

Save As

To email an Excel workbook directly from Excel, select File, ____________.

Share

To format data as Zip Codes, choose the _______________ category under the Format/Number dialog box.

Special

_________________ are predesigned files that give you a professional look and expert format, including built-in formulas, that save you a great amount of time.

Templates

True or False: "Find Conditional Formatting" is found on the Home tab.

True

True or False: "Setting the Print Area" can be found on the Page Layout tab.

True

True or False: Adding Alternate Text to a document or to objects in a document can assist people who may have difficulty viewing the document or objects in the document.

True

True or False: Ascending sort is A-Z, and descending sort is Z-A.

True

True or False: Banded rows and columns refers to every other row and column being a different shade or color.

True

True or False: Data can be typed directly into SmartArt, or you can use the text pane to enter the same data.

True

True or False: Deleting cell data is the same as clearing the contents of a cell.

True

True or False: Ensuring that the "View Headings" option is selected will result in the Column/Row heading being visible on the worksheet.

True

True or False: Entire worksheets can be hidden from view in Excel.

True

True or False: Formulas cannot contain spaces.

True

True or False: Headers and footers can be inserted by going to Page Layout view.

True

True or False: Hitting the ESC key turns off the Format Painter.

True

True or False: If a table is named, you can easily navigate to that table via the "Go To" option.

True

True or False: In order for cell data to be locked, you must enforce the worksheet protection by inserting a password.

True

True or False: In order to move or copy a worksheet into another workbook, the destination workbook (file) must be open.

True

True or False: In the world of business, another name for a bill is an invoice.

True

True or False: Names of ranges can be entered into the Name Box for quick navigation to the specified range.

True

True or False: Rows are labeled with numeric characters.

True

True or False: Slices of a pie chart can be filled with graphics/pictures.

True

True or False: SmartArt can be spellchecked electronically.

True

True or False: The "hyperness" of a hyperlink can be removed from a hyperlink.

True

True or False: The vertical axis of a chart is also known as the "Y" value.

True

True or False: To print a chart in full-page size, simply have the chart selected when you select Print.

True

True or False: Using Quick Analysis allows you to clear formatting from data?

True

True or False: When data is formatted as a table, filtering is automatically turned on in the header column.

True

True or False: When using templates, always make sure you either fill in or delete the content controls such as "Company Name Here."

True

True or False: You can arrange worksheets by simply dragging and dropping them to the desired location.

True

True or False: You can set a picture to be viewed in a file but not to actually print when a document prints.

True

To turn off the formula bar from the Excel window, go to the ___________ tab on the ribbon.

View

The custom view option is found in the ___________ group.

Workbook View

The __________ option allows you to put extra-long cell data onto multiple lines, thus taking up less horizontal space.

Wrap Text

Which of the following formulas is a correct formula that uses data from other worksheets to calculate an answer? a. ='Sheet 1'!B6+'Sheet 2'!B6+'Sheet 3'!B6 b. =SUM(GoSheet1?B6+GoSheet2?B6+GoSheet3?B6) c. =S1B6:S3B6 d. =Sheet1B6+Sheet2B6+Sheet3B6

a. ='Sheet 1'!B6+'Sheet 2'!B6+'Sheet 3'!B6

Which of the following functions would correctly return how many cells in that range contain the word "chocolate"? a. =COUNTIF(A6:A19,"chocolate") b. =COUNT(A6:A19,"chocolate") c. =TOTAL(A6:A19,"chocolate") d. =SUMIF(A6:A19,"chocolate")

a. =COUNTIF(A6:A19,"chocolate")

Which of the following options contains an error? a. =IFCOUNT(C3:C99,"Chocolate") b. =COUNTIF(C3:C99,"Chocolate") c. =(B8+N9)/V2 d. =IF(b2>100,30,0)

a. =IFCOUNT(C3:C99,"Chocolate")