Quiz
OMIS
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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.
- AVerdadeiro
- BFalso
17The cell at row 4 and column B would be identified as 4B.
- AVerdadeiro
- BFalso
18For the fill handle to work you need to have two cells selected.
- AVerdadeiro
- BFalso
19Right-clicking a column heading, then selecting insert, will add a new column to the left of the current column.
- AVerdadeiro
- BFalso
20When you copy and paste a range the relative referance does not change.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
70When you use the freeze panes option you are freezing both columns and rows.
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
75Excel uses solid blue lines to indicate automatic page breaks
- AVerdadeiro
- BFalso
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?
- AVerdadeiro
- BFalso
79A PivotTable is limited to a single table of data.
- AVerdadeiro
- BFalso
80A PivotChart has live updates as you change the PivotTable
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
94A calculated field must be built in the original data set
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
121Two good ways to test the results of a calculated field is to use a calculator or Excel
- AVerdadeiro
- BFalso
122Access will calculate exactly what you tell it to calculate, even of you make the logical errors in the calculation
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
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
Informações
- Descrição
- Quiz sobre OMIS, criado por Jack M em 05-12-2017.
- Autor
- Jack M
- Idioma
- English
- Visualizações
- 0
- Avaliação
- Ainda sem avaliações Avalie este quiz