MS Excel 2016 Test: Quiz!
(170).jpg "MS Excel 2016 Test: Quiz! - Quiz")
.
- 1.What is the keyboard shortcut command to move the mouse pointer to cell A1?
- A.
Control + Home
- B.
Control + F4 key
- C.
Name box
- D.
Control + A1
- E.
Control + Tab key
- 2.A workbook contains:
- A.
1 worksheet
- B.
2 worksheets
- C.
3 worksheets
- D.
4 worksheets
- E.
No worksheets
- 3.The feature that enables you to automatically complete a list of 12 months after you key one month is:
- A.
Cell style
- B.
Fill handle or Autofill
- C.
Page layout
- D.
Find
- E.
Replace
- 4.What is the default alignment for values and dates in a cell?
- A.
Justified
- B.
Left aligned
- C.
Centered
- D.
Bottom aligned
- E.
Right aligned
- 5.How would the cell reference $F$4 be described?
- A.
Mixed reference
- B.
Absolute reference
- C.
Relative reference
- D.
Additional reference
- E.
Money reference
- 6.What type of operation is being performed in the formula =A4*B5?
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
- 7.Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
- 8.What term describes a model workbook used as the basis for other workbooks?
- A.
Form
- B.
Demonstration
- C.
Template
- D.
Cell styles
- E.
Page Layout
- 9.How can you start Edit mode to edit a formula?
- A.
Tools
- B.
Format
- C.
F4
- D.
F2 or double-click cell
- E.
Find and replace
- 10.Three types of data visualation are:
- A.
Tools, Columns, Styles
- B.
Data bars, Color scales, Icon sets
- C.
Cell styles, Bold, Italics
- D.
Home, Edit, Fill
- E.
Shapes, Arrows, Clip art
- 11.Name the function that adds cell values only if they meet your criteria.
- A.
Average()
- B.
Count()
- C.
Mean()
- D.
SumIF()
- E.
Round
- 12.What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
- 13.Which logical function shows the opposite of the condition?
- A.
NOT function
- B.
False function
- C.
Nper function
- D.
Sum function
- E.
PMT function
- 14.Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?
- A.
NPER function
- B.
Sum function
- C.
FV function
- D.
PMT function
- E.
Today function
- 15.What is the term used to describe a function inside a function?
- A.
Conditional
- B.
Argument
- C.
Nested
- D.
Double
- E.
Hyperlink
- 16.What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
- 17.Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
- 18.How would Excel display this value =ROUND(1.567) in the cell?
- A.
1
- B.
2
- C.
1.57
- D.
1.6
- 19.What does Excel do if a function is volatile?
- A.
Renames the workbook
- B.
Closes the program
- C.
Recaculates it based on the computer where it is opened
- D.
Nothing changes
- 20.What does the VLOOKUP function do?
- A.
Looks up text that contain ‘v’
- B.
Checks whether text is the same in one cell as in the next
- C.
Finds related records
- D.
All of above
- 21.How are data organized in a spreadsheet?
- A.
Lines and spaces
- B.
Layers and planes
- C.
Rows and columns
- D.
Height and width
- 22.Which types of charts can excel produce?
- A.
Line graphs and pie charts only
- B.
Only line graphs
- C.
Bar charts, line graphs and pie charts
- D.
Bar charts and line graphs only
- 23.Each excel file is called a workbook because:
- A.
It can contain text and data
- B.
It can be modified
- C.
It can contain many sheets including worksheets and chart sheets
- D.
You have to work hard to create it
- 24.Excel is a:
- A.
Graphic program
- B.
None of these
- C.
Word processor
- D.
A spreadsheet
- 25.A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
- A.
Go to File-Save As – Save As Type – Excel worksheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select Insert – Entire Column
- D.
None of above
Questions: 14 | Attempts: 10205 | Last updated: Mar 22, 2022
-
Sample Question_______, ________ and _______are what you see when you open Excel
Questions: 20 | Attempts: 3027 | Last updated: Mar 20, 2022
-
Sample QuestionA fast way to add up this column of numbers is to click in the cell below the numbers and then:
Questions: 40 | Attempts: 1022 | Last updated: Mar 22, 2022
-
Sample QuestionWhat is the keyboard shortcut command to move the mouse pointer to cell A1?
Back to top