Excel - Online Assessment

45 Questions | By DSakmar | Last updated: Mar 21, 2022 | Total Attempts: 150

Questions

Settings

Create your own Quiz

Questions and Answers

1.

The symbol for division is...
- A.
  
  $
- B.
  
  \
- C.
  
  *
2.

What is a pivot table?
- A.
  
  A report
- B.
  
  An advanced filter
- C.
  
  A filter
- D.
  
  Vlookup
3.

An nested if statement only allows for one argument?
- A.
  
  True
- B.
  
  False
4.

If the range lookup is false in a vlookup what does it mean?
- A.
  
  The result will return an exact match
- B.
  
  The result will return the nearest match
- C.
  
  It will return a negative
- D.
  
  None of the above
5.

By default how many worksheets are in a workbook?
- A.
  
  1
- B.
  
  2
- C.
  
  3
- D.
  
  4
6.

How many conditions can the sumif check for?
- A.
  
  1
- B.
  
  2
- C.
  
  3
- D.
  
  4
7.

A macro is a part of a conditional format?
- A.
  
  True
- B.
  
  False
8.

A template is a worksheet which has all the necessary features you require?
- A.
  
  True
- B.
  
  False
9.

What is a scenario?
- A.
  
  Figures which switch between varying amounts
- B.
  
  A conditional format
- C.
  
  A macro
- D.
  
  An IF statement
10.

The sumif function has the...... range, criteria, sum_range?
- A.
  
  True
- B.
  
  False
11.

A lookup table counts the columns in the Col_index_No and not the cell reference?
- A.
  
  True
- B.
  
  False
12.

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
13.

What command combines several cells into one cell ocupying the same screen space?
- A.
  
  Merge and Center
- B.
  
  Align
- C.
  
  Freeze columns
- D.
  
  Indent
- E.
  
  Split
14.

How would the cell reference $F$4 be described?
- A.
  
  Mixed reference
- B.
  
  Absolute reference
- C.
  
  Relative reference
- D.
  
  Additional reference
- E.
  
  Money reference
15.

What type of operation is being preformed in the formula =A4*B5
- A.
  
  Addition
- B.
  
  Subtraction
- C.
  
  Division
- D.
  
  Percentage
- E.
  
  Multiplication
16.

Which orientation is taller than it is wide?
- A.
  
  Landscape
- B.
  
  Portrait
17.

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
18.

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
19.

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
20.

Name the function that adds cell values only if they meet your criteria.
- A.
  
  Average()
- B.
  
  Count()
- C.
  
  Mean()
- D.
  
  SumIF()
- E.
  
  Round
21.

What function would display the highest sales amount in a column?
- A.
  
  Min()
- B.
  
  Avg()
- C.
  
  Max()
- D.
  
  Most()
- E.
  
  Sum()
22.

Which logical function shows the opposite of the condition?
- A.
  
  NOT function
- B.
  
  False function
- C.
  
  Nper function
- D.
  
  Sum function
- E.
  
  PMT function
23.

What is the term used to describe a function inside a function?
- A.
  
  Conditional
- B.
  
  Argument
- C.
  
  Nested
- D.
  
  Double
- E.
  
  Hyperlink
24.

What does a hyperlink do?
- A.
  
  Adds another argument
- B.
  
  Displays a website
- C.
  
  Formats worksheet
- D.
  
  Hides worksheets
25.

Which function enters the current date?
- A.
  
  Now()
- B.
  
  Days()
- C.
  
  DDYYMM
- D.
  
  TODAY()

Related Topics

More Online Assessment Quizzes

Assessment Of Learning Quiz Questions And Answers

Test your knowledge with these "Assessment of learning quiz questions and answers." This quiz is based on Assessment of learning, so all the questions will be around that topic only. If you want to test your...

Questions: 15 | Attempts: 18727 | Last updated: Mar 22, 2022

Sample Question
Diagnostic assessment is?

Assessment "for" Learning

Assessment "as" Learning

Assessment "of" Learning

Pre-assessment Test â€“ Billing And Accounts Receivable

This pre-test will gauge your basic understanding on Billing and AR module based on the webinars and recordings you listened during the first week of onboarding. The instructor will use this tool to determine which area or...

Questions: 15 | Attempts: 4620 | Last updated: Mar 22, 2022

Sample Question
This is a three-line billing description that will print at the top of the bill. This description includes prime and other contract number, billing address and contract/task name.

Header Information

Contract Information

Budget Information