Quiz
OMIS
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 (144)
1New workbooks typically contain how many worksheets?
- A0
- B1
- C2
- D3
2What is the small green square in the bottom right of a cell called?
- ASizing handle
- BFill handle
- CCopy/Paste handle
- DMove cell handle
3What is NOT one of the tabs in Excel?
- AFormulas
- BPage Layout
- CFile
- DMailings
4Which of the following would NOT be considered text?
- APhone Number (111.111.1111)
- BSocial Security Number (111-11-1111)
- CPart number (PT111)
- D=2*2
5How is the text aligned by default?
- ALeft
- BCenter
- CRight
- DDecimal
6In the formula, =1+(2-3)+5/6-6^2, what will excel evaluate first?
- A5/6
- B1+
- C(2-3)
- D6^2
7What should you do if there are columns you need, but do not want to display?
- ADelete the columns you do not want to display then undo your action when finished
- BMove the columns you want to see so that they are together then move them back to their original locations when finished
- CCut and paste the columns you do not want to display to another area of the worksheet
- DHide the columns you do not want to display, and then unhide them when finished
8What does it mean when you see ###### in a cell?
- AYour formula is incorrect
- BAt least one of the cell references in your formula is pointing to an empty cell
- CYour column is not wide enough
- DYour row is not tall enough
9Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?
- APaste
- BValues
- CValues & Number Formatting
- DValues & Source Formatting
10What is the best practice for centering a title over multiple columns?
- AEnter the title in the center column of the range
- BUse the Merge Title feature
- CUse the Merge and Center alignment
- DUse the Combine and Center alignment
11Which of the following names of worksheet tabs would be best?
- ASheet 1
- BJan
- CJanuary Payroll Information
- DJPAE
12What is the best way to make sure your worksheet prints on only one page?
- ALimit the amount of data you put on each worksheet
- BMake the font sizes smaller
- CMake the margins as small as possible
- DUse the fit to option
13Besides the Page Setup dialog box, where else can you create headers or footers?
- APage Layout tab, Text group, Header & Footer
- BInsert tab, Text group, Header & Footer
- CHome Tab, Text group, Header & Footer
- DView tab, Text group, Header & Footer
14What would NOT be a typical item to have in a header or footer?
- AThe spreadsheet designers name
- BThe filename or file path
- CThe file size
- DThe page number
15Where would you find the command to center the printout both horizontally and vertically on your paper?
- AOn the Page Setup, Alignment tab
- BOn the Page Setup, Sheet tab
- COn the Page Setup, Margins tab
- DOn the Page Setup, Page tab
16In Excel, columns are identified by numbers and rows by letters.
- ATrue
- BFalse
17The cell at row 4 and column B would be identified as 4B.
- ATrue
- BFalse
18For the fill handle to work you need to have two cells selected.
- ATrue
- BFalse
19Right-clicking a column heading, then selecting insert, will add a new column to the left of the current column.
- ATrue
- BFalse
20When you copy and paste a range the relative referance does not change.
- ATrue
- BFalse
21The letter in the cell reference "F4" is the:
- AAutoComplete
- BAuto Fill
- CColumn Heading
- DEnter Icon
22_____________ helps complete a logical sequence.
- AAutoComplete
- BAuto Fill
- CColumn Heading
- DRow Heading
- EEnter Icon
23The number in the cell reference "F4" is the:
- AAutoComplete
- BAuto Fill
- CColumn Heading
- DRow Heading
- EEnter Icon
24_______ looks like a check mark next to the formula bar:
- AAutoComplete
- BAuto Fill
- CColumn Heading
- DRow Heading
- EEnter Icon
25_______ matches the letters you type to another value in the column if the letters match.
- AAutoComplete
- BAuto Fill
- CColumn Heading
- DRow Heading
- EEnter Icon
26__________ is the vertical border.
- AX-axis
- BY-axis
- CChart area
- DPlot area
- ELegend
27__________ uses color or patterns to identify each data series.
- AX-axis
- BY-axis
- CChart Area
- DPlot Area
- ELegend
28__________ is the horizontal border.
- AX-axis
- BY-axis
- CChart area
- DPlot area
- ELegend
29Which keyboard shortcut toggles through the types of reference options?
- AF2
- BF3
- CF4
- DF5
30If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?
- AFixed
- BRelative
- CMixed
- DAbsolute
31What is the default method of referencing cells in formulas?
- AAbsolute
- BRelative
- CMixed
- DDefault
32Which of the following is NOT a valid test in an =IF statement?
- AA4-B4
- BA4<B4
- CA4>B4
- DB4<=A4
33The VLOOKUP function has four required arguments.
- ATrue
- BFalse
34__________ only uses calculable values.
- ACount
- BCounta
- CCoutblank
- DIf
- ENper
35___________ evaluates true and false statements.
- ACount
- BCounta
- CCountblank
- DIf
- ENper
36__________ includes text, but not blank cells.
- ACount
- BCounta
- CCountblank
- DIf
- ENper
37Which type if preferable when the category names are long?
- AColumn
- BBar
- CPie
- DStacked Column
38How many variations of the stock chart does Excel have?
- A1
- B2
- C3
- D4
39What icon is NOT displayed when you select a chart?
- AChart Elements
- BChart Types
- CChart styles
- DChart filters
40Which chart type CANNOT be displayed as a sparkline?
- ABar chart
- BLine chart
- CColumn
- DWin/Loss
41A stacked column chart displays multiple columns for each category.
- ATrue
- BFalse
42_________ holds the entire chart.
- AX-axis
- BY-axis
- CChart area
- DPlot area
- ELegend
43Which of the following is NOT a chart type?
- ACircle
- BPie
- CBar
- DLine
44Both axes form a border for this.
- AX-axis
- BY-axis
- CChart area
- DPlot area
- ELegend
45What chart type can display two different chart types at the same?
- ACombo
- BMixed
- CDual
- DMultiple
46Which of the following is NOT a category of functions?
- ALogical
- BFinancial
- CStatistical
- DGraphing
47What do you use to separate arguments in a function?
- APeriod
- BSemi - colon
- CComma
- DColon
48What is NOT a direct option on the AutoSum drop down menu?
- AMedian
- BSum
- CCount
- DMax
49__________ is the length of time you will be paying on a loan.
- ACount
- BCounta
- CCountblank
- DIf
- ENper
50_________ only includes empty cells.
- ACount
- BCounta
- CCountblank
- DIf
- ENper
51The filter "Begins With..." option is found on which type of filter?
- ANumber filter
- BDate filter
- CCustom filter
- DText filter
52Where does Excel display the Total row in a table?
- AAt the top of the table
- BAfter each subtotal in the table
- CTwo rows below the last row in the table
- DBelow the last row in the table
53Which of the following is NOT a conditional formatting option?
- AData bars
- BColor scales
- CIcon sets
- DTable format
54Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?
- ATop/bottom rules
- BHighlight cells rules
- CBetween Values Rules
- DColor Scales
55Which of the following options is is sorted Z to A?
- ANumber; Othniel; Psycology
- B11/20/2015; 8/20/2015; 5/25/91
- C58; 29; 27
- DKaren; Doug; Barb
56Which of the following os sorted Oldest to Newest?
- ANumber; Othneil; Psychology
- B11/20/2015; 8/20/2015; 5/25/91
- C58; 29; 27
- D1/16/1957; 12/26/1959; 1/7/87
- EKaren; Doug; Barb
57Which of the following is sorted Largest to Smallest?
- ANumber; Othneil; Psychology
- B11/20/2015; 8/20/2015; 5/25/91
- C58; 29; 27
- D1/16/1957; 12/26/1959; 1/7/87
- EKaren; Doug; Barb
58Which of the following is sorted A to Z?
- ANumber; Othneil; Psychology
- B11/20/2015; 8/20/2015; 5/25/91
- C58; 29; 27
- D1/16/1957; 12/26/1959; 1/7/87
- EKaren; Doug; Barb
59Which of the following is sorted Newest to Oldest?
- ANumber; Othneil; Psychology
- B11/20/2015; 8/20/2015; 5/25/91
- C58; 29; 27
- D1/16/1957; 12/26/1959; 1/7/87
- EKaren; Doug; Barb
60In a structured reference, what do you use to indicate a column heading or field name?
- ABrackets []
- BParenthesis ()
- CCurly brackets {}
- DQuotes ""
61What order is this? [Jan. 16, 1957; Dec. 26, 1959; December 25, 2000; Jan 1, 2015]
- AAscending order
- BDescending order
62Where data will print on the next page is referred to as ___________.
- APrint Area
- BPrint Order
- CPage Break
- DFreezing
- EConditional formatting
63The range of cells that will be printed is referred to as ______________.
- APrint Area
- BPrint Order
- CPage Break
- DFreezing
- EConditional formatting
64Rules to emphasize cells are referred to as_____________.
- APrint area
- BPrint order
- CPage break
- DFreezing
- EConditional Formatting
65In data table calculated columns will copy down the table automatically.
- ATrue
- BFalse
66___________ keeps certain rows or columns on the screen at all times.
- APrint area
- BPrint order
- CPage break
- DFreezing
- EConditional Formatting
67______________ is the sequence of printed pages.
- APrint area
- BPrint Order
- CPage Order
- DFreezing
- EConditional formatting
68Using the data bars conditional formatting, how is the highest value represented?
- ABy the darkest bar
- BBy the tallest bar
- CBy the longest bar
- DBy the most number of bars
69Locking is the process of making sure that certain rows or columns are visible at all times.
- ATrue
- BFalse
70When you use the freeze panes option you are freezing both columns and rows.
- ATrue
- BFalse
71Which of the following is NOT a freeze option?
- AFreeze Panes
- BFreeze Top Row
- CFreeze First Column
- DFreeze Section
72On which tab will you find options if you have to print a large dataset?
- APage Layout
- BPrint
- CReview
- DHome
73What is TRUE about adding a new field to the right side of an existing data table?
- AYou must convert the table back to a range, add the field, then recreate the table
- BYou can add it to the right of the data table and Excel will extend the table to include the new field
- CYou CANNOT add a new field to an existing data table
- DYou must insert the new field somewhere inside the existing table, then move the columns to the order you desire
74It is a good practice to print column and row labels on each page
- ATrue
- BFalse
75Excel uses solid blue lines to indicate automatic page breaks
- ATrue
- BFalse
76Free
- ASpongebob
- BRick and morty
77A(n) __________ is a user defined field that derives its value by performing calculations on other fields in a PivotTable.
- AValue function
- BDataset variable
- CUser field
- DCalculated field
78Chef?
- ATrue
- BFalse
79A PivotTable is limited to a single table of data.
- ATrue
- BFalse
80A PivotChart has live updates as you change the PivotTable
- ATrue
- BFalse
81The first field in this area creates a filter that appears in cell B1:
- AROWS area
- BCOLUMNS area
- CSlicer
- DVALUES area
- EFILTERS area
82Fields added to this area have a calculation of some sort applied:
- AROWS area
- BCOLUMNS area
- CFILTERS area
- DSlicer
- EVALUES area
83A small window containing one button for each unique item in a field is:
- AROWS area
- BCOLUMNS area
- CFILTERS area
- DSlicer
- EVALUES area
84The field(s) used to organize a PivotTable along the left side of the table.
- AROWS area
- BCOLUMNS area
- CFILTERS area
- DSlicer
- EVALUES area
85The fields(s) used to organize a PivotTable along the top of the table
- AROWS area
- BCOLUMNS area
- CFILTERS area
- DSlicer
- EVALUES area
86How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number sold, and Extended price?
- ARemove Date from any PivotTable area
- BDrag date to the ROWS area and group it
- CDrag the date field to the FILTERS area
- DYou must use a slicer with dates
87Which of the following would be an effective calculated field labeled Retail Price to a calculate a retail price that is 300% of wholesale price
- AJimmy
- Bcarl
88A subtotal row must contain at least one _______ function.
- AFinancial
- BSort
- CAggregate
- DSum
89The_________ function is the default summary statistic for PivotTables
- ASum
- BAverage
- CMax
- DMin
90Which is an effective way to change a SUM of a price field in the VALUES area to an AVERAGE function?
- ASelect the appropriate cell in the PivotTable and type =AVERAGE(Price)
- BClick the AVERAGE button in the Analyze tab
- CRight click the appropriate cell and select AVERAGE from the mini-tool bar
- DClick the fields arrow in the VALUES area and select Value Field settings
91You created a PivotTable and later made changes to values in the underlying data. What happens to the PivoTable?
- AThe PivotTable updates automatically when you make changes to the dataset
- BExcel gives an error message that data has changed and the PivotTable may no longer be accurate
- CChanges in the dataset do not affect the PivotTable until you refresh the PivotTable
- DExcel deletes the PivotTable automatically so you can recreate it
92A(n) ____________ is the association between tables where both tables contain a common field.
- ALink
- BData Model
- CRelationship
- DShare Point
93Auto Outline creates an outline based on data structure.
- ATrue
- BFalse
94A calculated field must be built in the original data set
- ATrue
- BFalse
95A memo of indeterminate length would have which field type?
- AShort Text
- BLong Text
- CNumber
- DDate/ Time
- ECurrency
96A phone number would have which field type?
- AShort Text
- BLong Text
- CNumber
- DDate/Time
- ECurrency
97A persons birthdate would have which field type?
- AShort Text
- BLong Text
- CNumber
- DDate/Time
- ECurrency
98Years of service would have which field type?
- AShort Text
- BLong Text
- CNumber
- DDate/Time
- ECurrency
99Financial info would have which field type?
- AShort Text
- BLong Text
- CNumber
- DDate/Time
- ECurrency
100When first designing a database it is NOT important what data type you assign each field because you can easily change it later
- ATrue
- BFalse
101Which field property would you use to insure that all the phone numbers looked consistent?
- ACaption
- BFormat
- CDefault Value
- DInput mask
102If you wanted to add January 16, 1957 as text criteria, how would you enter it?
- AJanuary 16, 1957
- B#January 16, 1957#
- C=January 16, 1957
- D"January 16, 1957"
103Enforcing referential integrity assures that_________.
- AYou cannot enter a value in the foreign key if there is no corresponding value in the primary key
- BYou cannot enter the same value in the foreign key of the same table
- CYou cannot leave that field empty
- DYou cannot enter invalid or incorrect info
104When you purchase from a store several times this would be an example of what kind of table relationship?
- AMany-to-one (many purchases-one customer)
- BOne-to-one (one customer - one store)
- CMany-to-many (many items purchased - many times)
- DOne-to-many (one customer - many purchases)
105When you run a query, it displays in what view?
- ADesign
- BLayout
- CPrint Preview
- DDatasheet
106When does access save a record?
- AWhen you press the save icon
- BWhen you move to a different field
- CWhen you move to a different record
- DWhen you close the form or table
107For security purposes you want to have data redundancy in your tables
- ATrue
- BFalse
108In Datasheet view, what does a pencil symbol to the left of a record indicate?
- AData in that record has not been saved yet
- BData in that record has recently been modified and saved
- CData in that record has data integrity violation and needs to be changed
- DData in that record is about to be deleted
109To assign a field size of 12 to a field you would________.
- APick short text from the data type first
- BPick long text from the Data type list
- CType 12 in the description area of the field
- DEnter 12 in the field size property of that field
110To view or modify a tables structure you would go to what view?
- ADatasheet
- BForm
- CDesign
- DLayout
111What interface element shows you the various objects in your database?
- AThe database tools menu
- BThe database properties pane
- CThe home menu
- DThe navigation pane
112What are the two ways you can view a table?
- ADesign and layout views
- BDesign and datasheet views
- CDatasheet and form views
- DDatasheet and layout views
113What view normally appears when you double- click a table?
- AForm view
- BLayout view
- CDesign view
- DDatasheet view
114Your birthday would be a good candidate for a primary key
- ATrue
- BFalse
115Which of the following is examples of filter criterion?
- ALastName, FirstName, CellPhone
- BAutoNumber, Sort Text, Number
- CSocial Security Number, Student ID, AutoNumber
- D<>4,>2000,"Fred"
- EValidation Rule, Field Size, Caption
116Which of the following is examples of field properties?
- ALastName, FirstName, CellPhone
- BAutoNumber, ShortText, Number
- CSocial Security Number, Student ID, AutoNumber
- D<>4,>2000, = “Fred”
- EValidation Rule, Field Size, Caption
117Which of following is examples of field names?
- ALastName, FirstName, CellPhone
- BAutoNumber, ShortText, Number
- CSocial Security Number, Student ID, AutoNumber
- D<>4,>2000, = “Fred”
- EValidation Rule, Field Size, Caption
118Which of the following is examples of primary keys?
- ALastName, FirstName, CellPhone
- BAutoNumber, ShortText, Number
- CSocial Security Number, Student ID, AutoNumber
- D<>4,>2000, = “Fred”
- EValidation Rule, Field Size, Caption
119Which of the following is examples of Data types?
- ALastName, FirstName, CellPhone
- BAutoNumber, ShortText, Number
- CSocial Security Number, Student ID, AutoNumber
- D<>4,>2000, = “Fred”
- EValidation Rule, Field Size, Caption
120Calculated fields must always contain at least one constant.
- ATrue
- BFalse
121Two good ways to test the results of a calculated field is to use a calculator or Excel
- ATrue
- BFalse
122Access will calculate exactly what you tell it to calculate, even of you make the logical errors in the calculation
- ATrue
- BFalse
123What can help you build more complex expressions in calculated fields?
- AProperty sheet
- BDesign view
- CExpression Builder
- DExpression Creator
124As what does Access refer to aggregate function?
- ASums
- BComplex functions
- CWhole Column Functions
- DTotals
125Where does the total row of an aggregate function display its results?
- ALast row in data sheet view
- BFirst row in data sheet view
- COnly row in data sheet view
- DIt does not display in data sheet view
126A calculation preformed on a column that returns one value is:
- AA total row
- BA totals query
- CA property sheet
- DAn expression builder
- EAn aggregate function
127A way to display aggregate function results when a query is run is:
- AA total row
- BA totals query
- CA property sheet
- DAn expression builder
- EAn aggregate function
128A tool used to create complicated expression is:
- AA total row
- BA totals query
- CA property sheet
- DAn expression builder
- EAn aggregate function
129This is where you can change the number of decimals:
- AA total row
- BA totals query
- CA property sheet
- DAn expression builder
- EAn aggregate function
130This displays aggregate function results as the last row in a table or query:
- AA total row
- BA totals query
- CA property sheet
- DAn expression builder
- EAn aggregate function
131What button do you click to see the results of a query?
- AGo
- BQuery
- CView
- DRun
132You can add multiple levels of grouping to a Totals query
- ATrue
- BFalse
133Which of the following is NOT a airitmatic operator?
- A>
- B-
- C+
- D*
134Which element will you NEVER find in a calculated field?
- AArithmetic Operator
- BConstant
- CFunction
- DMacro
135Which of the following is a formula?
- A58
- B=9*2
- C(rate,num_periods, present_value, future_value, type)
- D<<Rate>>
- E=Sum
136Which of the following is a function?
- A58
- B=9*2
- C(rate,num_periods, present_value, future_value, type)
- D<<Rate>>
- E=Sum
137Which of the following is an argument?
- A58
- B=9*2
- C(rate,num_periods, present_value, future_value, type)
- D<<Rate>>
- E=Sum
138Which of the following is an expression?
- A58
- B=9*2
- C(rate,num_periods, present_value, future_value, type)
- D<<Rate>>
- E=Sum
139Which of the following is a constant?
- A58
- B=9*2
- C(rate,num_periods, present_value, future_value, type)
- D<<Rate>>
- E=Sum
140What sheet will allow you to change the formatting of a field in a query?
- AFormatting
- BModify
- CBuild
- DProperty
141What allows you to summarize data by the values of a field?
- AAdding a summarizing field
- BAdding the proper calculated field
- CAdding grouping to a query
- DAdding an update field
142When you want to add a condition to a totals query, which option do you select from the Totals row list?
- AWhen
- BGroup
- CWhere
- DCondition
143What symbols does Access use to indicate a field name?
- A{}
- B()
- C[]
- D""
144What is a type of field that displays the results of an expression rather than the data stored in a field?
- ACalculated
- BLookup
- CAutoNumber
- DHyperlink
Information
- Description
- Quiz on OMIS, created by Jack M on 05/12/2017.
- Author
- Jack M
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz