Quiz
Untitled
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (100)
1Which of the following is a cloud storage area where you can store files in a private and secure online location?
- AFile Explorer
- BSkyDrive
- COffice 2013
- DOffice Web Apps
2Which of the following keyboard shortcuts lets you paste a paragraph in another location?
- ACtrl+C
- BCtrl+M
- CCtrl+V
- DCtrl+X
3By default, what file extension is given to Excel workbook files?
- A.xlsm
- B.xls
- C.xlsx
- D.xltm
4What must you do to enter a number as a label in a cell?
- APress spacebar before typing the number
- BType an open parenthesis before the number
- CType an apostrophe before the number
- DFormat the number as a label
5By default, how does Excel align numeric entries in a cell?
- Atop left corner of a cell
- Btop right corner of a cell
- Cbottom left corner of a cell
- Dbottom right corner of a cell
6What is selected when you click the button located above the row 1 heading and to the left of the column A heading?
- Athe entire column
- Bthe entire row
- Cthe entire worksheet
- Dthe 20 cells adjacent to the top of the column
7How many items can the Clipboard hold?
- A12
- B16
- C24
- Dunlimited
8Which of the following options allows you to copy formatting attributes and styles from one cell to another cell or group of cells?
- AFill Handle
- BFormat Painter
- CPaste Special
- DFormat Cells
9Which of the following is a set of predefined formatting you can apply to titles, subtitles, column headings, row totals, and other areas of your worksheet?
- Acell style
- Brange style
- Cworksheet style
- Dformat Painter
10Which of the following features enables you to display the contents of a cell on multiple lines?
- AAutoFormat
- BAutoFit
- CMerge&Center
- DWrap Text
11Before using the Merge & Center command, what cell should contain the data?
- Aupper-left cell
- Bbottom-left cell
- Cupper-right cell
- Dbottom-right cell
12Which of the following commands should you use to prevent column and row headings from scrolling off the screen?
- Azoom options
- Bfreeze Panes command
- Cstatus bar view commands
- Dmerge & Center command
13To select non-adjacent worksheets, which key must you press?
- ACtrl
- BAlt
- CShift
- DTab
14Which of the following features expands or reduces a worksheet to print on a specific number of pages?
- AScale to Fit
- BZoom
- CAdvanced Properties
- DPrint Area
15Which of the following Formula Auditing tools displays arrows that point to the cells referenced in the selected formula?
- ATrace Precedents
- BTrace Dependents
- CError Checking
- DEvaluate Formula
16Which of the following indicates that a cell might contain an error?
- Ared border
- Bgreen border
- Cred triangle in upper-left corner of the cell
- Dgreen triangle in upper-left corner of the cell
17In cell D10 , Rachel entered the following formula: =D8+D9+D10. Which of the following terms describes what is going on with this formula?
- Aabsolute reference
- Bmixed reference
- Ccircular reference
- Dnone of the above
18Which of the following provides an example of a mixed reference?
- AR4
- B$R4
- C$R$4
- Dall of the above
19Which of the following is a true statement?
- AThere are three types of cell references you can use in a formula.
- BThe type of cell references included in a formula determines the result of a formula when it is copied.
- CCells that contain absolute references do not change when copied.
- DAll of the above
20Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
- AF2
- B$F$2
- C$F2
- DF$2
21What is the right formula in B4 to create a multiplication table as you see below? Cell B4 is copied into the rest of cell in the multiplication table using fill handle?
- A= $A$4*$B$3
- B= A$4*$B3
- C= $A4*B$3
- D= A4*B3
22Which of the following cell addresses contains a column reference that is absolute and a row reference that will change when copied?
- AF2
- B$F$2
- C$F2
- DF$2
23Once you have selected a cell address, which of the following keys lets you insert dollar signs quickly?
- AF2
- BF4
- CF6
- DF8
24Which of the following statements is not true?
- ARange names are used to identify a cell or group of cells.
- BRange names can make it easier to interpret a formula.
- CThe first character of a range name must be a letter, an underscore, or a backslash.
- DWhen you name a cell or range, the name becomes a relative reference.
25Which of the following characters must always start a function?
- A=
- B(
- C$
- DNone of the above
26If APR in the cell C8 is 6.5% and Loan Term in the cell F4 is 7 year, which of the following is the right formula using the PMT function?
- A=PMT(C8,F4,Loan_Amount)
- B=PMT(C8*12,F412,Loan_Amount)
- C=PMT(C8/12,F4/12,Loan_Amount)
- D=PMT(C8/12,F4*12,Loan_Amount)
27Which of the following charts displays the magnitude of change over time and shows the rate of change?a
- AArea
- BXY
- CStock
- DRadar
28What do trendlines demonstrate?
- ATotals
- BAverages
- CMaximum values
- DNone of the above
29Which of the following is not true about filters?
- AA filter is criteria that specifies which data is shown.
- BA filter is criteria that specifies which data is hidden.
- CFilters let you switch between several scenarios for your data.
- DFilters alter the source data range.
30For most pie charts, what is the maximum number of pie slices you should have?
- A2-3
- B4-5
- C6-7
- D9-10
31What can pie charts graph?
- Aa single data series
- Bup to three data series
- Cup to five data series
- Dan unlimited number of data series
32Which of the following is a criterion or a specification that data must meet to be shown?
- AAccess cannot illustrate data in a chart, but Excel can.
- BExcel is capable of managing large databases.
- CExcel includes more advanced reporting capabilities.
- DAll of the above.
33In an Excel table, which of the following represents a column of data?
- Aheader row
- Brecord
- Cfield
- Dtable
34Which of the following is a criterion or a specification that data must meet to be shown?
- AFilter
- BAutoFilter
- CCriterion range
- DAll of the above
35When you first create an Excel table, what name does Excel give it initially?
- ATableA, where A is a letter
- BTableC, where C is a character
- CTableN, where N is a number
- DTableS, where S is a symbol
36Which of the following can you sort Excel data by?
- Atext data
- Bnumber data
- Ccell fill color
- Dall of the above
37When you sort a cell range using A to Z or Z to A, what is rearranged?
- Anumeric values
- Bcells within a selected row
- Ccells within a selected column
- Dcomplete rows of data
38How does Excel treat criteria entered on different rows?
- AAND condition
- BOR condition
- CFILTER condition
- DBOTH condition
39Which of the following lets you create your own conditional formatting rule as well as edit existing rules?
- AData Bar command
- BConditional Formatting command
- CManage Rules command
- DRules Command
40Which of the following finds a solution for one of the arguments in a formula?
- AWhat-If Analysis button
- BSeek command
- CBacksolve command
- DGoal Seek command
41When creating a consolidation sheet, what must you do to the range of cells that will be consolidated?
- Acopy them
- Bmove them
- Cdelete them
- Dformat them
42Which of the following can you do right after you create a dynamic consolidation?
- Acollapse each outline item
- Bexpand each outline item
- Cconvert the outline to plain text
- Ddelete the outline
43What happens when you click in a SmartArt shape and begin typing?
- AThe entry appears in the shape and in the text pane.
- BThe label is sized to fit the shape as you type.
- CEach shape has its own selection handles and frame.
- DAll of the above
44Which of the following statements is true about editing and formatting grouped worksheets?
- AWhen you group sheets, most editing commands that you preform affect every sheet in the group.
- BWhen you group sheets, most formatting commands that you preform affect every sheet in the group.
- CIt is important that you carefully plan your commands for grouped worksheets.
- Dall of the above
45How many arguments do all database functions have?
- A2
- B3
- C4
- D5
46Which of the following statements is not true about the IF function?
- AA nested function is a function within a function.
- BLogical functions are not commonly nested.
- CYou can use AND and OR with an IF function to build a statement that checks for more than one requirement.
- DIn a simple IF formula, you can check one logical test and set one value if it is true and another value if it is false.
47Which of the following error values indicates that a cell reference is empty, usually because cells were deleted?
- A#N/A
- B#VALUE!
- C#REF!
- D#DIV/0
48In the MATCH function, which of the following match_type arguments finds the first value that exactly matches the lookup_value?
- A1 or omitted
- B0
- C-1
- Dnone of the above
49In the MATCH function, which of the following match_type arguments finds the smallest value that is greater than or equal to the lookup_value?
- A1 or omitted
- B0
- C-1
- Dnone of the above
50Which of the following illustrates an accurate, statistical analysis of forecasting errors?
- AMean absolute deviation (MAD)
- BMean square error (MSE)
- CSTDEV.S
- DStandard Deviation
51Which of the following measures how broadly values deviate from the mean or average value in the range?
- Amean absolute deviation (MAD)
- Bmean square error (MSE)
- CSTDEV.S
- Dstandard deviation
52Which of the following are the rules applied to data as it is entered?
- Aerror alert message
- Binput message
- Cvalidation settings
- Dform
53When typing entries for a data validation list in the Data Validation dialog box, what should you separate items with?
- A#
- Bsemi colon
- Ccommas
- Dslashes
54In Excel, which of the following keys displays a list of range names?
- AF3
- BF4
- CF5
- DF6
55Which of the following prohibits a user from making an entry, and gives him or her the choice of wither canceling the task or retrying?
- Aerror alert
- Bstop warning
- Cwarning box
- Dinformation message box
56Which of the following shows an exclamation point in a yellow triangle?
- Aerror alert
- Bstop warning
- Cwarning box
- Dinformation message box
57Which of the following is a programming language that allows you to expand the abilities of Excel?
- AVBA
- BActiveX Control
- CForm control
- DTrust Center
58When you select a state abbreviation from a combo box, how does the form control record your selection?
- Aas a number
- Bas an alphanumeric character
- Cusing the characters you selected from the combo box
- Das a string of letters and numbers
59Which of the following statements is not true about protecting a workbook?
- AThe Mark as Final command is not a read-only property.
- BOnce the Mark as Final command has been used, it is easy for a user to remove the property by clicking the Edit Anyway button.
- CExcel allows you to assign various security levels for your work.
- DIn Excel, you can set a simple command to permit a user to view a workbook but not edit it.
60Which of the following statements is true about protecting workbooks with a password?
- AYou can protect workbook structure with a password.
- BYou can protect workbook structure without a password.
- CIf you use a password, you must enter that password to remove the protection.
- Dall of the above
61For workbooks that might contain data from a questionable source, which of the following views does the workbook open in?
- AUnprotected View
- BProtected View
- CUnsafe View
- DSafe View
62Which of the following is a true statement that might describe Solver?
- AIt solves a problem in reverse, starting with the desired answer.
- BIt is used to create and test new formulas.
- CIt starts with a problem and then finds a solution.
- Dall of the above
63What are the three Solver components known as?
- Aconstraints
- Bvariable cells
- Cobjective cell
- Dparameters
64Which of the following reports displays data about the lower and upper limits of each variable cell and how those limits impact the objective cell?
- AAnswer report
- BSensitivity report
- CLimits report
- DFeasibility report
65How many types of reports can you create using the Solver Results dialog box?
- A2
- B3
- C4
- D5
66Which of the following statements related to scenario summary reports is not true?
- AYou cannot edit a scenario after creating a summary report.
- BFor a large worksheet with many scenarios, you can choose to format a scenario summary report as a PivotTable.
- CIn a summary report, you can hide or display details about the changing cells and the result cells.
- DA scenario summary report is a generated worksheet that describes each scenario in a workbook.
67If you want to analyze a field in a PivotTable as a value and as a ratio or percentage, how many times can you add the field in the Values area?
- Aonce
- Btwice
- Cmultiple times
- Dno more than ten times
68In a two-variable data table, which of the following is included in the table range?
- Athe formula
- Bthe input column and input row
- Cthe empty result cells
- Dall of the above
69In an XML file, which of the following characters encloses the tags?
- Acurly braces {}
- Bbrackets []
- Cchevron braces <>
- Dparentheses ()
70Which of the following XML file extensions is for files that provide data scheme information?
- A.xsi
- B.xst
- C.xsd
- D.xds
71When a macro runs, where does it carry out its commands?
- Ain just the current worksheet
- Bin just the current workbook
- Cin any open workbook
- Din any saved workbook
72By default, how is a macro recorded?
- Awith absolute references
- Bwith relative references
- Cwith mixed references
- Dwith all of the above
73The code behind a macro is written in a programming language that is often referred to as _______.
- AVBA
- BVBE
- CVB
- DVBB
74What happens when you try to save a workbook with macros as a regular Excel workbook?
- AThe workbook file is saved as usual.
- BA message box displays indicating that your VBA work was saved.
- CA message box reminds you that your VBA work cannot be saved in a regular workbook.
- DA message box reminds you that the workbook's file size will be larger as a result of the macros.
75Which of the following statements is not true about VBA?
- AVBA is not a programming language.
- BAs you record a macro, Excel converts your keystrokes into VBA code.
- CCode describes the specific programming commands required for an automatic task to run.
- DProgram and procedure are other names used for code.
76When you run a macro that was recorded with absolute references, where should the cursor be before running the macro?
- Aanywhere in the worksheet
- Bin a specific starting location
- Cin cell A1
- Danywhere below row A
77Which of the following is used to enter records into a table?
- ADatasheet view
- BDesign view
- CLookup view
- DObject view
78Which of the following is not true about a new field name?
- AIt should be unique
- BIt is limited to 128 characters
- CIt can include letters, numbers, and most special characters
- DIt cannot include a period, exclamation mark, accent grave, or square brackets
79Which of the following contains a unique value for each record?
- Aprimary key
- Blookup field
- Cmetadata
- Dcell number
80When you set field properties, the available properties vary based on the:
- AField length
- BField target type
- CField name
- DField data type
81The default size of a Short Text is
- A64 characters
- B128 characters
- C255 characters
- DUnlimited characters
82When you limit entries to a certain range of values or making sure entries match a specified format, you use:
- AField validation rules
- BDatacheck
- CParameters
- DAccess rules
83Which of the following field validation rules prevents the user from typing 0 into a field?
- A<5
- B<>0
- C'M' or 'F'
- D-Not Null
84What is a primary key called that is made up of more than one field?
- Aprimary key
- Bforeign key
- Cconcatenated key
- Dcombined key
85When importing data records from Excel, which of these must be true?
- AThe Excel file must have been created by the same user
- BThe Excel file must contain the same number of fields as in the Access file
- CThe Excel file must be delimited
- DThe first row of the Excel file must contain the field names from the Access table
86Which of the following finds data in your database by allowing you to ask a question?
- AA table
- BA query
- CA form
- DA report
87Which of the following tabs do you use to create a query?
- AFile
- BHome
- CCreate
- DDatabase Tools
88To see the results of a query, you need to click what?
- ASee
- BView
- CRun
- DSolve
89What names does Access assign to new queries?
- AQuery
- BQuery1
- CQueryData1
- DQueryResults1
90Which of the following should you add to a query to search for records that meet a specific value?
- ACriterion
- BLike comparison
- CWildcard symbols
- DExpression
91When entering a criterion expression, which of the following tools helps suggest a list of possible values?
- AQuery Design Wizard
- BParameter query
- CExpression match
- DIntelliSense
92Which of the following criterion expressions searches for a ShippingDate field greater than January 1, 2014?
- A>1/1/2014
- B>'1/1/2014'
- C>#1/1/2014#
- D>=#1/1/2014#
93Which of the following criterion will reach for songs that contain the word 'love' somewhere in the middle of the song title?
- AContains "love"
- BLike "*love*"
- CLike "*love"
- DLike "love"*
94Query designed in the following screenshot would show ________
- ANumber, name, amount paid, current due, and business analyst number for all clients whose amount paid is MORE than $3,000 AND whose business analyst number is 11
- BNumber, name, amount paid, current due, and business analyst number for all clients whose amount paid is MORE than $3,000 OR whose business analyst number is 11
- CNumber, name, amount paid, current due, and business analyst number for all clients whose amount paid is LESS than $3,000 AND whose business analyst number is 11
- DNumber, name, amount paid, current due, and business analyst number for all clients whose amount paid is LESS than $3,000 OR whose business analyst number is 11
95Which of the following symbols must you use when defining a parameter query?
- A( )
- B{ }
- C[ ]
- D" "
96An Access object you can use to create an interface to easily view, add, update, and delete data in a database is called:
- AA report
- BA query
- CA table
- DA form
97In this view, you can alter the design of a form and see the effects of the changes in real time.
- AForm view
- BLayout view
- CBackstage view
- DTable view
98An object you can use to create an organized and professional output of the data is called:
- AA report
- BA query
- CA table
- DA form
99You can create a report from ________
- AOnly tables
- BOnly queries
- CA relationship between tables
- DBoth tables and queries
100This report layout displays the fields in a table (row and column) format:
- AStepped
- BColumnar
- CTabular
- DJustified
Information
- Description
- Quiz on Untitled, created by Katie Rudnik on 07/12/2015.
- Author
- Katie Rudnik
- Language
- English
- Views
- 7
- Rating
- No ratings yet Rate this quiz